Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 70-432 Exam Practice Test
You maintain a SQL Server 2008 instance.
You use the Resource Governor to manage processor resources on the server for a newly deployed application named App1. App1 is assigned to a custom workload group named MyApp.
You need to monitor processor resources.
What should you do?
You use the Resource Governor to manage processor resources on the server for a newly deployed application named App1. App1 is assigned to a custom workload group named MyApp.
You need to monitor processor resources.
What should you do?
Correct Answer: A
Vote an answer
You maintain a SQL Server 2008 instance that runs on a computer that hosts several applications. You configure the SQL Server Agent service to run by using the SERVER1\AGENT account. You create a job named MailingList that requires a file to be written to a file server. The job fails to run because it does not have appropriate access to the file server. You plan to configure the SQL Server Agent service.
You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server.
Which account type should you use?
You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server.
Which account type should you use?
Correct Answer: D
Vote an answer
You migrate an application named App1 from Microsoft SQL Server 2000 to SQL Server 2008.
You plan to monitor the SQL Server instance.
You need to capture the use of features that will be discontinued.
What should you do?
You plan to monitor the SQL Server instance.
You need to capture the use of features that will be discontinued.
What should you do?
Correct Answer: D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You administer a Microsoft SQL Server database that hosts an order-processing application.
Employees in the order entry group perform real-time data entry for customers. Employees in the reporting group run historical reports.
Employees in the order entry group report of poor performance when the reporting group runs reports.
You need to limit the amount of CPU and RAM used by the reporting group.
What should you do?
Employees in the order entry group perform real-time data entry for customers. Employees in the reporting group run historical reports.
Employees in the order entry group report of poor performance when the reporting group runs reports.
You need to limit the amount of CPU and RAM used by the reporting group.
What should you do?
Correct Answer: C
Vote an answer
You administer a SQL Server 2008 instance.
You join two tables on a column named CompanyName by using the following query:
SELECT s.*,i.*
FROM SensitiveTb1 AS s
INNER JOIN Insensitive Tb1 AS iON i. CompanyName = s.CompanyName
When you execute the query, the following error is returned: "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between ,SQL_Latinl_General_CPl_CS_AS' and
'SQL_Latin1_General_CP1_CI_AS' in the equal to operation."
You need to modify the ON clause of the query to successfully perform a case-sensitive
join.
What should you do?
You join two tables on a column named CompanyName by using the following query:
SELECT s.*,i.*
FROM SensitiveTb1 AS s
INNER JOIN Insensitive Tb1 AS iON i. CompanyName = s.CompanyName
When you execute the query, the following error is returned: "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between ,SQL_Latinl_General_CPl_CS_AS' and
'SQL_Latin1_General_CP1_CI_AS' in the equal to operation."
You need to modify the ON clause of the query to successfully perform a case-sensitive
join.
What should you do?
Correct Answer: D
Vote an answer
You administer a SQL Server 2008 instance that contains a database named Ad venture Works.
You are log shipping the Adventureworks database to a remote SQL Server 2008 instance.
During the weekend, the primary SQL Server instance required a restart. After the weekend, you discover that log shipping has stopped working.
You need to troubleshoot log shipping of the Adventureworks database.
What should you do?
You are log shipping the Adventureworks database to a remote SQL Server 2008 instance.
During the weekend, the primary SQL Server instance required a restart. After the weekend, you discover that log shipping has stopped working.
You need to troubleshoot log shipping of the Adventureworks database.
What should you do?
Correct Answer: D
Vote an answer
You are managing a SQL Server 2008 instance which includes a database called Products for Home.com. You should not modify the database frequently everyday. You should make sure that you develop a read-only copy of the database for reporting purposes at the beginning of every day .Which is the correct answer?
Correct Answer: A
Vote an answer
You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:
A drive fails and the CustomerOrders database goes into suspect mode on Monday at
09:00 hours.
You need to restore the backup.
What should you do?
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:
A drive fails and the CustomerOrders database goes into suspect mode on Monday at
09:00 hours.
You need to restore the backup.
What should you do?
Correct Answer: D
Vote an answer
----
You administer several SQL Server 2008 instances.
You need to ensure that all SQL Server instances are consistently configured for the following aspects:
Naming conventions
Security settings
Force index creation
Avoidance of data fragmentation
What should you do?
You administer several SQL Server 2008 instances.
You need to ensure that all SQL Server instances are consistently configured for the following aspects:
Naming conventions
Security settings
Force index creation
Avoidance of data fragmentation
What should you do?
Correct Answer: A
Vote an answer
You maintain a SQL Server 2008 instance that contains a database named Finance. The Finance database contains the following filegroups:
The PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume.
A filegroup named Histoiy that contains historical data stored in the G: volume. The transaction log of the database is stored in the H: volume.
As part of the archiving strategy for the Finance database, data is frequently moved from the PRIMARY filegroup to the History filegroup.
The backup strategy for the Finance database consists of the following requirements:
Backing up the PRIMARY filegroup five times a day Backing up the History filegroup at the end of each working day Backing up the transaction log every 15 minutes At 13:00 hours, the volume that contains the History filegroup fails.
You need to restore the database by ensuring minimal data loss in minimum possible time. What should you do?
The PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume.
A filegroup named Histoiy that contains historical data stored in the G: volume. The transaction log of the database is stored in the H: volume.
As part of the archiving strategy for the Finance database, data is frequently moved from the PRIMARY filegroup to the History filegroup.
The backup strategy for the Finance database consists of the following requirements:
Backing up the PRIMARY filegroup five times a day Backing up the History filegroup at the end of each working day Backing up the transaction log every 15 minutes At 13:00 hours, the volume that contains the History filegroup fails.
You need to restore the database by ensuring minimal data loss in minimum possible time. What should you do?
Correct Answer: C
Vote an answer
Yon manage several SQL Server 2008 instances.
You plan to collect performance data periodically on all instances by using the data collector. All collected data must be stored in the same database hosted on a single instance.
You need to collect and load performance data in the management data warehouse every 6 hours.
Which data collection process should you implement?
You plan to collect performance data periodically on all instances by using the data collector. All collected data must be stored in the same database hosted on a single instance.
You need to collect and load performance data in the management data warehouse every 6 hours.
Which data collection process should you implement?
Correct Answer: B
Vote an answer
You manage a SQL Server 2008 instance. You upgrade a SQL Server 7.0 database to the SQL Server instance.
You need to ensure the early detection of suspect pages in the database.
What should you do?
You need to ensure the early detection of suspect pages in the database.
What should you do?
Correct Answer: A
Vote an answer
You are mastering the company database, with SQL Server 2008 computer named SQLDB. The function of the SQLDB is to perform transaction log backups and so on.SQL1 should be reset by another administrator using the tool of SQL Server Surface Area Configuration.
You should see that SQL1 no longer runs the maintenance tasks automatically. On SQLDB, You should make sure the tasks of the maintenance are finished without menWhich is the correct answer?
You should see that SQL1 no longer runs the maintenance tasks automatically. On SQLDB, You should make sure the tasks of the maintenance are finished without menWhich is the correct answer?
Correct Answer: C
Vote an answer
You administer a SQL Server 2008 instance. You plan to install a SQL Server Analysis Services (SSAS) instance. The SSAS instance will be accessed by an Internet Information Services application by using anonymous access. You need to ensure that the application can access the SSAS instance. What should you do?
Correct Answer: B
Vote an answer