You have a server that has SQL Server 2014 installed. The server contains 100 user databases.
You need to recommend a backup solution for the user databases.
The solution must meet the following requirements:
Perform a transaction log backup every hour.
Perform a full backup of each database every week.
Perform a differential backup of each database every day.
Ensure that new user databases are added automatically to the backup solution.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

DRAG DROP
You are designing a database for a university.
The database will contain two tables named Classes and Enrollment that have the following specifications:
Classes will store brochures in the XPS format. The brochures must be structured in folders and must be
accessible by using UNC paths.
Enrollment will store information about students and their classes. Performance must be enhanced for
queries of the current enrollments.
You need to identify which SQL Server technology meets the specifications of each table.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct table in the answer area.
Select and Place:

DRAG DROP
You plan to install two SQL Server 2014 environments named Environment1 and Environment.
Your company identifies the following availability requirements for each environment:
Environment1 must have mirroring with automatic failover implemented.
Environment2 must have AlwaysOn with automatic failover implemented.
You need to identify the minimum number of SQL Server 2014 servers that must be deployed to each
environment to ensure that all data remains available if a physical server fails.
How many servers should you identify?
To answer, drag the appropriate number to the correct environment in the answer area.
Select and Place:

You are designing a database named DB1.
Changes will be deployed to DB1 every Wednesday night.
You need to recommend a strategy to deploy the changes to DB1. The strategy must meet the following
requirements:
The strategy must not disrupt backup operations.
DB1 must be online while the changes are deployed.
You must be able to undo quickly any changes made to objects.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Azure.Which method should you recommend? More than one answer choice may achieve the goal. Select the BEST
answer.

You are designing a monitoring application for a new SQL Server 2014 instance.
You need to recommend a solution to generate a report that displays the 10 most frequent wait types that occur
for the instance.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

You administer a SQL Server 2014 instance.
Users report that the SQL Server has seemed slow today. A large database was being restored for much of the
day, which could be causing issues.
You want to write a query of the system views that will report the following:
Number of users that have a connection to the server
Whether a user’s connection is active
Whether any connections are blocked
What queries are being executed
Whether the database restore is still executing and, if it is, what percentage of the restore is complete.
Which system objects should you use in your query to best achieve this task?

You have four databases that are accessed by using an Online Transaction Processing (OLTP) application.
The databases are stored on a server named SQL1 that has SQL Server 2014 installed.
You plan to deploy an additional server that has SQL Server 2014 installed.
You need to design a high-availability solution for the databases that meets the following requirements:
If SQL1 fails, the databases must be available.
Users must be able to run reports against a secondary copy of the databases.
What should you include in the design?
More than one answer choice may achieve the goal. Select the BEST answer.

You are troubleshooting an application that runs a query. The application frequently causes deadlocks.
You need to identify the isolation level used by the query when a deadlock occurs.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a query that is used by a reporting dashboard.
Users report that the query sometimes takes a long time to run.
You need to recommend a solution to identify what is causing the issue.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.