70-764 exam

DRAG DROP You plan to deploy three highly available SQL Server environments that will use SQL Server 2014. You identify the following specifications for each environment as shown following table. You need to recommend which high-availability feature is required for each environment. Which features should you identify? To answer, drag...

You need to examine information about logins, CPU times, and Disk I/O on a particular database in Microsoft Azure. What should you use?A . Activity MonitorB . Sp_who3C . SQL Server Management Studio (SSMS) Object ExplorerD . SQL Server Data CollectorE . SQL Server Data Tools (SSDT)F . SQL Server...

HOTSPOT You are the database administrator of a Microsoft SQL Server instance. Developers are writing stored procedures to send emails using sp_send_dbmail. Database Mail is enabled. You need to configure each account’s profile security and meet the following requirements: Account SMTP1_Account must only be usable by logins that have been...

General Overview You are the Senior Database Administrator (DBA) for a software development company named Leafield Solutions. The company develops software applications custom designed to meet customer requirements. Requirements Leafield Solutions has been asked by a customer to develop a web-based Enterprise Resource Planning and Management application. The new application...

DRAG DROP You have five servers that run Microsoft Windows 2012 R2. Each server hosts a Microsoft SQL Server instance. The topology for the environment is shown in the following diagram. You have an Always On Availability group named AG1. The details for AG1 are shown in the following table....

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 administer a Microsoft SQL Server 2016 database that includes a table named Application.Events. Application.Events contains millions of records about user activity in an application. Records in Application.Events that are more than 90 days old are purged nightly. When records are purged, table locks are causing contention with inserts. You...

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

You plan to install Microsoft SQL Server 2016 for a web hosting company. The company plans to host multiple web sites, each supported by a SQL Server database. You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total...

You manage a Microsoft SQL Server environment. You plan to encrypt data when you create backups. You need to configure the encryption options for backups. What should you configure?A . a certificateB . an MD5 hashC . a DES keyD . an AES 256-bit keyView AnswerAnswer: D Explanation: To encrypt...