- All Exams Instant Download
What should you do?
DRAG DROP You administer several Microsoft SQL Server 2012 servers. Your company has a number of offices across the world connected by using a wide area network (WAN). Connections between offices vary significantly in both bandwidth and reliability. You need to identify the correct replication method for each scenario. What...
What should you do?
You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured. When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated. The following error message is an example of the truncated error message: "Executed as user CONTOSOServiceAccount....0.4035.00 for 64-bit...
What should you do?
You administer a Microsoft SQL Server 2012 database. Users report that an application that accesses the database displays an error, but the error does not provide meaningful information. No entries are found in the SQL Server log or Windows event logs related to the error. You need to identify the...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...
Which Transact-SQL statement should you use?
You administer a Microsoft SQL Server 2012 database named ContosoDB. The database contains a table named Suppliers and a column named IsActive in the Purchases schemA. You create a new user named ContosoUser in ContosoDB. ContosoUser has no permissions to the Suppliers table. You need to ensure that ContosoUser can...
How should you configure HaContoso?
You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA. Currently, Server01l/HA is the primary replicA. You need to ensure that the following requirements are met: Backup operations occur on Server02/HA. If Server02/HA is unavailable, backup operations occur on Server03/HA. Backup operations do not occur...
Which four actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1 and Node 2. Node 1 fails and the cluster fails over to Node 2. You need to replace Node 1 and add it to the cluster. Which four actions should you perform...
What should you do?
You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured...
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?A . •...
Which Transact-SQL statement should you use before attempting the restore?
You administer a Microsoft SQL Server 2012 database. You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MyPassword1!' CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate'; BACKUP CERTIFICATE TDE_Certificate TO FILE = ''d:TDE_Certificate.cer' WITH PRIVATE KEY (FILE...
