Halloween Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 8 / 10
Total 313 questions

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.

The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.

What should the developers use ?

A.

Azure Data Studio

B.

sq1cmd

C.

Microsoft SQL Server Management Studio (SSMS)

D.

Azure Data Explorer

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

A.

You must be assigned the Reader role for the resource group that contains the database.

B.

You must have SELECT access to the Products table.

C.

You must have a user in the database.

D.

You must be assigned the Contributor role for the resource group that contains the database.

E.

Your IP address must be allowed to connect to the database.

Select the answer that correctly completes the sentence.

To complete the sentence, select the appropriate option in the answer area.

To complete the sentence, select the appropriate option in the answer area.

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

NOTE: Each correct selection is worth one point.

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A.

complete control over backup and restore processes

B.

access to the latest features

C.

in-database machine learning services

D.

reduced administrative effort for managing the server infrastructure

To complete the sentence, select the appropriate option in the answer area.

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

A.

an Azure SQL Database elastic pool

B.

Azure SQL Managed Instance

C.

Azure Database for MySQL

D.

Azure SQL Database

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

A.

Azure Time Series Insights

B.

Azure HDInsight

C.

Azure Databricks

D.

Azure Log Analytics