We're so confident of our products that we provide no hassle product exchange.
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
1. You need to modify the stored procedure usp.LookupConcurrentUsers.
What should you do?
A) Use a table variable instead of the summary table.
B) Add a clustered columnstore index to the summary table.
C) Add a nonclustered index to the summary table.
D) Add a clustered index to the summary table.
2. You need to implement a backup strategy to support the requirements.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.
A) Create a share on your Windows Azure site by using your Windows Azure storage account information, and grant permission to the SQL Server service login.
B) Create a credential called MyCredential on SQL Server, using MyStorageAccount for the storage account name and StorageAccountKey for the access key.
C) Create a credential called MyCredential on SQL Server by using a Windows domain account and password.
D) Schedule a full backup by using the command BACKUP DATABASE ProdDB TO DISK...
E) Schedule a full backup by using the command BACKUP DATABASE ProdDB TO SHARE ... WITH CREDENTIAL=N' MyCredential'
F) Schedule a full backup by using the command BACKUP DATABASE ProdDB TO URL ... WTTH CREDENTIAL=N'MyCredential'
G) Create a share on the hot standby site and grant permission to the SQL Server service login.
3. You have a server named Server1 that has 16 processors.
You plan to deploy multiple instances of SQL Server 2012 to Server1.
You need to recommend a method to allocate processors to each instance.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.
A) Processor affinity
B) Max Degree of Parallelism
C) Windows System Resource Manager (WSRM)
D) Resource Governor
4. DRAG DROP
You need to implement a new version of usp_AddMobileLocation. Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.
5. ---
You have a database named database1.
Database developers report that there are many deadlocks.
You need to implement a solution to monitor the deadlocks. The solution must meet the following requirements:
Support real-time monitoring.
Be enabled and disabled easily.
Support querying of the monitored data.
What should you implement?
More than one answer choice may achieve the goal. Select the BEST answer.
A) log errors by using trace flag 1222
B) a SQL Server Profiler template
C) log errors by using trace flag 1204
D) an Extended Events session
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: A,F | Question # 3 Answer: A | Question # 4 Answer: Only visible for members | Question # 5 Answer: D |
By Herman
