PrepAway - Latest Free Exam Questions & Answers

Which action should you perform?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance should be managed by you. A new database will be deployed to the instance.
Regular inserts and updates should be subjected by the database. There will be multiple schemas on the database.
A great number of read-only reference data should be contained by one of the schemas.
The physical database structure should be designed for optimal backup performance.
Which action should you perform?

PrepAway - Latest Free Exam Questions & Answers

A.
You should utilize a single log file and multiple filegroups to create the database.

B.
You should utilize a single data file and a single log file to create the database.

C.
You should utilize a single data file and multiple log files to create the database.

D.
You should utilize a single log file and a filegroup that has multiple data files to create the database.


Leave a Reply