최신Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 70-432무료샘플문제
문제1
You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains the OrderHistory table. The OrderHistory table is partitioned on the OrderId column. The first partition contains integer values between 1 and 100.000. The second partition contains integer values greater than
100.000. You need to add a new partition that contains integer values greater than
200.000. What should you do?
You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains the OrderHistory table. The OrderHistory table is partitioned on the OrderId column. The first partition contains integer values between 1 and 100.000. The second partition contains integer values greater than
100.000. You need to add a new partition that contains integer values greater than
200.000. What should you do?
정답: C
문제2
You administer a SQL Server 2008 instance.
You configure a single Database Mail profile that is used to send reports to all the
employees of your organization. The sp_send_dbmail stored procedure is used to send a
large volume of reports during business hours.
The reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?
You administer a SQL Server 2008 instance.
You configure a single Database Mail profile that is used to send reports to all the
employees of your organization. The sp_send_dbmail stored procedure is used to send a
large volume of reports during business hours.
The reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?
정답: D
문제3
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales management application.
Occasionally, users of the application report that they receive a deadlock error. You plan to troubleshoot this error.
You need to ensure that the instance is configured to capture troubleshooting information that will allow you to isolate the cause of the error.
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 database instance that supports a sales management application.
Occasionally, users of the application report that they receive a deadlock error. You plan to troubleshoot this error.
You need to ensure that the instance is configured to capture troubleshooting information that will allow you to isolate the cause of the error.
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.)
정답:
문제4
You maintain a SQL Server 2008 instance that contains a database named Finance. In your absence, a user with a login named Rob will maintain the database snapshots. You need to giant the appropriate permissions to the user to delete the database
snapshots for the Finance database. Which database permission should you giant?
You maintain a SQL Server 2008 instance that contains a database named Finance. In your absence, a user with a login named Rob will maintain the database snapshots. You need to giant the appropriate permissions to the user to delete the database
snapshots for the Finance database. Which database permission should you giant?
정답: A
문제5
You are mastering the company database, You should check the log of the a SQL Server 2005 Enterprise Edition everyday, You get the information on the torn page errors of the database. In order to fine the solution of the torn page, Which is the correct answer?
You are mastering the company database, You should check the log of the a SQL Server 2005 Enterprise Edition everyday, You get the information on the torn page errors of the database. In order to fine the solution of the torn page, Which is the correct answer?
정답: C
문제6
You maintain a SQL Server 2008 instance.
You find a SQL Server Agent job is failing. When you review the job history information, you notice that the job history information is incomplete and appears to be truncated. You need to ensure that all information produced by a job is available for viewing. What should you do?
You maintain a SQL Server 2008 instance.
You find a SQL Server Agent job is failing. When you review the job history information, you notice that the job history information is incomplete and appears to be truncated. You need to ensure that all information produced by a job is available for viewing. What should you do?
정답: D
문제7
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?
정답: C
문제8
You maintain a SQL Server 2008 instance that contains a database named Finance. The Finance database currently contains 100 GB of data. On an average, 1 GB of data is modified or inserted daily.
The recovery model of the Finance database is set to Simple. Business requirements specify that data loss of more than two hours worth of transactions during business hours is unacceptable.
You need to select a backup strategy that uses the least amount of disk space by adhering to the business requirements.
What should you do?
You maintain a SQL Server 2008 instance that contains a database named Finance. The Finance database currently contains 100 GB of data. On an average, 1 GB of data is modified or inserted daily.
The recovery model of the Finance database is set to Simple. Business requirements specify that data loss of more than two hours worth of transactions during business hours is unacceptable.
You need to select a backup strategy that uses the least amount of disk space by adhering to the business requirements.
What should you do?
정답: A
문제9
You upgrade an instance of Microsoft SQL Server 2000 to SQL Server 2008.
The SQL Server Agent service is configured to use the LocalSystem account. A job uses a
CMDExec step to access a file located on a remote network share.
After the upgrade, the job step fails to complete execution.
You need to configure the job step so that it can successfully complete execution.
What should you do?
You upgrade an instance of Microsoft SQL Server 2000 to SQL Server 2008.
The SQL Server Agent service is configured to use the LocalSystem account. A job uses a
CMDExec step to access a file located on a remote network share.
After the upgrade, the job step fails to complete execution.
You need to configure the job step so that it can successfully complete execution.
What should you do?
정답: B
문제10
You are mastering the company database, including the SQL Server 2005 database which include a table called Production. Product. The table has more than 50 columns
The most common queries are listed below Transact-SQL statements. --QUERY 1SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production]. [Product]WHERE [ProductLine] = 'T' --QUERY 2SELECT * FROM [Production]. [Product] ORDER BY [Name]
When you are minimizing the space required for the indexes.
You should select the best indexes to maintain the most common searched to the Production. Product tableWhich is the correct answer?
You are mastering the company database, including the SQL Server 2005 database which include a table called Production. Product. The table has more than 50 columns
The most common queries are listed below Transact-SQL statements. --QUERY 1SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production]. [Product]WHERE [ProductLine] = 'T' --QUERY 2SELECT * FROM [Production]. [Product] ORDER BY [Name]
When you are minimizing the space required for the indexes.
You should select the best indexes to maintain the most common searched to the Production. Product tableWhich is the correct answer?
정답: B
문제11
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?
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?
정답: F
문제12
You administer a SQL Server 2008 instance. The instance contains a database named DB1.
You plan to allow all the application developers to use SQL Server Profiler to capture traces to troubleshoot the application that uses the database DB1.
You need to grant the minimum necessary permission to the application developers.
What should you do?
You administer a SQL Server 2008 instance. The instance contains a database named DB1.
You plan to allow all the application developers to use SQL Server Profiler to capture traces to troubleshoot the application that uses the database DB1.
You need to grant the minimum necessary permission to the application developers.
What should you do?
정답: B
문제13
You maintain a SQL Server 2008 instance that contains a database named Finance. A small percentage of data in the database is modified daily.
You need to create a read-only copy of the database for reporting purposes at the beginning of each day by ensuring that minimal disk space is used.
Which strategy should you use?
You maintain a SQL Server 2008 instance that contains a database named Finance. A small percentage of data in the database is modified daily.
You need to create a read-only copy of the database for reporting purposes at the beginning of each day by ensuring that minimal disk space is used.
Which strategy should you use?
정답: B