You need to design a solution that meets the requirements
You are designing a SQL Server Integration Services (SSIS) solution. The solution will
contain an SSIS project that includes several SSIS packages. Each SSIS package will
define the same connection managers and variables.
You have the following requirements:
The deployment model must support changing the content of connection strings by using
parameters at execution time.
The deployment model must automatically log events to the SSISOB database.
Maximize performance at execution time.
You need to design a solution that meets the requirements. What should you do? (More than
one answer choice may achieve the goal. Select the BEST answer.)
Which backup option should you use?
You administer a Microsoft SQL Server 2012 database. You want to make a full backup of
the database to a file on disk.
In doing so, you need to output the progress of the backup.
Which backup option should you use?
Which command(s) or tool(s) should you use?
DRAG DROP
You administer a Microsoft SQL Server 2012 database. The database contains two tables
named Table A and Table B.
You perform an import and export operation by using the following steps in sequence, as
shown in the exhibit. (Click the Exhibit button.)
Load data from a third-party database to Table A.
Insert a subset of records from Table A to Table B. Export the data from Table B to a flat
file.
You also create a format file for the data export.
You need to choose the correct command or tool for each task. You need to ensure that
each task is performed efficiently.
Which command(s) or tool(s) should you use? (To answer, drag the appropriate
command(s) or tool(s) to their corresponding task or tasks in the answer area. Answer
choices may be used once, more than once, or not at all. Answer targets may be used once
or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
Which transformation should you use?
HOTSPOT
You are developing a SQL Server Integration Service (SSIS) package. The package loads a
customer dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last
Extract, Transform and Load (ETL) process execution. You need to use the least amount of
development effort to achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in
the answer area.)
You need to develop a Transact-SQL (T-SQL) script to meet these requirements
DRAG DROP
You are the administrator for a Data Quality Server. You are adding a user who must have
permission to:
Edit and execute a project
View the activity monitoring data
This user must not be able to:
Perform any kind of knowledge management
Create or change a knowledge base
Terminate an activity or perform administrative duties
You need to develop a Transact-SQL (T-SQL) script to meet these requirements.
What should you do? (To answer, drag the appropriate code segment or segments to the
correct location or locations in the answer area.)
Which Transact-SQL statement should you insert at line 06?
You are a database administrator for a Microsoft SQL Server 2012 database named
AdventureWorks2012.
You create an Availability Group defined by the following schema. (Line numbers are
included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
Production transactions should be minimally affected.
The secondary server should allow reporting queries to be performed.
If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
You need to configure the parameter to meet the requirements
HOTSPOT
A SQL Server Integration Services (SSIS) package is designed to download data from a
financial database hosted in SQL Azure.
The connection string to the financial database is defined as a project parameter named
FinConStr. The parameter value must be stored securely and must be set explicitly every
time the package is executed.
You need to configure the parameter to meet the requirements.
What should you do? (To answer, configure the appropriate option or options in the dialog
box in the answer area.)
You need to configure the distribution agent by granting only the minimum required access to all accounts
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2.
ProdSrv1 is configured as a Distributor. Both servers are configured to use the Windows NT
Service virtual accounts for all SQL Services.
You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a
pull subscriber.
The distribution agent on ProdSrv2 regularly fails, displaying the following error message:
“Cannot access the file. Operating system error code 5 (Access is denied.).”
You need to configure the distribution agent by granting only the minimum required access
to all accounts.
What should you do?
Which performance counter or counters should you use for each server?
DRAG DROP
You are a database administrator for a Microsoft SQL Server 2012 environment that
contains two SQL Server instances named Server01 and Server02. The Contoso database
is located on Server01. Through database mirroring, a copy of the Contoso database is on
Server02.
During the last manual failover of database mirroring, the recovery took longer than usual.
You need to determine where the synchronization bottleneck is for the database mirroring
topology.
Which performance counter or counters should you use for each server? (To answer, drag
the appropriate performance counter or counters to their corresponding server or servers in
the answer area. Answer choices may be used once, more than once, or not at all. Answer
targets may be used once or not at all. Additionally, you may need to drag the split bar
between panes or scroll to view content.)
Which user management menu item should you select?
HOTSPOT
You are the Master Data Services (MDS) administrator at your company.
An existing user must be denied access to a certain hierarchy node for an existing model.
You need to configure the user’s permissions.
Which user management menu item should you select? (To answer, configure the
appropriate option or options in the dialog box in the answer area.)