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

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?

• A. SQL Server 2012 Standard (64-bit) x64 on the database server
• B. Microsoft SharePoint Server 2010 Enterprise Edition SP1
• C. SQL Server 2012 Enterprise (64-bit) x64 on the database server
• D. SQL Server 2012 Data Center (64-bit) x64 on the database server

You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:
- A data file of 2 terabytes is located on a dedicated LUN (drive D).
- A transaction log of 10 GB is located on a dedicated LUN (drive E).
- Drive D has 1 terabyte of free disk space.
- Drive E has S GB of free disk space.
The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
You implement log shipping of the financial database to another SQL Server 2012 instance. You decide to failoverto this secondary database.
You need to ensure that all transactions will be replicated to the secondary database.
Which backup option should you use?

• A. FULL
• B. CHECKSUM
• C. Transaction log
• D. BULK_LOGGED
• E. CONTINUE_AFTER_ERROR
• F. NORECOVERY
• G. Differential
• H. SIMPLE
• I. COPY_ONLY
• J. STANDBY
• K. RESTART
• L. NO_CHECKSUM
• M. DBO_ONLY
• N. SKIP

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. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that the following requirements are met:
The Sales role does not have the Select permission on the Customers schema.UserA has the Select permission on the Regions table.
Which Transact-SQL statement should you use?

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

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012.
You attempt to add a SQL login, [User1], to the database. However, you receive the following error message:
"User already exists in current database."
You need to configure the [User1] login to be able to access the Orders database and retain the original permissions. You need to achieve this goal by using the minimum required permissions.
Which Transact-SQL statement should you use?

• A. Option C
• B. Option A
• C. Option B
• D. Option D