최신Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 70-432무료샘플문제
문제1
You administer a SQL Server 2008 instance.
A stored procedure is used as the data source for a report that is frequently executed during business hours. Users report that the data returned by the report is inconsistent. You discover that the
inconsistencies are caused by phantom reads.
You need to ensure that the report returns consistent results without affecting other users.
What should you do?
You administer a SQL Server 2008 instance.
A stored procedure is used as the data source for a report that is frequently executed during business hours. Users report that the data returned by the report is inconsistent. You discover that the
inconsistencies are caused by phantom reads.
You need to ensure that the report returns consistent results without affecting other users.
What should you do?
정답: C
문제2
You manage two SQL Server 2008 instances on separate servers named Server1 and Server2. The servers are located in different cities.
You plan to implement database mirroring between the two instances.
You need to set up the mirroring session to support the high volume of write transactions to the database.
You do not want small errors to impact the principal server.
What should you do?
You manage two SQL Server 2008 instances on separate servers named Server1 and Server2. The servers are located in different cities.
You plan to implement database mirroring between the two instances.
You need to set up the mirroring session to support the high volume of write transactions to the database.
You do not want small errors to impact the principal server.
What should you do?
정답: C
문제3
You administer a Microsoft SQL Server database.
You plan to deploy a new database application. You want to use SQL Server common language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?
You administer a Microsoft SQL Server database.
You plan to deploy a new database application. You want to use SQL Server common language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?
정답: C
문제4
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The service account used by SQL Server services must not have administrative permissions.
You configure a new SQL Server Agent job to run every night. One of the steps in the job runs a PowerShell step. The job continuously fails on this step and throws the following error message:
"The process could not be created for step 1 of job (reason: A required privilege is not held by the client). The step failed."
You need to ensure that the SQL Server Agent Job executes successfully.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The service account used by SQL Server services must not have administrative permissions.
You configure a new SQL Server Agent job to run every night. One of the steps in the job runs a PowerShell step. The job continuously fails on this step and throws the following error message:
"The process could not be created for step 1 of job (reason: A required privilege is not held by the client). The step failed."
You need to ensure that the SQL Server Agent Job executes successfully.
Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
정답:
문제5
You are reviewing and configuring the security of a SQL Server 2008 instance that contains database DB1.
The security audit policy specifies the following requirements:
- Only successful and failed logon attempts are recorded in log files.
- The SQL Server instance is shut down if records cannot be written to the log files.
You need to configure the SQL Server instance to comply with the security audit policy.
What should you do?
You are reviewing and configuring the security of a SQL Server 2008 instance that contains database DB1.
The security audit policy specifies the following requirements:
- Only successful and failed logon attempts are recorded in log files.
- The SQL Server instance is shut down if records cannot be written to the log files.
You need to configure the SQL Server instance to comply with the security audit policy.
What should you do?
정답: B
문제6
You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing application.
You need to ensure that the database allows full-text searches on the Customers table.
You also need to ensure that the full-text index is ready for use by the users.
You execute a Transact-SQL statement to create the full-text index on the Customers table
by using the CHANGE_TRACKING
OFF and NO POPULATION clauses in the CREATE FULLTEXT INDEX statement.
You execute an ALTER FULLTEXT INDEX.
Which command or commands should you use next?
You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing application.
You need to ensure that the database allows full-text searches on the Customers table.
You also need to ensure that the full-text index is ready for use by the users.
You execute a Transact-SQL statement to create the full-text index on the Customers table
by using the CHANGE_TRACKING
OFF and NO POPULATION clauses in the CREATE FULLTEXT INDEX statement.
You execute an ALTER FULLTEXT INDEX.
Which command or commands should you use next?
정답: A
문제7
You are mastering the company database called Testing; you should back up the Testing database fully. You do transaction log once every two hours from 08:00 to 17:00.You should run database snapshots for the Testing database. You should develop database snapshot every day at 07:00. At 8:30 the user removes the whole information on the Testing database which was entered intothe CurrentSpeaker table yesterday. Deletion is the first step for the database. It is now 11:45 and many other changes have happened in the database. You should find solution to solve this problem .Which is the correct answer?
You are mastering the company database called Testing; you should back up the Testing database fully. You do transaction log once every two hours from 08:00 to 17:00.You should run database snapshots for the Testing database. You should develop database snapshot every day at 07:00. At 8:30 the user removes the whole information on the Testing database which was entered intothe CurrentSpeaker table yesterday. Deletion is the first step for the database. It is now 11:45 and many other changes have happened in the database. You should find solution to solve this problem .Which is the correct answer?
정답: D
문제8
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?
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?
정답: D
문제9
You troubleshoot the performance of a SQL Server 2008 instance.
You need to identify the longest-running common language runtime (CLR) queries.
Which dynamic management view should you use?
You troubleshoot the performance of a SQL Server 2008 instance.
You need to identify the longest-running common language runtime (CLR) queries.
Which dynamic management view should you use?
정답: B
문제10
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?
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?
정답: C
문제11
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 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?
정답: C
문제12
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 server that hosts two databases named NorthwindOLTP and NorthwindOLAP. Cross database ownership chaining is currently disabled for all databases.
A stored procedure in the NorthwindOLTP database writes data to a table in the NorthwindOLAP database. The public role in both databases has only Read and Execute permissions assigned to all objects. All objects are located in the DBO schema. Guest access has been disabled for all databases on the server.
You need to ensure that the stored procedure can execute successfully.
Which two actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 server that hosts two databases named NorthwindOLTP and NorthwindOLAP. Cross database ownership chaining is currently disabled for all databases.
A stored procedure in the NorthwindOLTP database writes data to a table in the NorthwindOLAP database. The public role in both databases has only Read and Execute permissions assigned to all objects. All objects are located in the DBO schema. Guest access has been disabled for all databases on the server.
You need to ensure that the stored procedure can execute successfully.
Which two actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
정답:
문제13
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?
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?
정답: D
문제14
You administer a Microsoft SQL Server 2008 R2 instance.
A disk drive that contains the files for the database is lost. The drive has been replaced, but the data files have been irrevocably lost.
You need to restore the database.
What should you do?
You administer a Microsoft SQL Server 2008 R2 instance.
A disk drive that contains the files for the database is lost. The drive has been replaced, but the data files have been irrevocably lost.
You need to restore the database.
What should you do?
정답: A