Question 1

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Options :

A : native support for cross-database queries and transactions

B : built-in high availability

C : system-Initiated automatic backups

D : support for encryption at rest

Answer: A

Question 2

You need to create an Azure Storage account.

Data in the account must replica outside the Azure region automatically.

Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one pint.

Options :

A : read-access geo-redundant storage (RA_GRS)

B : zone-redundant storage (ZRS)

C : geo-redundant storage (GRS)

D :

locally-redundant storage (LRS)Azure Storage offers two options for copying your data to a secondary region:With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access georedundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).

Answer: A,C

Question 3

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Options :

A :

extract transform, and load (ETL)

B :

a data warehouse

C :

online analytical processing (OLAP)

D :

online transaction processing (OLTP)

Answer: D

Question 4

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.

Options :

A : report and dashboard creation

B : report sharing and distribution

C : data modeling

D : data acquisition and preparation

Answer: A,D

Question 5

You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?

Options :

A : Azure Files

B : Azure Blob storage

C : Azure Cosmos DB

D : Azure Table storage

Answer: A

Confidently Practice Online with Free DP-900 Exam Cram

Buying Options: