PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which query hint should you recommend?

You are a database developer. You plan to create a database by using SQL Server 2008. A
database contains a table named Sales. The Sales table contains customer order summary
information. You create a stored procedure that uses a SELECT statement. At the moment
of execution, the procedure must return a precise summation of the total sales for the
current day. You need to use a query hint to prevent any data modification in the Sales table
when the stored procedure is being executed. Which query hint should you recommend?

Which is the correct answer?

You are creating a SQL Server 2008 Integration Services (SSIS) instance which includes
components below for Company.com.
*An OnError method
*A data flow job included in a For Loop container
*A Flat File result component which utilizes a Flat File connection controller.

You decide to log error information from an expression which contains the package version
to a doc file when you get error message.
You should make sure that the information is writte into the doc file.
Which is the correct answer?

Which action will you perform?

You are a professional level SQL Sever 2008 Database Administrator. A database is hosted
by the instance. You can see the backup strategy utilized by the database from table listed
below: A batch process is run on Saturday, and the process lasts from 21:00 hr to 23:00 hr;
you find that the batch process takes no effect because certain data is modified some data
by a user at 21:05 hr on the same day. The database should be recovered to its state at the
start of the batch process in the shortest time. Which action will you perform?

What will you do?

You are a professional level SQL Sever 2008 Database Administrator. The largest table in a
database is partitioned into four equal-sized parts. The first two partitions are seldom
queried, while the third partition is regularly queried by several reports. Meanwhile, the
fourth partition is heavily queried and regularly modified. The disk space of the table should
be cut to the least and the query performance should be with the least impact. What will you
do? (Choose more