Ticking Clock Black Friday Special: 75% Off! Apply coupon code below to save on all exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: estly75

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

question 61

Select the answer that correctly completes the sentence.

question 62

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,

backups, and maintenance tasks?

A.

Azure SQL Managed Instance

B.

SQL Server on Azure Virtual Machines

C.

Azure SQL Edge

D.

Azure SQL Database

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

A.

bridge

B.

dimension

C.

fact

You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

A.

You need to generate reports without affecting the transactional workload.

B.

You need to audit the transactional application.

C.

You need to implement high availability in the event of a regional outage

D.

You need to improve the recovery point objective (RPO).

Select the answer that correctly completes the sentence.

question 66

What is a primary characteristic of a relational database?

A.

data is queried and manipulated by using a variant of the SQL language

B.

a flexible data structure

C.

a lack of dependencies between tables

D.

a large amount of duplicate data

Match the database normalization terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

question 68

For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

question 69

Select the answer that correctly completes the sentence.

question 70