What should you install?
You are preparing to install SQL Server 2012 Master Data Services (MDS).
You need to ensure that the database requirements are met.
What should you install?
Which Transact-SQL statement should you use?
You develop a Microsoft SQL Server 2012 database that contains tables named Employee
and Person. The tables have the following definitions:
You create a view named VwEmployee as shown in the following Transact-SQL statement.
Users are able to use single INSERT statements or INSERT…SELECT statements into this
view. You need to ensure that users are able to use a single statement to insert records into
both Employee and Person tables by using the VwEmployee view.
Which Transact-SQL statement should you use?
You need to provision the hardware and install the software for the server that runs the Data Quality Server
You are installing the Data Quality Server component of Data Quality Services.
You need to provision the hardware and install the software for the server that runs the Data
Quality Server.
You must ensure that the minimum Data Quality Server prerequisites are met.
What should you do?
You need to improve the performance of the view by persisting data to disk
You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and
OrderDetails tables by using the following definition.
You need to improve the performance of the view by persisting data to disk.
What should you do?
You need to use the least amount of administrative effort to achieve this goal
You are implementing a SQL Server Integration Services (SSIS) package that imports
Microsoft Excel workbook data into a Windows Azure SQL Database database. The
package has been deployed to a production server that runs Windows Server 2008 R2 and
SQL Server 2012.
The package fails when executed on the production server.
You need to ensure that the package can load the Excel workbook data without errors. You
need to use the least amount of administrative effort to achieve this goal.
What should you do?
Which Transact-SQL query should you use?
Your database contains tables named Products and ProductsPriceLog. The Products table
contains columns named ProductCode and Price. The ProductsPriceLog table contains
columns named ProductCode, OldPrice, and NewPrice. The ProductsPriceLog table stores
the previous price in the OldPrice column and the new price in the NewPrice column.
You need to increase the values in the Price column of all products in the Products table by
5 percent.
You also need to log the changes to the ProductsPriceLog table.
Which Transact-SQL query should you use?
Which profile type should you use?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
You use a Data Profiling task to examine the data from a source system. You need to
establish:
The minimum and maximum dates for the datetime columns in the source data
The minimum, maximum, and average values for numeric columns in the source data
You need to use the appropriate profile type in the Data Profiling task.
Which profile type should you use? (To answer, select the appropriate profile type in the answer area.)
Which four actions should you perform in sequence?
DRAG DROP
Your company is evaluating the data cleansing capabilities of SQL Server Data Quality
Services (DQS).
A stand-alone server will be used to host DQS, as well as all related services necessary to
run this service.
You need to install the DQS components on the server by using the minimum amount of
steps possible. You also need to grant permissions to a login named DataStewards to
enable DataStewards to edit and execute DQS projects.
Which four 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 should you use?
A table named Profits stores the total profit made each year within a territory. The Profits
table has columns named Territory, Year, and Profit. You need to create a report that
displays the profits made by each territory for each year and its previous year.
Which Transact-SQL query should 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 data source will be polled once per hour. The data is updated with multiple important
status changes per minute.
For each captured data change, the before and after values must be included.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option in the dialog box in the answer area.)