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 evaluate existing and potential clustered and non-clustered indexes that will improve performance
You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an
application. You need to evaluate existing and potential clustered and non-clustered indexes that
will improve performance.
What should you do?
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 recover the corrupted data in the minimum amount of time
You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.
The Sales database is configured as shown in the following table.
You discover that Sales_2.ndf is corrupt. You need to recover the corrupted data in the minimum
amount of time. 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?
Which isolation level should you set to ON?
You have a table that contains 10 million rows. You need to design a query that returns a
100,000- row sample dataset. The solution must minimize the query’s execution time. The
sample may contain inconsistent data. Which isolation level should you set to ON?
Which SQL Server component should you use?
You need to design a database solution that meets the following requirements: • Supports
different types of databases • Provides reliable messaging between databases • Provides
data workload distribution across several databases Which SQL Server component should
you use?
Which approach should you use?
Your application contains a stored procedure for each country. Each stored procedure accepts an
employee identification number through the @EmpID parameter.
You plan to build a single process for each employee that will execute the stored procedure based
on the country of residence.
Which approach should you use?