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…
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…
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…
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…
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…
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…
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…
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…
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…
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…