Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 70-432 Exam Practice Test
You administer a Microsoft SQL Server 2008 instance that contains two databases named Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses the Latin1_General_100_CI_AI collation.
Each database has an Orders table that has the following definition: You need to return records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL query should you use?
Each database has an Orders table that has the following definition: You need to return records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL query should you use?
Correct Answer: A
Vote an answer
You administer two SQL Server 2008 instances on separate servers named Server1 and Server2.
The AdventureWorks database is set up for synchronous mirroring between the two instances.
You need to configure the database to support automatic failover.
What should you do?
The AdventureWorks database is set up for synchronous mirroring between the two instances.
You need to configure the database to support automatic failover.
What should you do?
Correct Answer: B
Vote an answer
You administer a Microsoft SQL Server 2008 R2 instance. You need to rectify a damaged index without losing any data. What should you do?
Correct Answer: C
Vote an answer
You administer a SQL Server 2008 instance. A payroll application is used to store sensitive data in a database named PayrollDB.
You plan to implement the following security measure:
- All the data files, log files, and backup files of the database are automatically encrypted.
You need to devise a method to encrypt data. What should you include in your solution?
You plan to implement the following security measure:
- All the data files, log files, and backup files of the database are automatically encrypted.
You need to devise a method to encrypt data. What should you include in your solution?
Correct Answer: A
Vote an answer
You administer a SQL Server 2008 instance.
A database developer named User1 needs to view the definitions of all database objects in
a database and read data from all user-defined tables, views, and table-valued functions.
You need to set the required permissions for User1.
Which Transact-SQL statements should you execute?
A database developer named User1 needs to view the definitions of all database objects in
a database and read data from all user-defined tables, views, and table-valued functions.
You need to set the required permissions for User1.
Which Transact-SQL statements should you execute?
Correct Answer: A
Vote an answer
You maintain a SQL Server 2008 instance that contains a database named CustomerDB. The CustomerDB database stores customer data for the company. The customers use a Web application to access their profile data.
You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. You want to achieve this goal without affecting the Web application.
What should you do?
You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. You want to achieve this goal without affecting the Web application.
What should you do?
Correct Answer: D
Vote an answer
You administer a SQL Server 2008 instance and a SQL Server 2005 instance. Both instances run on the same computer. The SQL Server 2008 instance contains a database named WebApplicationDB that uses the Fulltext indexes.
Several records that include the word "root" are added to the WebApplicationDB database. When the Fulltext index is queried for the word "root," an empty resultset is returned.
You need to ensure that records that contain the word "root" are returned by the query.
What should you do?
Several records that include the word "root" are added to the WebApplicationDB database. When the Fulltext index is queried for the word "root," an empty resultset is returned.
You need to ensure that records that contain the word "root" are returned by the query.
What should you do?
Correct Answer: C
Vote an answer
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?
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?
Correct Answer: B
Vote an answer
You maintain a SQL Server 2008 instance that contains a database named Finance. The most recent full backup was taken at 13:00 horns, a differential backup was taken at
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The backups and the database snapshots are stored on a different disk from the database files. The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The backups and the database snapshots are stored on a different disk from the database files. The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?
Correct Answer: A
Vote an answer