Original PDF Flash format Q  


Q

70-432

TS:MS SQL Serverfa) 2008.Implementation and Maintenance

Q&A
DEMO Version
Copyright (c) 2009 Chinatag LLC. All rights reserved.

Important Note
Please Read Carefully
For demonstration purpose only, this free version Chinatag study guide contains 10 full length questions selected
from our full version products which have more than 200 questions each.

This Study guide has been carefully written and compiled by Chinatag certification experts. It is designed to help you
learn the concepts behind the questions rather than be a strict memorization tool. Repeated readings will increase
your comprehension.

For promotion purposes, all PDF files are not encrypted. Feel free to distribute copies among your friends and let
them know Chinatag website.

Study Tips
This product will provide you questions and answers along with detailed explanations carefully compiled and written
by our experts. Try to understand the concepts behind the questions instead of cramming the questions. Go through
the entire document at least twice so that you make sure that you are not missing anything.


Latest Version
We are constantly reviewing our products. New material is added and old material is revised. Free updates are
available for 90 days after the purchase. You should check the products page on the http://www.chinatag.com
website for an update 3-4 days before the scheduled exam date.


Please tell us what you think of our products. We appreciate both positive and critical comments as your feedback
helps us improve future versions. Feedback on specific questions should be send to feedback@chinatag.com.

Thanks for purchasing our products and look forward to supplying you with all your Certification training needs.

Good studying!


Technical and Support Team
Chinatag LLC.
Leading the way in IT testing and certification tools, www.chinatag.com
- 2 -
70-432

Question: 1
Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not
installed Microsoft Business Intelligence Development Studio (BIDS). You should design a
package, which has the following features:The package should be transactional.The package
should be optimized for 10 tables.The package should be stored safely in the msdb database of a
server which is remote. Which is correct?

A. You should create the package by using DTS Designer.
B. You should create the package by using the Package Migration Wizard.
C. You should create the package by using the Microsoft SQL Server Import and Export Wizard.
D. On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, You should click the
Create Package submenu.

Answer: C

Question: 2
You are mastering the company database called TesterDB; the database includes a database
that uses SQL Server log shipping. Log shipping will happen half a hour. You should make the full
backup. In order to cut the net bandwidth utilization when maintenance every night. Which is the
correct answer?

A. You should set the database to utilize the bulk-logged recovery model.
B. You should reproduce only those indexes that ask it every night.
C. You should add the time during transaction log backups.
D. You should disable log shipping after the nightly maintenance.

Answer: B

Question: 3
You are mastering the company database, Users complaints that the SQL Server 2008
application is running slowly. You should check the information of the CPU utilization, disk
utilization, and memory utilization. The network should be considered. the detailed information
should be checked for the proper example of SQL Server2008.Which is the correct answer?

A. You should check the proper dynamic management views (DMVs).
B. In the databases, you should check the distribution of the statistics which are hosted
C. You should check a statistics update command??s the output.
D. You should check the recovery model of the master database.

Answer: A

Question: 4
You are managing a SQL Server 2008 instance which includes a database called Products
whose recovery model is set to full for Company.com.The Products database??s backup method
is listed below:The information reserve on different disks. The hard disks which include the user
database data files are reported to have failed at 17:00 hours on Wednesday. You should make
sure that Products database could be saved by minimal data loss. Which is the correct answer?



3
70-432

A. You should recovery the full backup taken on Sunday. And then recovery the differential
backup taken on Wednesday.
B. You should recovery the full backup taken on Wednesday. And then recovery the differential
backup taken on Sunday.
C. You should recovery the full backup taken everyday. And then recovery the differential backup
taken on Wednesday.
D. You should back up the transaction log and recovery the full backup taken on Sunday and
then recovery differential backup taken on Tuesday. And recovery the

Answer: D

Question: 5
You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. The Products database includes filegroups listed below: The PRIMARY filegroup
which includes the On-Line Transaction Processing (OLTP) information reserved in the E:
volume.A filegroup called Hunter which includes older information reserved in the F: volume. The
transaction log of the information is reserved in the I: volume. Data is transferred from the
PRIMARY filegroup to the Hunter filegroup as a member of the archiving strategy for the Products
database, the backup method for the Products database is composed of the conditions listed
below:You hould back up the PRIMARY filegroup six times a dayYou should back up the Hunter
filegroup at 20:00You should back up the transaction log every 20 minutes The volume which
includes the Hunter filegroup lost at 14:00 hours. You should make sure that you could recovery
the database through ensuring minimal data loss in minimum possible time.Which is the correct
answer?

A. You should backup the transaction log and recovery the oldest backup of the Hunter filegroup
and recovery the whole the transaction log backups after the most
B. You should recovery the newest backup of the Hunter filegroup.
C. You should backup the transaction log and recovery the newest backup of the Hunter filegroup
and recovery the whole the transaction log backups after the most
D. You should recovery the oldest backup of the Hunter filegroup.

Answer: C

Question: 6
You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. You set recovery model full. You run a full database backup for the whole the
user databases at 01:00 hours everyday. The transaction log backup happens each 20 minutes.
You could run a differential backup each 5 hours. You decide to run a full backup of the Products
database at 12:00 hours. Not only you should make sure that you could run the backup without
affecting the overall backup and restore procedures for the Products database but also you could
restore the Backup files in proper sequence. Which is the correct answer?

A. You should use the codes below:
B. bak ' WITH NOUNLOAD;
C. You should use the codes below:
D. bak' WITH COPY_ONLY;
E. You should use the codes below:
F. trn' WITH DIFFERENTIAL;

Answer: E

Question: 7
You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. There is 100 GB information in Products database.2 GB of information is changed
4
70-432

everyday on an average. You have set the recovery model of the Products database Simple.
Business requirements clarify that data loss of more than three hours worth of transactions during
business hours could not run normally. You should make sure that choosing a backup strategy
will utilize the least number of disk spaces through adhering to the business requirements. Which
is the correct answer?

A. You should run a full database backup once everyday
B. You should run a full database backup once everyday and then run a differential backup every
three hours during business hours.
C. You should run a differential backup each three hours during business hours.
D. You should run a transaction log backup each three hours during business hours.

Answer: B

Question: 8
You are mastering the company database, and managing 20 SQL Server 2005 computers which
are operated by other administrators that are asked to meet company service level agreements
(SLAs) on querying response time .Some of the method on controlling query response times on
the servers should be told for these administrators. Which is the correct answer?

A. You should create a query that searches the sys.dm_db_partition_stats dynamic management
view (DMV). Then distribute this search to the administrators.
B. You should develop an XML schema which includes the event and column names of the query
response times, which should be captured in SQL Server Profiler.
C. You should develop SQL Server Profiler templates, which contain query start times and end
times. Then distribute these templates to the database
D. You should teach the administrators to use System Monitor Control Tool

Answer: C

Question: 9
You are managing a SQL Server 2008 instance which contains a stored procedure which is
utilized as the data source for a report which is implemented during business hours for
Company.com. A user called Clerk tells you that the data returned by the report is not safety. You
find out that the results are caused by phantom reads. You should make sure that the report
returns results without connecting with other users. Which is the correct answer?

A. You should make the database Read Committed Snapshot isolation
B. You should make the database Auto Update Statistics
C. You should change the stored procedure to utilize the Snapshot isolation level.
D. You should change the stored procedure to utilize the Read Committed Snapshot isolation
level.

Answer: C

Question: 10
You are managing a SQL Server 2008 instance which includes some applications for
Company.com. You set the SQL Server Agent service to implement through utilizing the
SerTest\Test account. You create a job named MailingTester that allows a file to be stored to a
log server. The job could not run normally because it could not own proper access to the log
server. You decide to set the service of SQL Server Agent. You should make sure that you could
run the settings such that the SQL Server Agent service owns all access to the log server. Which
is the correct answer?

A. You should utilize the type of Domain account
5
70-432

B. You should utilize the type of remote System account
C. You should utilize the type of remote Service account
D. You should utilize the type of Local Service account

Answer: A






6