We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-450 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 |
| Exam Number: | 70-450 |
| Exam Duration: | 120 minutes |
| Certificate Validity Period: | Certification retired; historical certification validity depended on Microsoft certification policy at the time |
| Available Languages: | English, Japanese, Chinese (Simplified), Chinese (Traditional), French, German, Spanish, Portuguese (Brazil) |
| Exam Price: | USD 125 |
| Real Exam Qty: | 40-60 |
| Related Certifications: | Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development Microsoft Certified IT Professional (MCITP): Database Administrator 2008 |
| Exam Format: | Multiple Choice, Case Studies, Drag and Drop, Hot Area |
| Passing Score: | 700 |
| Recommended Training: | Microsoft Learning - SQL Server 2008 Training (Historical) |
| Exam Registration: | Microsoft Certification Exam Registration (Historical) |
| Sample Questions: | Microsoft 70-450 Sample Questions |
| Exam Way: | Delivered through authorized testing centers (Prometric at the time of availability) |
| Pre Condition: | Candidates typically needed to hold or be pursuing the MCITP: Database Administrator 2008 certification path. Recommended experience included SQL Server 2008 database administration and enterprise database solution design. |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/previous-versions/learning/exam-70-450 |
Microsoft 70-450 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Design and implement a database infrastructure | - Design database storage solutions
|
| Topic 2: Design and implement database availability solutions | - Design backup and recovery strategies
|
| Topic 3: Optimize database performance | - Monitor and troubleshoot database performance
|
| Topic 4: Maintain databases | - Manage data movement and integration
|
Microsoft PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu Sample Questions:
1. You administer a SQL Server 2008 infrastructure.
An instance runs on a computer that has eight quad-core processors and 128-GB RAM.
Four different applications use the instance.
The instance experiences a low number of CXPACKET waits.
The instance also experiences a large number of lazy writer waits.
You need to optimize the performance of the instance.
What should you do?
A) Configure an increase in the maximum degree of parallelism option.
B) Configure software non-uniform memory access (soft-NUMA).
C) Configure the Resource Governor.
D) Configure the Windows System Resource Manager.
2. You are a professional level SQL Sever 2008 Database Administrator.
After a regular test, you find that performance degradation is experienced by an instance for the three reasons:
Excessive CPU usage, Server processes paging and Deadlocks
A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues and detailed deadlock information should be contained in the provided data.
You should utilize the least amount of administrative effort to finish the task.
Which tool will you utilize to finish the task?
A) To finish the task, you should utilize Resource Governor.
B) To finish the task, you should utilize Database Engine Tuning Advisor.
C) To finish the task, you should utilize Extended Events.
D) To finish the task, you should utilize Performance Monitor (SYSMON).
3. You administer a SQL Server 2008 infrastructure.
You plan to deploy a new SQL Server 2008 multi-node failover cluster. The failover cluster uses a storage
area network (SAN)
that will use redundant array of independent disks (RAID) level 5.
You need to format the logical unit numbers (LUNs) for optimal performance of the database data files.
Which of the following is the best allocation unit size you should use?
A) 32-KB
B) 64-KB
C) 8-KB
D) 156-KB
4. You are a professional level SQL Sever 2008 Database Administrator.
All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE statements are utilized by the procedures. A backup strategy should be implemented.
The business requirements listed below should be satisfied:
Point-in-time recovery for failure is supported by the backup strategy at any time of day.
The least amount of disk space should be utilized by the transaction log.
Which action should you perform to finish the task?
A) To finish the task, hourly database snapshots should be utilized.
B) To finish the task, the full-recovery model along with differential backups should be utilized.
C) To finish the task, the simple-recovery model along with differential backups should be utilized.
D) To finish the task, the full-recovery model along with transaction log backups should be utilized.
5. You are a professional level SQL Sever 2008 Database Administrator.
After a regular test, you find that performance degradation is experienced by an instance for the three reasons:
Excessive CPU usage, Server processes paging and Deadlocks
A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues and detailed deadlock information should be contained in the provided data.
You should utilize the least amount of administrative effort to finish the task.
Which tool will you utilize to finish the task?
A) To finish the task, you should utilize Resource Governor.
B) To finish the task, you should utilize Database Engine Tuning Advisor.
C) To finish the task, you should utilize Extended Events.
D) To finish the task, you should utilize Performance Monitor (SYSMON).
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: B | Question # 4 Answer: D | Question # 5 Answer: C |
By Doreen
