TS:MS SQL Server 2008,Implementation and Maintenance

Question 1

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?

A. Configure a new Database Mail profile to be used for the reports to the manager.

B. Change the Account Retry Attempts option of the Database Mail system properties.

C. Add another SMTP account to the existing Database Mail profile.

D. Use the (@importance = high parameter when you send the reports to the manager.

Correct Answer: A

Question 2

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?

A. Use the SQL Server 2008 Upgrade Advisor.

B. Use the SQL Server Profiler that captures the SQL:BatchCompleted and Exception event classes.

C. Use a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.

D. Use a SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes.

Correct Answer: C

Question 3

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?

A. You should develop a clustered index on the Name column.

B. You should develop a clustered index on the ProductLine, ListPrice, Class and Style columns.

C. You should develop a nonclustered index on the ProductLine, ListPrice columns.

D. You should develop a nonclustered index on the Name column.

Correct Answer: A

Question 4

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 Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?

A. Restore the backup taken on Sunday only.

B. Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
18:00
hours.

C. Restore the backup taken on Wednesday only.

D. Restore the backups taken on Sunday and Monday.

E. Restore the backups taken on Wednesday and Thursday at 09:00 hours.

F. Restore the backups taken Wednesday, Friday, and Saturday.

G. Restore the backups taken on Wednesday, Thursday, and Friday.

H. Restore the backups taken on Wednesday and Friday.

Correct Answer: D

Question 5

View Exhibit

A. Execute sp_who 56.

B. Use the Activity Monitor in Microsoft SQL Management Studio and locate process 55.

C. Execute sp_who 55.

D. Select from the sys.syslockinfo compatibility view and locate spid 55.

Correct Answer: A

Question 6

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?

A. You should change INDEXDEFRAG

B. You should change CLUSTERING_METHOD

C. You should change SHRINKFILE

D. You should change MODELLING_CARDINALITY

Correct Answer: B

Question 7

You administer a SQL Server 2008 instance. The server hosts databases for several mission-critical applications.
You plan to use the Resource Governor to limit the effect of queries that are executed by Microsoft SQL Server Management Studio.
You need to ensure that that the following requirements are met:
- Queries initiated through SQL Server Management Studio do not exceed 20 percent of CPU utilization. - Queries initiated by the mission-critical applications are allowed to consume 100 percent of CPU utilization when required.
What should you do?

A. Alter the default resource pool and set the MAX_CPU_PERCENT option to 80.
Assign tins resource pool to the workload group used by SQL Server Management Studio.

B. Alter the default resource pool and set the MAX_CPU_PERCENT option to 20.
Assign this resource pool to the workload group used by the mission-critical applications.

C. Create a new resource pool and set the MAX_CPU_PERCENT option to 20.
Assign this resource pool to the workload group used by SQL Server Management Studio.

D. Create a new resource pool and set the MAX_CPU_PERCENT option to 80.
Assign this resource pool to the workload group used by the mission-critical applications.

Correct Answer: C

Question 8

You maintain a SQL Server 2008 instance that contains a database named Finance.
Minimally logged operations are performed on the Finance database.
You need to verify that the database can be restored to a specific point in time.
What should you do?

A. Verify that the database uses the simple recovery model.

B. Verify that the database uses the full recovery model.

C. Verify that the database uses the checksum page verify option.

D. Verify that the database uses the bulk-logged recovery model.

Correct Answer: A

Question 9

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains a table named Orders. The Orders table has several indexes and a very large number of rows. The database supports an enterprise Web environment that is constantly used.
Thirty percent of the indexes on the Orders table is fragmented.
You need to defragment the indexes by ensuring that the effect on database availability is minimized.
Which option should you include in the ALTER INDEX statement?

A. Sort in tempdb

B. Online

C. Pad index

D. Fill factor

Correct Answer: B

Question 10

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. You should utilize transactions log between the server in each retail store and the central server in the main office.

B. Snapshot replication should be utilized. You should set the trg_Coupon trigger on the server in every store to utilize the NOT FOR REPLICATION option.

C. You should build multiple merge publications, one at every store and one in the main office.

D. You should utilize merge replication. You should set the trg_Coupon trigger on the server in each retail store to use the NOT FOR REPLICATION option.

Correct Answer: D

Question 11

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database contains a table named OrderDetail. You plan to export all data from this table to a file.
You need to ensure that the following data export requirements are met: A Microsoft Office Open XML document format is used The data export process is saved for reuse.
What should you do?

A. Run the SQLCmd utility and save the output to a file.

B. Run the bulk copy program utility along with a format file and an output file.

C. Run the bulk copy program utility along with an output file and no format file.

D. Run the SQL Import and Export Data Wizard and save the output to a file.

Correct Answer: D

Question 12

Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 070-432 Exam Practice Test

Latest Update

Useful Links

Contact Us