We're so confident of our products that we provide no hassle product exchange.
Microsoft 70-432 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | TS: Microsoft SQL Server 2008, Implementation and Maintenance |
| Exam Number: | 70-432 |
| Real Exam Qty: | 40-60 |
| Passing Score: | 700/1000 |
| Exam Price: | USD 165 (varies by country/region) |
| Certificate Validity Period: | Retired (no longer available / legacy certification) |
| Exam Format: | Multiple Choice, Scenario-based Questions, Multiple Response, Case Studies |
| Available Languages: | German, Spanish, Japanese, English, Simplified Chinese, French |
| Related Certifications: | Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 |
| Exam Duration: | 120 minutes |
| Recommended Training: | SQL Server 2008 Training (Microsoft Learning - legacy) SQL Server Documentation |
| Exam Registration: | Microsoft Certification Exam Registration Pearson VUE Microsoft Exams |
| Sample Questions: | Microsoft 70-432 Sample Questions |
| Exam Way: | Proctored exam delivered via Pearson VUE (online or authorized test center) |
| Pre Condition: | No formal prerequisite, but recommended experience with Windows Server and SQL Server 2008 administration concepts. |
| Official Syllabus URL: | https://learn.microsoft.com/credentials/certifications/exams/70-432 |
Microsoft 70-432 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Implementing High Availability and Backup/Restore | - Restoring databases and recovery models - Backup strategies and types - Basic high availability concepts (mirroring, clustering overview) |
| Implementing Security | - Managing logins, users, and roles - Securing data and encryption concepts - Authentication and authorization |
| Installing and Configuring SQL Server 2008 | - Configuring SQL Server services and instances - Installation planning and requirements - Post-installation configuration and setup |
| Monitoring and Optimizing SQL Server | - Indexing and query optimization basics - Troubleshooting performance issues - Performance monitoring tools and DMVs overview |
| Managing Databases | - Schema management and objects - Managing database files and storage - Creating and configuring databases |
Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:
DRAG DROP
You administer a Microsoft SQL Server 2008 database for an order-processing application. The following Transact-SQL statements have been run against the database:
You need to ensure that members of the reporting group can use only up to 35 percent of the CPU and up to 45 percent of the available RAM.
Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
Correct Answer:
You administer a SQL Server 2008 instance that contains a database named DB1.
A table named Sales.Table1 exists in the Sales schema.
You need to move the Sales.Table1 table to a new schema named Billing.
Which Transact-SQL statement should you execute?
- A. ALTER SCHEMA Billing TRANSFER Sales.Table1;
- B. ALTER TABLE Sales.Table1 SWITCH TO Billing.Table1;
- C. ALTER AUTHORIZATION ON Sales.Table1 TO Billing:
- D. ALTER USER Sales WITH DEFAULT_SCHEMA = Billing;
Correct Answer: A 🗳️
You administer two SQL Server 2008 instances named Instance 1 and Instance 2. A database named AdventureWorks resides on Instance1. You move the AdventureWorks database from Instance1 to Instance2.
A SQL Server login named Mary with the password "Re#99$45" is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2.
The user attempts to access the AdventureWorks database on Instance2 by using the SQL Server login Mary. However, the user receives an error message which indicates that the access to the AdventureWorks database is denied.
You need to ensure that the user can access the AdventureWorks database.
Which Transact-SQL statements should you execute on Instance!?
- A. USE Adventure Works;
ALTER LOGIN Mary WITH PASSWORD = 'Re#99$45' UNLOCK; - B. USE AdventureWorks;
ALTER USER Mary WITH LOGIN = Mary; - C. USE AdventureWorks;
ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks; - D. USE AdventureWorks:
ALTER LOGIN Mary ENABLE;
Correct Answer: B 🗳️
You administer a Microsoft SQL Server 2008 R2 instance.
Mirroring has been configured between two servers.
You need to ensure that automatic failover will occur when the principal server fails
What should you do?
- A. Create a Microsoft SQL Server Integration Services package on the partner server to monitor the principal server.
- B. Create a witness server to monitor the mirroring session.
On the principal server, use the ALTER DATABASE statement along with the SET WITNESS clause. - C. Implement Policy Based Management.
Enable the Server Performance management facet. - D. Create a witness server to monitor the mirroring session.
On both partner servers, use the ALTER DATABASE statement along with the SET WITNESS clause.
Correct Answer: B 🗳️
You administer a SQL Server 2008 cluster in a high security environment.
You plan to configure and use encrypted connections for the clustered virtual SQL Server.
You need to install the certificate that will be used for encryption.
What should you do?
- A. Install the encryption certificate in the cluster quorum drive.
- B. Install the encryption certificate on each individual node.
- C. Install the encryption certificate in the cluster group.
- D. Install the encryption certificate in the SQL Server shared disk.
Correct Answer: B 🗳️
Viewing page 1 out of 40 pages.
Viewing questions 1-5 out of 199 questions.
By Irene
