HOTSPOT
You administer a Microsoft SQL Server 2012 database.
The database contains a table that has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.
You need to ensure that the following requirements are met:
The first row of the file contains the first row of data.
Each record is of the same length.
The date follows the U.S. date format.
The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
----

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from aWindows Azure SQL Database database. The project uses the PackageDeployment Model. This project is deployed to SQL Server on atest server.
You need to ensure that the project is deployed to the SSIS catalog on the production server.
What should you do?

• A. Configure the output of a component in the package data flow to use a data tap.
• B. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
• C. Add an OnError event handler to the SSIS project.
• D. Open a command prompt and run the dtexec /dumperror /conn command.
• E. create a reusable custom logging component and use it in the SSIS project.
• F. Configure the SSIS solution to use the Project Deployment Model.
• G. Open a command prompt and run the dtexec /rep /conn command.
• H. Open a command prompt and run the dtutil /copy command.
• I. Open a command prompt and run the gacutil command.
• J. use an msi file to deploy the package on the server.
• K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ActiveX Data Objects (ADO) source variable that holds a result set that was returned by a stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.
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 administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction.
You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index.
You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process,
Which Transact-SQL batch should you use?

• A. ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REORGANIZE
• B. ALTER INDEX ALL ON AccountTransaction REBUILD
• C. CREATE INDEX IDX AccountTransactionAccountCode ON AccountTransaction.AccountCode WITH DROP EXISTING
• D. ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REBUILD

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
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 and the Sales role is granted the Select permission on the Customers schema.
You need to ensure that the Sales role, including userA, is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?

• A. REVOKE SELECT ON Object::Regions FROM Sales
• B. DENY SELECT OH Schema::Customers FROM Sales
• C. REVOKE SELECT ON Object::Regions FROM UserA
• D. EXEC sp_addrolemember 'Sales', 'UserA'
• E. REVOKE SELECT ON Schema::Customers FROM Sales
• F. DENY SELECT ON Object::Regions FROM UserA
• G. DENY SELECT ON Object::Regions FROM Sales
• H. DENY SELECT ON Schema::Customers FROM UserA
• I. REVOKE SELECT ON Schema::Customers FROM UserA
• J. EXEC sp_droprolemember 'Sales', 'UserA'