Free Microsoft 70-765 Exam Dumps Questions & Answers

You have a database named DB1 in a Microsoft Azure virtual machine (VM). You install a certificate named TDECert on the server.
You must encrypt all data at rest and provide real-time encryption and decryption for transmitted and received data.
You need to implement Transparent Data Encryption for DB1.
How should you complete the Transact-SQL statements? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Correct Answer:

Explanation:
To use TDE, follow these steps.
- Create a master key
- Create or obtain a certificate protected by the master key
- Create a database encryption key and protect it by the certificate
- Set the database to use encryption
Example:
USE master;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<UseStrongPasswordHere>';
GO
CREATE CERTIFICATE MyServerCert WITH SUBJECT = 'My Certificate';
GO
USE AdventureWorks2012;
GO
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_128
ENCRYPTION BY SERVER CERTIFICATE MyServerCert;
GO
ALTER DATABASE AdventureWorks2012
SET ENCRYPTION ON;
GO
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-2017

You deploy a Microsoft SQL Server instance to support a new application. The application uses the tempdb database maintain session state data.
Users reports performance issues with the application. You observer performance problems immediately and begin troubleshooting. You observer numerous instances of the page PAGE_up and PAGEELATCH_EX wait events in the logs for the server. The resources for the description for the wait is 2:1:1.

• A.  Increase the size of the tempdb.
• B.  Enable trace flag 3226.
• C.  Increase the values of the Cost Threshold parallelism settings.
• D.  Increase the number of tempdb files.

Note: This questions is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You manage on-premises and Microsoft Azure SQL Database instances for a company. Your environment must support the Microsoft SQL Server 2012 ODBS driver.
You need to encrypt only specific columns in the database.
What should you implement?

• A.  dynamic data masking
• B.  BitLocker
• C.  Always Encrypted
• D.  Transparent Data Encryption
• E.  cell-level encryption
• F.  transport-level encryption
• G.  Encrypting File System

You plan to deploy multiple Microsoft SQL Servers to a set of Windows Server virtual machines. You create the following configuration file:

You run the following batch file to start the installation:

The Postinstall. Sq1 script contains the following Transact-SQL statements;

You need to evaluate the installation process.
What changes are made during the installation?
To answer, select the appropriate responses in the answer area.

Correct Answer:

You have a database named DB1 that is 3 TB. obi contains a fact table that is 1.2 TB.
You load 200 GB of new data to the fact table from a line-of-business application.
Users of DB1 notice that reports render more slowly since you loaded the data.
What are two possible causes of the performance issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.  transaction log growth
• B.  page corruption
• C.  index fragmentation
• D.  out-of-date statistics