默认题库 - MCITP(70-431)

单选题

Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

A. Create a FOR trigger.
B. Create an INSTEAD OF trigger.
Create an AFTER trigger.
D. Create a DDL trigger.

单选题

You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）

A. Create CHECK constraints on the tables.
B. Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
Create the view, specifying the WITH SCHEMABINDING option.
D. Create the view, specifying the WITH CHECK option.&e

查看答案

单选题

You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?（）

A. Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
B. Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
D. Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.

查看答案

单选题

Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company named Eric writes many ad hoc queries against the company databases. Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first?（）

A. Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
B. Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
C. Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.
D. Instruct Eric to specify SQL Server object names by using four-part notation.&e

查看答案

单选题

Your company has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need toreconfigure transaction log shipping to provide minimum latency on SQL2. What should you do?（）

A. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, maintain default schedule settings for both the log shipping copy and the restore jobs.
B. On SQL1, change the schedule type for the transaction log backup to Start automatically when SQL Server Agent starts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
C. On SQL1, maintain default schedule settings for the transaction log backup job. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
D. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every minute.&e

查看答案

多选题

Your company uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?（）

A. Set the recovery model of DB1 on SQL1 to bulk-logged recovery.
B. Set the recovery model of DB1 on SQL1 to full recovery.
C. Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option.
D. Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option.
E. Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.
F. Create endpoints on all participating servers.
G. Set the AutoShrink property of DB1 on SQL1 to false.

查看答案

单选题

You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do?（）

A. Implement parameterized Transact-SQL queries in the application.
B. Implement Transact-SQL stored procedures in the database.
C. Implement CLR stored procedures in the database.
D. Implement distributed Web services.

查看答案

多选题

Your company uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date. You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use?（）

A. DBCC CHECKTABLE
B. ALTER INDEX REORGANIZE
C. UPDATE STATISTICS
D. CREATE STATISTICS
E. DBCC SHOW_STATISTICS
F. DBCC UPDATEUSAGE

查看答案

多选题

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）

A. Named Pipes
B. TCP/IP
C. Shared Memory
D. Virtual Interface Adapter (VIA)
E. Multiprotocol&e

查看答案

单选题

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do?（）

A. Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
Back up the current transaction log. Restore the database to the point just before the data loss.
C. Restore the database from the existing backup files to a time just before the data loss.
D. Restore the database to the point of the last full backup.

查看答案