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 Format: | Multiple Choice, Multiple Response, Case Study, Scenario-based Questions |
| Real Exam Qty: | 40-60 |
| Exam Price: | USD 150 |
| Available Languages: | English |
| Exam Duration: | 120 minutes |
| Certificate Validity Period: | Legacy certification (retired; validity subject to Microsoft certification policy at the time earned) |
| Related Certifications: | MCSE: Data Platform MCITP: Database Administrator 2008 MCITP: Database Developer 2008 |
| Passing Score: | 700/1000 |
| 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 |
|---|---|
| Design Database Solutions | - Logical and physical database design
|
| Implement and Manage Database Objects | - Database programmability
|
| Performance Optimization | - Query and workload tuning
|
| High Availability and Data Protection | - Business continuity
|
| Security and Administration | - Database security management
|
| Data Integration and Business Intelligence | - Data platform features
|
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
1. 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.
2. 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.
A) a data-tier application
B) SQL Server Integration Services (SSIS)
C) change data capture
D) a database snapshot
E) SQL Data Sync
3. You need to configure security on the Product table for customer support representatives.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.
A) Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice.
B) Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice.
C) Create a view called CustProduct that includes columns ProductID. ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierID.
D) GRANT SELECT on CustProduct TO OurDomain\CustomerSupport.
E) GRANT SELECT on CustProduct TO public.
F) GRANT ALL on CustProduct TO OurDomain\CustomerSupport
4. You need to recommend an isolation level for usp_UpdateOrderDetails.
Which isolation level should recommend?
A) repeatable read
B) read committed
C) serializable
D) read uncommitted
5. You need to recommend a disk monitoring solution that meets the business requirements.
What should you include in the recommendation?
A) an audit
B) a SQL Server Agent alert
C) a dynamic management view
D) a maintenance plan
Solutions:
| Question # 1 Answer: Only visible for members | Question # 2 Answer: B | Question # 3 Answer: C,D | Question # 4 Answer: A | Question # 5 Answer: C |
By Luther
