You need to ensure that CLR assemblies can be used
You administer a Microsoft SQL Server database.
You plan to deploy a new database application. You want to use SQL Server common
language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?
Which four Transact-SQL statements should you use?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database named
AdventureWorks2008R2 that hosts a credit card-processing application.
You need to implement transparent data encryption.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)
Which of the following actions should you take?
You work as an administrator at Contoso.com. The Contoso.com network consists of a single domain
named Contoso.com. All servers in the Contoso.com domain have Windows Server 2012 R2
installed.
You have logged on to a server, named ENSUREPASS-SR07, and would like to obtain the IP
configurations of a server, named ENSUREPASS-SR13.
Which of the following actions should you take?
Which of the following is not a valid option to take?
You work as an administrator at Contoso.com. The Contoso.com network consists of a single domain
named Contoso.com. All servers on the Contoso.com network have Windows Server 2012 R2
installed. You have been instructed to make sure that a server, named ENSUREPASS-SR07, is
configured to be managed remotely from ENSUREPASS-SR01 using Server Manager.
Which of the following is not a valid option to take? (Choose all that apply.)
Which of the following would you recommend?
You work as an administrator at Contoso.com. The Contoso.com network consists of a single domain
named Contoso.com. All servers on the Contoso.com network have Windows Server 2008 R2
installed.
Most of the Contoso.com servers have 64 – bit CPU’s installed, while the rest have 32 – bit CPU’s
installed. You are informed that Contoso.com wants to deploy Windows Server 2012 R2 on all their
servers.
You need to make recommendations to ensure that this is possible.
Which of the following would you recommend?
Which of the following actions should you take?
You work as an administrator at Contoso.com. The Contoso.com network consists of a single domain
named Contoso.com. All servers on the Contoso.com network have Windows Server 2012 installed.
Contoso.com has its headquarters in London, and several widespread satellite offices. When
Contoso.com releases a new written policy stating that the graphical user interface (GUI) should not
be installed on any servers deployed to Contoso.com’s satellite offices.
It is reported that a server in one of the satellite offices are not compliant with the new written
policy.
You are required to remedy the situation, while using the least amount of user interaction.
Which of the following actions should you take?
You need to limit the amount of CPU and RAM used by the reporting group
You administer a Microsoft SQL Server database that hosts an order-processing application.
Employees in the order entry group perform real-time data entry for customers. Employees
in the reporting group run historical reports.
Employees in the order entry group report of poor performance when the reporting group
runs reports.
You need to limit the amount of CPU and RAM used by the reporting group.
What should you do?
You need to identify the purpose of each Dynamic Management Views (DMVs)
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).
What should you do? (To answer, drag the appropriate purpose to the correct DMV in the
answer area. Each purpose may be used once, more than once, or not at all. Each DMV
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 three actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database installed along with the default
settings.
You want to migrate a database from a SQL Server 2000 server that is being
decommissioned. The application instantiates ActiveX objects from stored procedures in the
database by using sp_OACreate.
You need to configure SQL Server 2008 R2 to allow command-line calls from this database.
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.)
Which query should you use?
You need to generate the following XML document.
<ProductExport>
<Product Price=”99″>Product1</Product>
<Product Price=”199″>Product2</Product>
<Product Price=”299″>Product3</Product>
<Product Price=”399″>Product4</Product>
</ProductExport>
Which query should you use?