What should you include in your solution?
You administer a SQL Server 2008 instance. A payroll application is used to store sensitive
data in a database named PayrollDB.
You plan to implement the following security measure: -All the data files, log files, and
backup files of the database are automatically encrypted. You need to devise a method to
encrypt data. What should you include in your solution?
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 executes a number of Windows command-line calls from
stored procedures in the database.
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 four Transact-SQL statements should you use?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 instance by using a database named
AdventureWorks2008R2.
You need to implement transparent data encryption for a database hosted by the server.
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.)
You need to partition the table by year
You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems
table. The table has the following definition:
Currently, the table is not partitioned and contains no indexes.
You need to partition the table by year.
What should you do?
Which statement should you use?
You need to capture the execution plan for a query. Which statement should you use?
Which TransactSQL setting should you use?
You are troubleshooting query performance on SQL Server 2008. You are tasked to create an
estimated execution plan by using TransactSQL.
You should be able to view the plan graphically in SQL
Server Management Studio. You need to ensure that the execution plan can be saved as a .sqlplan
file.
Which TransactSQL
setting should you use?
Which file extension should you use?
You are troubleshooting query performance on SQL Server 2008. You are tasked to capture a
graphical execution plan. You need to save the plan to a file that can be used by SQL Server
Management
Studio to display the graphical execution plan.
Which file extension should you use?
Which TransactSQL statement should you use?
You have run a server side trace that created 45 trace files. You want to load the trace files on your
workstation in a database table called PerfData for further analysis. You need to load three files
starting at
c:\my_trace_38.trc.
Which TransactSQL
statement should you use?
Which event should you use?
You are using SQL Server Profiler to gather deadlock information. You need to capture an XML
description of a deadlock. Which event should you use?
Which TransactSQL statement should you use?
You are troubleshooting query performance on SQL Server 2008. You have profiler trace data in
a table named PerfData. You need to determine which events are taking longer than one second of
CPU
time or run for more than two seconds.
Which TransactSQL
statement should you use?