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 Price: | USD 165 (varies by region) |
| Certificate Validity Period: | Retired (historical certification exam) |
| Real Exam Qty: | 50-65 (varies) |
| Available Languages: | English, Japanese, Simplified Chinese, German, French |
| Passing Score: | 700 (out of 1000) |
| Related Certifications: | MCITP: Database Administrator 2008 MCITP: Database Developer 2008 MCSE: Data Platform |
| Exam Duration: | 120-180 |
| Exam Format: | Multiple choice, Case studies, Scenario-based questions |
| Recommended Training: | Microsoft Learn SQL Server Training SQL Server Database Administration Learning Path |
| Exam Registration: | Pearson VUE Microsoft Exams Microsoft Certification Portal |
| Sample Questions: | Microsoft 70-459 Sample Questions |
| Exam Way: | Proctored exam via Pearson VUE (online or onsite) |
| Pre Condition: | Recommended: MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 certification or equivalent SQL Server experience |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/70-459 |
Microsoft 70-459 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Performance and Monitoring | - System Monitoring
|
| Topic 2: SQL Server 2008/2012 Transition Concepts | - Schema and Data Transition
|
| Topic 3: Database Design and Development | - T-SQL Programming
|
| Topic 4: Administration and Maintenance | - Backup and Recovery
|
Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform Sample Questions:
1. DRAG DROP
You plan to deploy SQL Server 2012.
You must create two tables named Table 1 and Table 2 that will have the following
specifications:
- Table1 will contain a date column named Column1 that will contain a null value approximately 80 percent of the time.
- Table2 will contain a column named Column2 that is the product of two other columns in Table2.
Both Table1 and Table2 will contain more than 1 million rows.
You need to recommend which options must be defined for the columns. The solution must minimize the storage requirements for the tables.
Which options should you recommend?
To answer, drag the appropriate options to the correct column in the answer area.
2. You have a SQL Server 2012 database named database1. Database1 has a data file named databasel_data.mdf and a transaction log file named databaseljog.ldf. Databasel_data.mdf is 1.5 GB. Databaseljog.ldf is 1.5 terabytes.
A full backup of Database1 is performed every day.
You need to reduce the size of the log file. The solution must ensure that you can perform transaction log backups in the future.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
A) Option B
B) Option E
C) Option D
D) Option A
E) Option C
F) Option F
3. You need to recommend a solution that meets the data recovery requirement.
What should you include in the recommendation?
A) a transaction log backup
B) a differential backup
C) snapshot isolation
D) a database snapshot
4. You execute usp_TestSpeakers.
You discover that usp_SelectSpeakersByName uses inefficient execution plans.
You need to update usp_SelectSpeakersByName to ensure that the most efficient execution plan is used.
What should you add at line 30 of Procedures.sql?
A) OPTION (OPTIMIZE FOR (@LastName = 'Anderson'))
B) OPTION (FORCESEEK)
C) OPTION (FCRCESCAN)
D) OPTION (OPTIMIZE FOR UNKNOWN)
5. You need to create a function that will use a SELECT statement in ProductsByProductType.sql.
Which code segment should you use to complete the function?
A) Option B
B) Option D
C) Option A
D) Option C
Solutions:
| Question # 1 Answer: Only visible for members | Question # 2 Answer: B,C,D,E | Question # 3 Answer: D | Question # 4 Answer: D | Question # 5 Answer: B |
By Jo
