You are a professional level SQL Sever 2008 Database Administrator.
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?

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

You administer a SQL Server 2008 infrastructure.
Humongous Insurance has 20 branch offices that store customer data in SQL Server 2008 databases. Customer data that is stored across multiple database instances has to be security compliant.
You plan to design a strategy for custom policies by using the Policy-Based Management feature. Custom policies are in XML format.
The strategy must meet the following requirements:
Custom policies are distributed to all instances.
The policies are enforced on all instances.
You need to implement the strategy by using the least amount of administrative effort.
What should you do?

• A. Distribute the policies by using Group Policy Objects.
• B. Use a configuration server.
• C. Distribute the policies by using the Active Directory directory service
• D. Use the Distributed File System Replication service.

You administer a SQL Server 2008 instance.
The instance is using a 32-bit version on a Windows Server 2008 64-bit server. The awe enabled option is
enabled.
The instance will experience a predictable increase in query activity.
You plan to ascertain the appropriate time when the migration of the databases to a 64-bit SQL Server 2008
server
on the same hardware is beneficial.
You need to identify a data collector type that provides the appropriate information.
Which collector should you use?

• A. SQL Trace collector
• B. Performance Counters collector
• C. T-SQL Query collector
• D. Query Activity collector

You are a professional level SQL Sever 2008 Database Administrator.
An authentication method should be designed for SSRS reports that SQL Server data connections are utilized.
Since you are the technical support of the company, you are required to make sure that all SSRS reports utilize the Kerberos authentication protocol to communicate to the SQL Server instance.
Which action should you perform?

• A. The application pool utilized by the default Web site should be set to utilize a domain account.
• B. The default Web site on the instance should be set to utilize the Secure Sockets Layer (SSL) protocol.
• C. A service principal name (SPN) should be registered in the Active Directory directory service for the SSRS instance.
• D. The default Web site should be set on the instance to utilize the Integrated Security type.

You administer a SQL Server 2008 instance. You plan to design a high-availability solution by using database mirroring.
The current application includes programming logic that will retry transactions if a failover occurs.
You need to configure a strategy that will provide the minimum amount of latency for committed transactions.
What should you do?

• A. Pause database mirroring.
• B. Configure automatic failover role switching.
• C. Configure manual failover role switching.
• D. Configure forced service role switching.