Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform 認定 070-459 試験問題:

1. You are designing a database named DB1.
Changes will be deployed to DB1 every Wednesday night.
You need to recommend a strategy to deploy the changes to DB1. The strategy must meet
the following requirements:
The strategy must not disrupt backup operations.
DB1 must be online while the changes are deployed.
You must be able to undo quickly any changes made to objects.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
---

A) Create a database snapshot. If the deployment fails, revert the database to the database snapshot.
B) Perform a copy-only database backup before the changes are deployed. If the deployment fails, restore the database to another server and recover the original objects from the restored database.
C) Perform a full database backup before the changes are deployed. If the deployment fails, restore the database to another server and recover the original objects from the restored database.
D) Create a database snapshot. If the deployment fails, recover the objects from the database snapshot.

2. DRAG DROP
You need to recommend a backup process for data warehouse database.
The solution must meet the following requirements:
- Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions. - Minimize the amount of administrative effort required to restore any lost data. - Minimize the space used by transaction logs.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

3. DRAG DROP
You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements:
- Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure. - Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)

4. You need to recommend a solution for the deployment of SQL Server 2012. The solution must meet the business requirements.
What should you include in the recommendation?

A) Deploy two servers that have SQL Server 2012 installed. Implement AlwaysOn Availability Groups on both servers.
B) Install a new instance of SQL Server 2012 on the server that hosts the SQL Server 2005 instance. Deploy a new server that has SQL Server 2012 installed. Implement AlwaysOn.
C) Deploy two servers that have SQL Server 2012 installed and implement Failover Clustering.
D) Upgrade the existing SQL Server 2005 instance to SQL Server 2012. Deploy a new server that has SQL Server 2012 installed. Implement AlwaysOn.

5. DRAG DROP
You are designing an authentication strategy for a new server that has SQL Server 2012 installed.
The strategy must meet the following business requirements:
- The account used to generate reports must be allowed to make a connection during certain hours only. - Failed authentication requests must be logged.
You need to recommend a technology that meets each business requirement. The solution must minimize the amount of events that are logged.
Which technologies should you recommend?
To answer, drag the appropriate solution to the correct business requirement in the answer area.

質問と回答：