Online Access Free 070-450 Exam Questions

You administer a SQL Server 2008 instance.
You plan to deploy a new database to the instance. The database will be subject to frequent inserts and
updates.
The database will have multiple schemas. One of the schemas will contain a large amount of read-only
reference data.
You need to design the physical database structure for optimal backup performance.
What should you do?

• A.Create the database by using a single data file and multiple log files.
• B.Create the database by using a single data file and a single log file.
• C.Create the database by using a single log file and multiple filegroups.
• D.Create the database by using a single log file and a filegroup that has multiple data files.

You administer a SQL Server 2008 instance.
You plan to deploy multiple databases to the instance. You design the security policy for the instance.
A stored procedure verifies the partition compression settings on each database deployed to the instance.
You plan to use a policy to execute the stored procedure.
You need to ensure that the policy is enforced by using Policy-Based Management Framework.
What should you do?

• A.Enable the nested triggers server configuration option.
• B.Grant EXECUTE permissions on the stored procedure to the ##MS_PolicyTsqlExecutionLogin## login.
• C.Grant EXECUTE permissions on the stored procedure to the SQLAgent service account.
• D.Grant EXECUTE permissions on the stored procedure to the ##MS_PolicyEventProcessingLogin## login.

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.T-SQL Query collector
• B.SQL Trace collector
• C.Query Activity collector
• D.Performance Counters collector

You are a professional level SQL Sever 2008 Database Administrator.
A database is hosted by the instance. You can see the backup strategy utilized by the database from table listed below: A batch process is run on Saturday, and the process lasts from 21:00 hr to 23:00 hr; you find that the batch process takes no effect because certain data is modified some data by a user at 21:05 hr on the same day.

The database should be recovered to its state at the start of the batch process in the shortest time.
Which action will you perform?

• A.The full database backup that was performed on Thursday should be recovered. And then the differential backup that was performed on Friday should be recovered. At last, all transaction logs should be recovered from the time of the differential backup on Friday and should be stopped at 21:00 hr on Saturday.
• B.The full database backup that was performed on Saturday should be recovered. And then all transaction logs should be recovered from the time of the full backup on Saturday and should be stopped at 21:00 hr on Saturday.
• C.The full database backup that was performed on Saturday should be recovered.
• D.The full database backup that was performed on Thursday should be recovered. And then, all transaction logs should be recovered from the time of the full backup on Thursday and should be stopped at 21:00 hr on Saturday.

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