70-764 exam

A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Databaseinstances. The environment hosts several customer databases. One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented. You need to optimize query performance....

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

Overview You are a database administrator for a company named Litware, Inc. Litware is a book publishing house. Litware has a main office and a branch office. You are designing the database infrastructure to support a new web-based application that is being developed. The web application will be accessed at...

You deploy a database by using SQL Server 2012. The database contains a table named Table1. You need to recommend a solution that meets the following requirements: Stores the most recent data from Table1 by using the fastest storage solution possible. Stores the historical data from Table1 by using a...

You manage a SQL Server 2014 instance that contains a database named DB1. Users report that some queries to DB1 take longer than expected. Although most queries run in less than one second, some queries take up to 20 seconds to run. You need to view all of the performance...

Overview Application Overview Contoso, Ltd., is the developer of an enterprise resource planning (ERP) application. Contoso is designing a new version of the ERP application. The previous version of the ERP application used SQL Server 2008 R2. The new version will use SQL Server 2014. The ERP application relies on...

DRAG DROP You need to recommend a backup process for data warehouse database. The solution must meet the following requirements: Ensure that if a hardware failure occurs, you can bring the database online without losing more than 24 hours of transactions. Minimize the amount of administrative effort required to restore...

Background Corporate Information Fabrikam, Inc. is a retailer that sells electronics products on the Internet. The company has a headquarters site and one satellite sales office. You have been hired as the database administrator, and the company wants you to change the architecture of the Fabrikam ecommerce site to optimize...

Overview General Overview ADatum Corporation has offices in Miami and Montreal. The network contains a single Active Directory forest named adatum.com. The offices connect to each other by using a WAN link that has 5-ms latency. A. Datum standardizes its database platform by using SQL Server 2014 Enterprise edition. Databases...

You are a database administrator for a Microsoft SQL Server 2016 environment. You want to deploy a new application that will scale out the workload to at least five different SQL Server instances. You need to ensure that for each copy of the database, users are able to read and...