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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 5 / 10
Total 332 questions

Select the answer that correctly completes the sentence.

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

Note: Each correct selection is worth one point.

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

NOTE: Each correct selection is worth one point.

You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer.

Which two Transact-SQL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A.

JOIN

B.

ORDERBY

C.

INDEX

D.

SELECT

E.

EXISTS

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.

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

What can be used with native notebook support to query and visualize data by using a web-based interface?

A.

Azure Databricks

B.

pgAdmin

C.

Microsoft Power Bl

Select the answer that correctly completes the sentence.

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