Which three actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2012 server.
You need to install the Power View components on a stand-alone server.
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 migrate the databases to a 64-bit SQL Server 2012 instance on the same server
You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a
Windows Server 2008 R2 64-bit server.
You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same
server. You also need to ensure that the new Transact-SQL functionality in SQL Server 2012
can be used in the database after the migration.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
You need to create the SSIS catalog on the production server and ensure that the operations log cleaning requi
You install a SQL Server 2012 database engine instance on a production server. A month
later, you install SQL Server 2012 Integration Services (SSIS).
You must develop an SSIS project and deploy it to the server by using the Project
Deployment model.
Operations log records that are outside the configured retention period must be cleaned
automatically.
You need to create the SSIS catalog on the production server and ensure that the
operations log cleaning requirement is met.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent jobs execute
You administer a Microsoft SQL Server 2012 instance.
You discover that the SQL Agent Error Log file is rapidly growing in size.
You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL
Server agent jobs execute.
What should you do?
Which solution should you use?
You are a database administrator for a Microsoft SQL Server 2012 instance.
You need to ensure that data can be replicated from a production server to two reporting
servers in real time. You also need to ensure that data on the reporting server is always
accessible.
Which solution should you use?
You need to ensure that the username and password values are encrypted when they are deployed
You are developing a project that contains multiple SQL Server Integration Services (SSIS)
packages. The packages will be deployed to the SSIS catalog. One of the steps in each
package accesses an FTP site to download data files.
You create project parameters to store the username and password that are used to access
the FTP site.
You need to ensure that the username and password values are encrypted when they are
deployed.
What should you do?
Which three steps should you perform in sequence?
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that is ready for
deployment to a production server. The package contains sensitive information secured by
using the EncryptSensitiveWithUserKey package protection level.
You are preparing the package for deployment by the production operations team.
You need to ensure that the production operations team can open and execute the package
without re-entering the sensitive information.
Which three steps 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.)
Which Transact-SQL batch should you use?
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?
How can you find this information?
A SQL Server Integration Services (SSIS) package was deployed two weeks ago with the
Project Deployment Model.
Sometimes the package is started as part of a multistep SQL job. At other times, the
package is started manually by a database administrator by using the Object Explorer in
SQL Server Management Studio.
You need to identify the authenticated user responsible for starting the package each time it
executes.
How can you find this information?
Which Transact-SQL command should you use?
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012
Standard Edition. The server hosts a database named Orders.
Users report that a query that filters on OrderDate is taking an exceptionally long time. You
discover that an index named IX_OrderDate on the CustomerOrder table is heavily
fragmenteD.
You need to improve the performance of the IX_OrderDate index. The index should remain
online during the operation.
Which Transact-SQL command should you use?