MySQL 8.0 Database Administrator — Question 140

You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting data warehousing instance.
[mysql]
innodb_data_file_path=
Which two configurations would satisfy long-term storage demands? (Choose two.)

Answer options

• A. ibdatal:12M;ibdata2:12M;ibdata3:12M
• B. ibdatal:12M:autoextend;ibdata2:12M:autoextend
• C. ibdatal:12M:autoextend
• D. ibdatal:12M;ibdata2:12M:autoextend
• E. ibdatal:12M
• F. ibdatal:12M;/tmp/ibdata2:12M:autoextend

Correct answer: A, E

Explanation

The correct answers A and E provide sufficient long-term storage as option A includes multiple data files with fixed sizes, while option E has a single file configured. Options B, C, D, and F either do not support the necessary storage capacity or use autoextend, which may not be ideal for a long-term stable configuration.