Pass4side 70-431最新考试题库DEMO分享（2）

本题库摘自www.pass4side.cn 更新时间：2008-9-17更多考试题库信息可登陆查看。
6. A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in anerror. You investigate the error. You discover that in one of the databases, a developer has accidentally deletedsome data in a table that is critical for transaction processing. The database uses the full recovery model. You needto 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 beforethe data loss. Copy the table back into the original database.
B. 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.
Answer: A

7. Your company uses SQL Server 2005. Users report that report execution is slow. You investigate and discoverthat some queries do not use optimal execution plans. You also notice that some optimizer statistics are missingand others are out of date. You need to correct the problem so that reports execute more quickly. Which twoTransact-SQL statements should you use? (Each correct answer presents part of the solution. Choose two.)
A. DBCC CHECKTABLE
B. ALTER INDEX REORGANIZE
C. UPDATE STATISTICS
D. CREATE STATISTICS
E. DBCC SHOW_STATISTICS
F. DBCC UPDATEUSAGE
Answer: CD

8. You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs runevery Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way thatuses the least amount of administrative effort. What should you do?
A. Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedulethat runs on the first day of every month. Assign monthly tasks to this schedule.
B. Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of theweek. If the day is either a Sunday or the first day of the month, execute the code.
C. Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or thefirst day of the month, execute the jobs.
D. Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on thefirst of the month.
Answer: A

9. You are responsible for managing the database schema for an order entry application in a SQL Server 2005database. After a design review, a member of the development staff asks you to add a new column namedCommissionRate to the Product table. Because the actual commission rates for all products are not known at thistime, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You addthe new column. You need to configure the table to assign the default value as efficiently as possible. What shouldyou do?
A. Create an INSERT trigger to assign the default value to each item in the table.
B. Create a CHECK constraint to validate the data and to assign the default value to each item in the table.

Pass4side 70-431最新考试题库DEMO分享（1）

题库摘自：www.pass4side.cn 更新时间：2008-9-17
1. Your company, Contoso, Ltd., has a main office and a branch officE. The offices are connected by a WAN link.Contoso has an Active Directory forest that contains a single domain named ad.contoso.com.The ad.contoso.com domain contains one domain controller named DC1 that is located in the main officE. DC1 isconfigured as a DNS server for the ad.contoso.com DNS zon
E. This zone is configured as a standard primaryzone.You install a new domain controller named DC2 in the branch officE. You install DNS on DC2.You need to ensure that the DNS service can update records and resolve DNS queries in the event that a WAN linkfails.What should you do?A. Create a new stub zone named ad.contoso.com on DC2.
B. Configure the DNS server on DC2 to forward requests to DC1.
C. Create a new standard secondary zone named ad.contoso.com on DC2.
D. Convert the ad.contoso.com zone on DC1 to an Active Directory-integrated zone.
Answer: D

2. Your company has a DNS server that has 10 Active Directory integrated zones.You need to provide copies of the zone files of the DNS server to the security department.What should you do?
A. Run the dnscmd /ZoneInfo command.
B. Run the ipconfig /registerdns command.
C. Run the dnscmd /ZoneExport command.
D. Run the ntdsutil > Partition Management > List commands.
Answer: C

3. Your company has a single Active Directory domain named intranet.adatum.com. The domain controllers runWindows Server 2008 and the DNS server rolE.All computers, including non-domain members, dynamically register their DNS records.You need to configure the intranet.adatum.com zone to allow only domain members to dynamically register DNSrecords.What should you do?
A. Set dynamic updates to Secure Only.
B. Enable zone transfers to Name Servers.
C. Remove the Authenticated Users group.
D. Deny the Everyone group the Create All Child Objects permission.
Answer: A

4. Your company has a main office and a branch officE. The company has a single-domain Active Directoryforest.The main office has two domain controllers named DC1 and DC2 that run Windows Server 2008. The branchoffice has a Windows Server 2008 read-only domain controller (RODC) named DC3.All domain controllers hold the DNS Server server role and are configured as Active Directory-integrated zones.The DNS zones only allow secure updates.You need to enable dynamic DNS updates on DC3.What should you do?
A. Run the Ntdsutil.exe > DS Behavior commands on DC3.
B. Run the Dnscmd.exe /ZoneResetType command on DC3.
C. Reinstall Active Directory Domain Services on DC3 as a writable domain controller.
D. Create a custom application directory partition on DC1. Configure the partition to store ActiveDirectory-integrated zones.
Answer: C

5. You have a single Active Directory domain. All domain controllers run Windows Server 2008 and areconfigured as DNS servers. The domain contains one Active Directory-integrated DNS zone.You need to ensure that outdated DNS records are automatically removed from the DNS zone.What should you do?
A. From the properties of the zone, enable scavenging.
B. From the properties of the zone, disable dynamic updates.
C. From the properties of the zone, modify the TTL of the SOA record.
D. From the command prompt, run ipconfig /flushdns.
Answer: A