You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multipledatabases.
You need to recommend a method to set limits on processor time for each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a customer who has several SQL Server 2012 database servers.
You are designing a data warehouse for the customer. The data warehouse will use columnstore indexes.
The customer identifies that the following must be supported for the column store indexes.
Data manipulation language (DML) statements
Nonclustered columnstore indexes
Clustered columnstore indexes
Partitioning
You need to identify which technology requires the customer to implement an SQL Server 2014 database.
What should you identify?

You have a SQL Server 2014 environment that contains 20 servers.
The corporate security policy states that all SQL Server 2014 instances must meet specific security standards.
You need to recommend a management strategy for the SQL Server 2014 servers.What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction
processing sales system.
The company takes full backups every week; differential backups on the days with no full backups; and hourly
transaction backups. These backups are stored on a backup server in the company’s data center.
Every week, the company places the full backup on a tape and sends it to a third-party backup storage system.
The company is worried that a disaster might occur that could destroy their computer center and cause them to
lose orders.
You need to determine the best method for providing the smallest amount of data loss and downtime without
leasing or purchasing additional physical locations.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2014 environment that includes four servers. The servers are configured as shown in
the following table.

You plan to configure Policy-Based Management to enforce the following rules:
On Server1, enable SQL Server password policies and enable the default trace.
On Server3, ensure that the names of user-defined stored procedures begin with the prefix “usp_” and
ensure that all databases use a case-sensitive collation.
You need to recommend which server you must configure as a Central Management Server.
Which server should you recommend? (Each correct answer presents a complete solution. Choose all that
apply.)

You deploy a database by using SQL Server 2014. The database contains a table named Table1.
You need to recommend a solution to track all of the deletions executed on Table1. The solution must minimize
the amount of custom code required.
What should you recommend?

You are designing a SQL Server database for an order fulfillment system.
You create a table named Sales.Orders by using the following script:

Each order is tracked by using one of the following statuses:
Fulfilled
Shipped
Ordered
Received
You need to design the database to ensure that you can retrieve the status of an order on a given date. The
solution must ensure that new statuses can be added in the future.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

DRAG DROP
You use SQL Server 2014 Enterprise Edition. Your database contains a partitioned table named AuditData.
AuditData is partitioned by year. Partition 1 contains data from the year 2010 and prior.
Management has decided to archive all AUDITDATA records from 2010 and prior. Management wants the
records to be removed from the database entirely and provided to the backup team as a zipped text file. The
data must no longer reside in the database. There is very little tolerance for performance degradation in your
environment.
You need to remove all 2010 and prior data from the AuditData table by using the least amount of system
resources possible.
Develop the solution by selecting and arranging the required SQL actions in the correct order.
You may not need all of the actions.
Select and Place:

You have a server named Server1 that has 2 processors.
You plan to deploy multiple instances of SQL Server 2014 to Server1. Each instance will have multiple
databases.
You need to recommend a method to allocate processor time to each database.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2014 database named DB1.
You plan to import a large number of records from a SQL Azure database to DB1.
You need to recommend a solution to minimize the amount of space used in the transaction log during the
import operation.
What should you include in the recommendation?