PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which query hint should you use?

You are a database developer. You plan to design a database solution by using SQL Server
2008. The database contains a table that is stored as a heap. You perform page-level
compression on the table. When data is added to the table by using BULK INSERT, the new
pages are not compressed. You need to ensure page-level compression for all data pages
when they are allocated to the table. Which query hint should you use?

You need to design a solution to transfer data from all offices to the reporting instance in the main office

You are a database developer. You plan to design a database solution by using SQL Server
2008. Your company has a main office in New York and several branch offices globally. All
the offices use databases on their local SQL Server 2008 servers to support trading
applications. A low-bandwidth WAN link connects the offices. The WAN link is subject to
interruptions. You plan to implement a reporting instance that will be deployed in the main
office. You need to design a solution to transfer data from all offices to the reporting
instance in the main office. You also need to ensure that the solution has minimum effect on
the performance of all trading servers. What should you do?

You need to ensure that the application automatically stores the current date and time data when a record is i

Your company is developing an application. The database platform for the application will
be vendor-independent. You need to ensure that the application automatically stores the
current date and time data when a record is inserted or updated, regardless of the database
platform. What should you do?

You need to ensure that when an item is removed from Table1, all related items are removed from Table1_Details

A database contains two tables named Table1 and Table1_Details. Table1_Details contains
details about the items in Table1. You need to ensure that when an item is removed from
Table1, all related items are removed from Table1_Details. You must achieve this goal by
using the minimum amount of Transact-SQL code. What should you do?

Which Transact-SQL query should you use?

Your database contains a table named SalesOrders. The table includes a DATETIME column named
OrderTime that stores the date and time each order is placed. There is a non-clustered index on the
OrderTime column.
The business team wants a report that displays the total number of orders placed on the current
day.
You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?