Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform - 70-459 Exam Practice Test
You need to change the ProdDB database.
Which two database options should you change to meet the requirements? Each correct answer presents part of the solution. Choose two.
Which two database options should you change to meet the requirements? Each correct answer presents part of the solution. Choose two.
Correct Answer: C,F
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You need to provide referential integrity between the Sessions table and Speakers table.
Which code segment should you add at line 47 of Tables.sql?
Which code segment should you add at line 47 of Tables.sql?
Which code segment should you add at line 47 of Tables.sql?
Which code segment should you add at line 47 of Tables.sql?
Correct Answer: B
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Database.
Which method should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to recommend a repeatable method to migrate the database to SQL Database.
Which method should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: B
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
- The database schemas must be synchronized from SQLDev to SQLProd. - The database on SQLDev must be deployed to SQLProd by using a package. - The package must support being deployed to SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
You plan to synchronize SQLDev and SQLProd.
You need to recommend a solution that meets the following requirements:
- The database schemas must be synchronized from SQLDev to SQLProd. - The database on SQLDev must be deployed to SQLProd by using a package. - The package must support being deployed to SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You need to recommend a solution to minimize the amount of time it takes to execute USP_1.
With what should you recommend replacing Table1?
With what should you recommend replacing Table1?
Correct Answer: C
Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).
You need to implement security for the restore and audit process. What should you do?
Correct Answer: D
DRAG DROP
You are the senior database administrator at Contoso, Ltd. You manage a SQL Server 2014 Instance, with multiple databases used for reporting.
You have recently hired a junior database administrator. You want this person to be able to view the database structures on the server, but you do not want him or her to be able to make changes or see the data in the tables.
The new hire's login credentials are as follows:
Login name: JFree
Password: Jx672$qse
You want the new hire to be required to change his password on his next login.
The code that is produced should execute no matter the initial database context in which it is started.
You need to write the code required to give the new hire only the desired access, using the smallest number of steps. Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.
You are the senior database administrator at Contoso, Ltd. You manage a SQL Server 2014 Instance, with multiple databases used for reporting.
You have recently hired a junior database administrator. You want this person to be able to view the database structures on the server, but you do not want him or her to be able to make changes or see the data in the tables.
The new hire's login credentials are as follows:
Login name: JFree
Password: Jx672$qse
You want the new hire to be required to change his password on his next login.
The code that is produced should execute no matter the initial database context in which it is started.
You need to write the code required to give the new hire only the desired access, using the smallest number of steps. Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.
Correct Answer:
