Latest Microsoft 70-764 Practice Exam Questions | Pass 70-764 Exam in First Attempt

 Question #:1

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 sections, you will NOT be able to return to it. As a result, these

questions will 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?

A. Yes

B. No

Answer: B

Explanation

A temporal table provides information about data stored in the table at any point in time.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/tables/temporal-tables?view=sql-server-2017

Question #:2

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 will not appear in the review screen.

You administer a SQL Server Instance at Contoso Ltd.

A new employee named Kim Ralls must be able to read data only from the dbo.Order table in the SalesDB

database.

You create a SQL login named KimRalls. You then create a SQL user account named KimRalls in SalesDB.

The user account is associated with the SQL login.

You need to grant KimRalls the necessary permission or permissions. Your solution must follow the principle

of least privilege.

Solution: You perform the following actions:

Create a custom database role named OrderReader in SalesDB.

Grant the View Definition permission on dbo.Order to the OrderReader role.

Add KimRalls to the OrderReader role.

Does the solution meet the goal?

A. Yes

B. No

Answer: B

Explanation

The VIEW DEFINITION permission lets a user see the metadata of the securable on which the permission is

granted. However, VIEW DEFINITION permission does not confer access to the securable itself.

References:

Question #:3

You have four databases that are accessed by using an Online Transaction Processing (OLTP) application.

The databases are stored on a server named SQL1 that has SQL Server 2014 installed. You plan to deploy an

additional server that has SQL Server 2014 installed. You need to design a high-availability solution for the

databases that meets the following requirements:

If SQL1 fails, the databases must be available.

Users must be able to run reports against a secondary copy of the databases.

What should you include in the design? More than one answer choice may achieve the goal. Select the BEST

answer.

A. AlwaysOn availability groups

B. Database mirroring

C. Log shipping

D. Failover Clustering

Answer: A

Explanation

The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides

an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability

Groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a

failover environment for a discrete set of user databases, known as availability databases, that fail over

together