We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-459 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform |
| Exam Number: | 70-459 |
| Exam Duration: | 120 minutes |
| Available Languages: | English |
| Exam Price: | USD 150 |
| Related Certifications: | MCSE: Data Platform MCITP: Database Developer 2008 MCITP: Database Administrator 2008 |
| Real Exam Qty: | 40-60 |
| Passing Score: | 700/1000 |
| Exam Format: | Multiple Choice, Multiple Response, Case Study, Scenario-based Questions |
| Certificate Validity Period: | Legacy certification (retired; validity subject to Microsoft certification policy at the time earned) |
| Sample Questions: | Microsoft 70-459 Sample Questions |
| Exam Way: | Authorized Microsoft testing center (historically delivered through Prometric/Pearson VUE); exam is retired and no longer available for scheduling. |
| Pre Condition: | Intended for holders of MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 seeking to upgrade to MCSE: Data Platform. |
| Official Syllabus URL: | https://learn.microsoft.com/credentials/certifications/ |
Microsoft 70-459 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Performance Optimization | - Query and workload tuning
|
| Data Integration and Business Intelligence | - Data platform features
|
| Design Database Solutions | - Logical and physical database design
|
| Security and Administration | - Database security management
|
| Implement and Manage Database Objects | - Database programmability
|
| High Availability and Data Protection | - Business continuity
|
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
Question 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.
Question 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.
Question 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
Question 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.
Question 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 Mike
