You need to ensure that the design can provide…?
You are designing an extract, transform, and load (ETL) solution that loads data into
dimension tables. The ETL process involves many transformation steps.
You need to ensure that the design can provide:
• Auditing information for compliance and business user acceptance
• Tracking and unique identification of records for troubleshooting and error correction
What should you do?
You need to supply the stored procedure with multiple event names and their dates as parameters
You develop a database for a travel application.
You need to design tables and other database objects.
You create a stored procedure.
You need to supply the stored procedure with multiple event names and their dates as
parameters.
What should you do?
Which Data Quality Services (DQS) option should you use?
HOTSPOT
You are a data warehouse developer responsible for developing data cleansing processes.
Duplicate employees exist in an employee dimension.
You need to map, discover, and manage domain values based on the employee dimension.
Which Data Quality Services (DQS) option should you use? (To answer, select the
appropriate option in the answer area.)
What should you create for each application?
You develop a Microsoft SQL Server 2012 database. The database is used by two web
applications that access a table named Products. You want to create an object that will
prevent the applications from accessing the table directly while still providing access to the
required data.
You need to ensure that the following requirements are met:
Future modifications to the table definition will not affect the applications’ ability to access
data.
The new object can accommodate data retrieval and data modification.
You need to achieve this goal by using the minimum amount of changes to the applications.
What should you create for each application?
Which item should you add to the package?
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The package
contains a user-defined variable named ©Queue which has an initial value of 10.
The package control flow contains many tasks that must repeat execution until the ©Queue
variable equals 0.
You need to enable the tasks to be grouped together for repeat execution.
Which item should you add to the package? (To answer, select the appropriate item in the
answer area.)
Which four Transact-SQL statements should you use?
DRAG DROP
You create a view based on the following statement:
You grant the Select permission to User1 for this view. You need to change the view so that
it displays only the records that were processed in the month prior to the current month. You
need to ensure that after the changes, the view functions correctly for User1. Which four
Transact-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.)
Which four Transact-SQL statements should you use?
DRAG DROP
You want to add a new GUID column named BookGUID to a table named dbo.Book that
already contains data.
BookGUID will have a constraint to ensure that it always has a value when new rows are
inserted into dbo.Book. You need to ensure that the new column is assigned a GUID for
existing rows. Which four Transact-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.)
Which DQS activity should you use?
You are creating a Data Quality Services (DQS) solution. You must provide statistics on the
accuracy of the data.
You need to use DQS profiling to obtain the required statistics.
Which DQS activity should you use?
You need to create a solution to meet the requirements by using the least amount of administrative effort
You are developing a SQL Server Integration Services (SSIS) project to read and write data
from a Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of
the target Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of
administrative effort.
What should you do?
What should you use to retrieve the document from the website?
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data
from a Windows Azure SQL Database database.
To improve sales data accuracy, exchange rates must be downloaded daily from a public
HTTP website instead of from a weekly flat file. The public website hosts a commaseparated values (CSV) file that contains one row per currency.
You need to download the CSV file to the environment.
What should you use to retrieve the document from the website?