Administering a SQL Database Infrastructure — Question 127

You want to reproduce the same SQL Server 2016 installation configuration across five servers.
Which of the following files will you generate by using SQL Server Setup to accomplish this goal?

Answer options

• A. Configuration.xml
• B. Setup.ini
• C. Setup.xml
• D. ConfigurationFile.ini

Correct answer: D

Explanation

The correct answer is D, as the ConfigurationFile.ini is specifically designed to capture the configuration settings used during the SQL Server installation. The other options, such as Configuration.xml and Setup.ini, do not provide the same level of detail for replication of installation settings.