Which event handler should you use?
You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a
table named Orders in a SQL Azure database.
The company’s auditing policies have the following requirements:
An entry must be written to a dedicated SQL Server log table named OrderLog.
The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements.
Which event handler should you use?
Which server-level audit action group should you use?
You administer a Microsoft SQL Server 2012 database.
You provide temporary securityadmin access to User1 to the database server.
You need to know if User1 adds logins to securityadmin.
Which server-level audit action group should you use?
Which three actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2012 server that has multiple databases.
You need to ensure that users are unable to create stored procedures that begin with sp_.
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.)
You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes
You are editing a SQL Server Integration Services (SSIS) package that contains three
Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have
their TransactionOption property set to Supported.
You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back
their changes.
What should you do?
You need to stop a blocking process that has an SPID of 64 without stopping other processes What should you do
You administer a Microsoft SQL Server 2012 instance.
You need to stop a blocking process that has an SPID of 64 without stopping other
processes
What should you do?
You need to add a task or component to the package that allows you to implement the SCD logic
You are creating a SQL Server Integration Services (SSIS) package that implements a Type
3 Slowly Changing Dimension (SCD).
You need to add a task or component to the package that allows you to implement the SCD
logic.
What should you use?
Which four actions should you perform in sequence?
DRAG DROP
You are designing an extract, transform, load (ETL) process with SQL Server Integration
Services (SSIS). Two packages, Package A and Package B, will be designed. Package A
will execute Package B.
Both packages must reference a file path corresponding to an input folder where files will be
located for further processing.
You need to design a solution so that the file path can be easily configured with the least
administrative and development effort.
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.)
What should you select from the SSIS Toolbox?
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that accesses a SQL Server database. The custom
functionality must be implemented by using Language Integrated Query (LINQ).
You need to ensure that the LINQ code can be debugged at design time.
What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the
correct location in the answer area.)
You need to identify the root cause of the issue by retrieving the error message
You administer a Microsoft SQL Server 2012 database.
Users report that an application that accesses the database displays an error, but the error
does not provide meaningful information. No entries are found in the SQL Server log or
Windows event logs related to the error.
You need to identify the root cause of the issue by retrieving the error message.
What should you do?
Which tool or tools should you use?
DRAG DROP
You administer a Microsoft SQL Server 2012 server.
A variety of issues occur from time to time in the production environment. You need to
identify the appropriate tool for each issue.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the
correct issue or issues in the answer area. Each tool may be used once, more than once, or
not at all. You may need to drag the split bar between panes or scroll to view content.)