We're so confident of our products that we provide no hassle product exchange.
Microsoft 070-432 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | TS: MS SQL Server 2008, Implementation and Maintenance |
| Exam Number: | 70-432 |
| Passing Score: | Not officially disclosed |
| Exam Format: | Multiple choice, Scenario-based questions |
| Related Certifications: | MCITP: Database Administrator 2008 70-433 SQL Server 2008 Database Development 70-450 Designing, Optimizing and Maintaining a Database Administrative Solution using Microsoft SQL Server 2008 |
| Real Exam Qty: | Approximately 45–50 |
| Available Languages: | English |
| Exam Duration: | 120 minutes |
| Certificate Validity Period: | Legacy exam (no longer active as of retirement) |
| Exam Price: | Approximately USD 150 (varies by country) |
| Sample Questions: | Microsoft 070-432 Sample Questions |
| Exam Way: | Onsite (Legacy Microsoft exam delivery via test centers) |
| Pre Condition: | Recommended one to two years experience with SQL Server 2008 or equivalent database administration experience |
| Official Syllabus URL: | https://learn.microsoft.com/ |
Microsoft 070-432 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Monitoring and Troubleshooting SQL Server | |
| Installing and Configuring SQL Server | |
| Maintaining SQL Server Instances | |
| Optimizing SQL Server Performance | |
| Performing Data Management Tasks | |
| Maintaining SQL Server Databases | |
| Managing SQL Server Security |
Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:
1. You maintain a SQL Server 2008 instance.
The SQL Server instance is configured to use the -T1222 and -T1204 trace flags during
startup.
You need to ensure that your failure recovery plan backs up the use of the trace flags.
What should you do?
A) Backup the SQL Server registry hive.
B) Backup the master database.
C) Backup the resource database.
D) Backup the default.trc file.
2. You administer a SQL Server 2008 instance. Users report that applications that run on the server perform poorly. You suspect that the performance issues are related to table scans.
You need to use an appropriate Windows System Monitor object to capture the appropriate information.
Which performance object should you use?
A) SQLServer:Databases
B) SQLServer:Buffer Manager
C) SQLServer:Memory Manager
D) SQLServer:Access Methods
3. You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
Rebuilds indexes.
Checks database integrity.
Writes a report to a text file.
You need to ensure that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.
---
What should you modify?
A) The SQL Server Agent job.
B) The instance.
C) The database maintenance plan.
D) The SQL Server service.
4. You maintain a SQL Server 2008 instance that contains a database named Finance.
You suspect that three large tables in the Finance database are corrupt. You plan to execute the DBCC CHECKTABLE statement concurrently on the three tables to minimize downtime.
You need to set the database option to prevent users from accessing the database during the execution of the statement.
Which database option should you turn on?
A) READ_ONLY
B) OFFLINE
C) RESTRICTED_USER
D) SINGLE_USER
5. You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 by using transactional replication. A full backup of each database is performed every night.
Transaction log backups are performed every hour. Replication latency is typically less than two minutes. One afternoon, the Sales database on SQLTEST1 becomes corrupted. You are unable to repair the database. The Sales database on SQLTEST2 is unaffected. You need to return the Sales database on SQLTEST1 to normal operation as quickly as possible.
You must ensure a minimum loss of data and minimal impact to users of either server.
What should you do?
A) You should reserve the most recent full database backup and the whole transaction logs made since the past backup could be made.
B) You should detach the Sales database on SQL2. Copy the database file to SQL1, and link the database on both servers.
C) You should reserve only the newest transaction log backup.
D) You should reserve a full database backup on SQL2. Reserve the backup to SQL1.
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: D | Question # 3 Answer: A | Question # 4 Answer: D | Question # 5 Answer: D |
By Fabian
