- Home
- Microsoft Certification
- 070-764 Exam
- Microsoft.070-764.dumpsfiles Dumps
Free Microsoft 070-764 Exam Dumps Questions & Answers
| Exam Code/Number: | 070-764Join the discussion |
| Exam Name: | Administering a SQL Database Infrastructure |
| Certification: | Microsoft |
| Question Number: | 452 |
| Publish Date: | Jul 16, 2026 |
|
Rating
100%
|
|
Total 452 questions
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it As a result, these questions wilt not appear in the review screen.
You have a database named DB1 that contains a table named Table1. You need to audit all updates to Table1.
Solution: You convert Table1 to a system-versioned temporal table. Does this meet the goal?
You administer all the deployments of Microsoft SQL Server 2016 in your company.
You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off- loaded from the primary database to another server.
You also need to be able to add indexes to the secondary database.
Which configuration should you use?
A company has the following Microsoft SQL Server instances Instance1 and Instance2. You plan to enable Always Encrypted for both instances.
You need to configure the instances to meet the following requirements:
* Instance1 must use an initialization vector that is different each time the instance is initiated.
* Instance2 must use an initialization vector that is derived from an algorithm.
In the table below, identify the encryption type that must be used for each instance.
NOTE: Make only one selection in each column. Each correct selection is worth one point.
Explanation
Always Encrypted supports two types of encryption: randomized encryption and deterministic encryption.
* Randomized encryption uses a method that encrypts data in a less predictable manner. Randomized encryption is more secure, but prevents searching, grouping, indexing, and joining on encrypted columns.
* Deterministic encryption always generates the same encrypted value for any given plain text value.
Using deterministic encryption allows point lookups, equality joins, grouping and indexing on encrypted columns. However, but may also allow unauthorized users to guess information about encrypted values by examining patterns in the encrypted column, especially if there is a small set of possible encrypted values, such as True/False, or North/South/East/West region.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine
You administer a Microsoft SQL Server 2016 database named Contoso on a server named Server01.
You need to track all SELECT statements issued in the Contoso database only by users in a role named Sales.
What should you create?
You work as a Database Administrator (DBA) for a company named ABC.com.
The company uses a Microsoft SQL Server 2012 infrastructure.
You are configuring a highly-available database solution using an AlwaysOn availability group on two servers running SQL Server 2012. The two servers are in separate datacenters.
The two datacenters are connected by a WAN link with a network latency of more than 200ms.
Which of the following failover types should you configure for the availability group?