Which four actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database that contains customer invoice
accounts.
Backups are performed according to the following schedule:
-Full database backup at 00:00 hours daily. -Transaction log backups at 06:00 hours, 14:00
hours, and 20:00 hours daily.
You discover that the database failed at 11:59 hours. You also discover that the database is
no longer accessible due to a failure of the hard disk drive that contains the database data
file.
You need to restore the database. You also need to ensure that data loss is minimal.
Which four 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 two actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales
management application.
Occasionally, users of the application report that they receive a deadlock error. You plan to
troubleshoot this error.
You need to ensure that the instance is configured to capture troubleshooting information
that will allow you to isolate the cause of the error.
Which two 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 actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance. The service account
used by SQL Server services must not have administrative permissions.
You configure a new SQL Server Agent job to run every night. One of the steps in the job
runs a PowerShell step. The job continuously fails on this step and throws the following error
message:
“The process could not be created for step 1 of job (reason: A required privilege is not held
by the client). The step failed.”
You need to ensure that the SQL Server Agent Job executes successfully.
Which four 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 two actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 server that hosts two databases named
NorthwindOLTP and NorthwindOLAP. Cross database ownership chaining is currently
disabled for all databases.
A stored procedure in the NorthwindOLTP database writes data to a table in the
NorthwindOLAP database. The public role in both databases has only Read and Execute
permissions assigned to all objects. All objects are located in the DBO schema. Guest
access has been disabled for all databases on the server.
You need to ensure that the stored procedure can execute successfully.
Which two 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.)
What should you configure?
Your network contains an Active Directory domain named contoso.com. All user accounts are in an
organizational unit (OU) named Employees.
You create a Group Policy object (GPO) named GP1. You link GP1 to the Employees OU.
You need to ensure that GP1 does not apply to the members of a group named Managers.
What should you configure?
How can you manage a newly installed Windows Server 2012 R2 core from a another Windows Server 2012 R2 with co
How can you manage a newly installed Windows Server 2012 R2 core from a another Windows
Server 2012 R2 with computer manager?
Exhibit:
Which TransactSQL statement should you use?
Your server collation is SQL_Latin1_General_CP1_CI_AS. You have a database named Contoso that
has a collation setting of SQL_Scandinavian_Cp850_CI_AS. You create and populate a temporary
table
#Person from table dbo.Person in Contoso using the following statements:
use MyDB;
CREATE TABLE #Person (LastName nchar(128));
INSERT INTO #Person SELECT LastName FROM dbo.Person;
You then run the following command:
SELECT * FROM dbo.Person a JOIN #Person b
ON
a.LastName = b.LastName;
This command returns the following error:
Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and
“SQL_Scandinavian_Cp850_CI_AS” in the equal to operation. You need to resolve the collation
conflict.
Which TransactSQL
statement should you use?
What should you configure on each virtual machine?
You have a server named Server1 that runs Windows Server 2012 R2. Server1 has 2 dual-core
processors and 16 GB of RAM.
You install the Hyper-V server role in Server1.
You plan to create two virtual machines on Server1.
You need to ensure that both virtual machines can use up to 8 GB of memory. The solution must
ensure that both virtual machines can be started simultaneously.
What should you configure on each virtual machine?
Which technology should you include in your solution?
You maintain a SQL Server 2008 instance that contains a database named Finance.
You need to configure SQL Server to automatically send an e-mail message when any file in
the Finance database increases.
Which technology should you include in your solution?
You need to view the service location (SVR) records that Server1 registers on DNS
You have a server named Server1 that runs Windows Server 2012 R2. You promote Server1 to
domain controller. You need to view the service location (SVR) records that Server1 registers on
DNS. What should you do on Server1?