We're so confident of our products that we provide no hassle product exchange.
Microsoft 070-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 |
| Real Exam Qty: | 40-60 |
| Passing Score: | 700/1000 |
| Exam Price: | USD 150 |
| Exam Format: | Multiple Choice, Multiple Response, Case Study, Scenario-based Questions |
| Exam Duration: | 120 minutes |
| Certificate Validity Period: | Legacy certification (retired; validity subject to Microsoft certification policy at the time earned) |
| Available Languages: | English |
| Related Certifications: | MCSE: Data Platform MCITP: Database Administrator 2008 MCITP: Database Developer 2008 |
| Sample Questions: | Microsoft 070-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 070-459 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Implement and Manage Database Objects | - Database programmability
|
| Topic 2: Security and Administration | - Database security management
|
| Topic 3: Design Database Solutions | - Logical and physical database design
|
| Topic 4: High Availability and Data Protection | - Business continuity
|
| Topic 5: Data Integration and Business Intelligence | - Data platform features
|
| Topic 6: Performance Optimization | - Query and workload tuning
|
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
1. DRAG DROP
You plan to install two SQL Server 2012 environments named Environmentl and Environment2.
Your company identifies the following availability requirements for each environment:
- Environment1 must have mirroring with automatic failover implemented. - Environment2 must have AlwaysOn with automatic failover implemented.
You need to identify the minimum number of SQL Server 2012 servers that must be deployed to each environment to ensure that all data remains available if a physical server fails.
How many servers should you identify?
To answer, drag the appropriate number to the correct environment in the answer area.
2. You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort.
Which code should you use?
A) Option B
B) Option D
C) Option A
D) Option C
3. You need to recommend a solution to allow application users to perform UPDATE operations on the database tables. The solution must meet the business requirements.
What should you recommend?
A) Create a user-defined database role and add users to the role.
B) Create a Policy-Based Management Policy.
C) Create functions that use EXECUTE AS clauses.
D) Create stored procedures that use EXECUTE AS clauses.
4. You have an index for a table in a SQL Azure database. The database is used for Online Transaction Processing (OLTP).
You discover that many page splits occur when records are inserted or updated in the table.
You need to minimize the number of page splits.
What should you set from the index options?
A) STATISTICS_NORECOMPUTE = ON
B) FILLFACTOR = 0
C) STATISTICS_NORECOMPUTE = OFF
D) FILLFACTOR = 80
5. You need to implement changes to the system to reduce contention and improve performance of the SalesOrderDetail table.
Which three actions should you perform? Each correct answer presents part of the solution. Choose three.
A) Use (TABLOCK) hints in the report queries
B) ALTER DATABASE [ProdDB] SET ALLOW.SNAPSHOT ISOLATION ON
C) SET TRANSACTION ISOLATION LEVEL SNAPSHOT
D) Use (SNAPSHOT] hints in the update statements
E) SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
F) ALTER DATABASE [ProdDB] SET READ_COMMITTED_SNAPSHOT OFF
G) ALTER DATABASE [ProdDB] SET READ_COMMITTED_SNAPSHOT ON
H) Use (SNAPSHOT] hints in the report queries
Solutions:
| Question # 1 Answer: Only visible for members | Question # 2 Answer: C | Question # 3 Answer: D | Question # 4 Answer: D | Question # 5 Answer: E,G,H |
By Maxwell
