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 setting should you use?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by
using SQL Server Management Studio.
You need to execute the package and minimize the number of event types that are logged.
Which setting should you use? (To answer, change the appropriate setting in the answer area.)
You need to capture execution plans that will include detailed information on missing indexes recommended by t
You are developing a database application by using Microsoft SQL Server 2012. You have a
query that runs slower than expected.
You need to capture execution plans that will include detailed information on missing
indexes recommended by the query optimizer.
What should you do?
Which Transact-SQL statement should you use?
You use Microsoft SQL Server 2012 to develop a database application. You create a stored
procedure named dbo.ModifyData that can modify rows.
You need to ensure that when the transaction fails, dbo.ModifyData meets the following
requirements:
Does not return an error
Closes all opened transactions
Which Transact-SQL statement should you use?
You need to reduce procedure cache usage from these statements without creating any additional indexes
You are developing a database application by using Microsoft SQL Server 2012. An
application that uses a database begins to run slowly.
You discover that a large amount of memory is consumed by single-use dynamic queries.
You need to reduce procedure cache usage from these statements without creating any
additional indexes.
What should you do?
You need to ensure that all the execution trees run in parallel
You are performance tuning a SQL Server Integration Services (SSIS) package to load sales
data from a source system into a data warehouse that is hosted on Windows Azure SQL
Database. The package contains a data flow task that has 10 source-to-destination
execution trees.
Only five of the source-to-destination execution trees are running in parallel.
You need to ensure that all the execution trees run in parallel.
What should you do?
Which Transact-SQL query should you use?
You create a table that has the StudentCode, SubjectCode, and Marks columns to record
mid-year marks for students. The table has marks obtained by 50 students for various
subjects.
You need to ensure that the top half of the students arranged by their average marks must
be given a rank of 1 and the remaining students must be given a rank of 2.
Which Transact-SQL query should you use?
You need to restore the server that hosts Data Quality Server to another server
You are the administrator of a server that hosts Data Quality Server for a large retail
company.
The server had a hardware failure during business hours.
You need to restore the server that hosts Data Quality Server to another server. You have a
recent backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
You need to store the departure and arrival dates and times of flights along with time zone information
You develop a database for a travel application.
You need to design tables and other database objects.
You create the Airline_Schedules table.
You need to store the departure and arrival dates and times of flights along with time zone
information.
What should you do?
You need to configure the package to meet the requirements by using the least development effort
To support the implementation of new reports, Active Directory data will be downloaded to a
SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package.
The following requirements must be met:
All the user information for a given Active Directory group must be downloaded to a SQL
Server table. The download process must traverse the Active Directory hierarchy recursively.
You need to configure the package to meet the requirements by using the least development
effort.
What should you use?