You need to implement a computed column that references a lookup table by using an INNER JOIN against another
You use Microsoft SQL Server 2012 to develop a database application. You need to
implement a computed column that references a lookup table by using an INNER JOIN
against another table.
What should you do?
You need to set up a deployment strategy that meets the requirements
You are deploying a new SQL Server Integration Services (SSIS) package to five servers.
The package must meet the following requirements:
.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.
The Connection Managers used in the package must be configurable without editing and
redeploying the package.
The deployment procedure must be automated as much as possible.
Performance must be maximized.
You need to set up a deployment strategy that meets the requirements.
What should you do?
You need to improve the performance of the query
You use a Microsoft SQL Server 2012 database that contains two tables named
SalesOrderHeader and SalesOrderDetail. The indexes on the tables are as shown in the
exhibit. (Click the Exhibit button.)
You write the following Transact-SQL query:
You discover that the performance of the query is slow. Analysis of the query plan shows
table scans where the estimated rows do not match the actual rows for SalesOrderHeader
by using an unexpected index on SalesOrderDetail.
You need to improve the performance of the query.
What should you do?
Which option should you use?
HOTSPOT
You are the data steward at your company.
Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services
(DQS) knowledge base and matching policy to identify these duplicate customers.
You need to identify the duplicate customers.
Which option should you use? (To answer, select the appropriate option in the answer area.)
Which three actions should you perform in sequence?
DRAG DROP
You are maintaining a SQL Server Integration Services (SSIS) package. The package uses
custom functionality that is implemented in Microsoft Visual C.
The implementation of the custom functionality changes overtime. The design of the
package allows you to deploy new releases of the custom functionality without redeploying
the entire package.
You need to implement and deploy an update to the custom functionality without requiring
package redeployment.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Which Transact-SQL query do you use?
You are a database developer for an application hosted on a Microsoft SQL Server 2012
server. The database contains two tables that have the following definitions:
Global customers place orders from several countries. You need to view the country from
which each customer has placed the most orders.
Which Transact-SQL query do you use?
Which CDC processing mode should you select?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for
the data flow task is a table that has been configured as a change data capture (CDC) table.
You are using a CDC Source component to obtain the CDC data.
The CDC Source component has the following requirements:
The output must include metadata columns that indicate which source columns have
changed.
The output must return only one change row per source row that is modified in the current
CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option or options in the dialog box in the answer area.)
Which Transact-SQL statement should you use?
You administer a SQL Server 2012 server that contains a database named SalesDb.
SalesDb contains a schema named Customers that has a table named Regions. A user
named UserA is a member of a role named Sales. UserA is granted the Select permission
on the Regions table. The Sales role is granted the Select permission on the Customers
schema.
You need to ensure that the following requirements are met:
The Sales role does not have the Select permission on the Customers schema.
UserA has the Select permission on the Regions table.
Which Transact-SQL statement should you use?
Which object should you use?
You use Microsoft SQL Server 2012 to develop a database application. You need to create
an object that meets the following requirements:
Takes an input variable
Returns a table of values
Cannot be referenced within a view
Which object should you use?
Which four T-SQL statements should you use?
DRAG DROP
You use a Microsoft SQL Server 2012 database. You need to create an indexed view within
the database for a report that displays Customer Name and the total revenue for that customer.
Which four T-SQL statements should you use? (To answer, move the appropriate SQL
statements from the list of statements to the answer area and arrange them in the correct order.)