最新的Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 70-432免費考試真題
問題1
You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?
You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?
正確答案: D
問題2
You administer a SQL Server 2008 instance.
The security policy permits members of a Windows group named CONTOSO\Sales to establish new connections to the SQL Server instance only during business horns between
07:00 horns and 19:00 hours. Other users may connect to the SQL Server instance any time.
You write the following Transact-SQL statements.
You need to implement the company security policy that is stored in the RestrictedLogonHours table.
What should you do?
You administer a SQL Server 2008 instance.
The security policy permits members of a Windows group named CONTOSO\Sales to establish new connections to the SQL Server instance only during business horns between
07:00 horns and 19:00 hours. Other users may connect to the SQL Server instance any time.
You write the following Transact-SQL statements.
You need to implement the company security policy that is stored in the RestrictedLogonHours table.
What should you do?
正確答案: A
問題3
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).
What should you do? (To answer, drag the appropriate purpose to the correct DMV in the answer area. Each purpose may be used once, more than once, or not at all. Each DMV may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).
What should you do? (To answer, drag the appropriate purpose to the correct DMV in the answer area. Each purpose may be used once, more than once, or not at all. Each DMV may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
正確答案:
問題4
You are a database administrator for your company. The company uses a SQL Server 2008 database that includes a table named Inventory.
The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation.
Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?
You are a database administrator for your company. The company uses a SQL Server 2008 database that includes a table named Inventory.
The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation.
Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?
正確答案: A
問題5
You are mastering the company database; you should use the SQL Server 2005 database which enables business users to operate both ad hoc and predefined searches. Youdoubt that some searched will cost too many resources. You should clarify which searches cost the most resources. You decide to finish this aim as quickly as possible. Which is the correct answer?
You are mastering the company database; you should use the SQL Server 2005 database which enables business users to operate both ad hoc and predefined searches. Youdoubt that some searched will cost too many resources. You should clarify which searches cost the most resources. You decide to finish this aim as quickly as possible. Which is the correct answer?
正確答案: B
問題6
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
問題7
You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database contains a table named Customers that has a column named CompanyName.
The current database collation is SQL_Latin1_General_Cp1_CI_AS.
You need to ensure that the indexes which include the CompanyName column are case-sensitive.
You also need to ensure that other case-insensitive queries are unaffected.
What should you do?
You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database contains a table named Customers that has a column named CompanyName.
The current database collation is SQL_Latin1_General_Cp1_CI_AS.
You need to ensure that the indexes which include the CompanyName column are case-sensitive.
You also need to ensure that other case-insensitive queries are unaffected.
What should you do?
正確答案: A
問題8
You are managing a SQL Server 2008 instance for Home.com. You use a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. A data mining structure should be deployed which contains the Microsoft Clustering mining model. From Scalable K-Means to Non-scalable K-Means.
You should alter the attribute of the mining model. Which is the correct answer?
You are managing a SQL Server 2008 instance for Home.com. You use a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. A data mining structure should be deployed which contains the Microsoft Clustering mining model. From Scalable K-Means to Non-scalable K-Means.
You should alter the attribute of the mining model. Which is the correct answer?
正確答案: D
問題9
You maintain multiple SQL Server 2008 instances.
You are designing a consolidated repository of performance data.
You need to ensure that the following requirements are met:
----
The data collector is used to gather performance information.
A single database stores performance information for all instances.
Performance information that is older than 14 days is deleted.
Administrative effort to manage performance data is minimized.
What should you do?
You maintain multiple SQL Server 2008 instances.
You are designing a consolidated repository of performance data.
You need to ensure that the following requirements are met:
----
The data collector is used to gather performance information.
A single database stores performance information for all instances.
Performance information that is older than 14 days is deleted.
Administrative effort to manage performance data is minimized.
What should you do?
正確答案: A
問題10
You administer a database for an online ordering system.
You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools.
You need to ensure that the transaction log backup schedule meets the following requirements:
- Log backups occur every 15 minutes between 09:00 hours and 17:00 hours. - Log backups occur every hour between 17:00 hours and 09:00 hours.
What should you do?
You administer a database for an online ordering system.
You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools.
You need to ensure that the transaction log backup schedule meets the following requirements:
- Log backups occur every 15 minutes between 09:00 hours and 17:00 hours. - Log backups occur every hour between 17:00 hours and 09:00 hours.
What should you do?
正確答案: B
問題11
You are mastering the company database, with a SQL Server 2008 computer called SQLTEST1.There are three examples of SQL Server in the SQLTEST1.The ability to connect to the dedicated administrative connection on every example of SQL Server should be included in the disaster recovery plan of the company. You find that you could connect to the connection on SQLTEST1 default example while testing this ability; you could not connect to the dedicated connection on the two other examples on SQLTEST1. You should clarify that the examples are implementing and that client applications should be able to approach them. You should make sure that no other administrators are attempting to connect to any dedicated connections on SQLTEST1. You should also make sure that you could connect to the dedicated connection on all three examples. Which is the correct answer?
You are mastering the company database, with a SQL Server 2008 computer called SQLTEST1.There are three examples of SQL Server in the SQLTEST1.The ability to connect to the dedicated administrative connection on every example of SQL Server should be included in the disaster recovery plan of the company. You find that you could connect to the connection on SQLTEST1 default example while testing this ability; you could not connect to the dedicated connection on the two other examples on SQLTEST1. You should clarify that the examples are implementing and that client applications should be able to approach them. You should make sure that no other administrators are attempting to connect to any dedicated connections on SQLTEST1. You should also make sure that you could connect to the dedicated connection on all three examples. Which is the correct answer?
正確答案: C
問題12
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?
正確答案: A
問題13
You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?
You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?
正確答案: B
問題14
You are mastering the company database; there are 15 retail stores in your company. On its own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a database table called Saling. The Saling table also includes sales information from other stores to enable customer returns to any of the 15 retail stores. You could refresh the data in the main office to every retail store every hour. You should use trigger called trg_Coupon to produce sales coupons based on customer sales and buying patterns. Through using the fewest number of steps, you should set replication between the server in every retail store and a middle server in the mainoffice. in real time. You should not have the Replication. Which is the correct answer?
You are mastering the company database; there are 15 retail stores in your company. On its own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a database table called Saling. The Saling table also includes sales information from other stores to enable customer returns to any of the 15 retail stores. You could refresh the data in the main office to every retail store every hour. You should use trigger called trg_Coupon to produce sales coupons based on customer sales and buying patterns. Through using the fewest number of steps, you should set replication between the server in every retail store and a middle server in the mainoffice. in real time. You should not have the Replication. Which is the correct answer?
正確答案: A