Month End Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Pass the Microsoft Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with CertsForce

Viewing page 6 out of 10 pages
Viewing questions 51-60 out of questions
Questions # 51:

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

Options:

A.

a scalar function


B.

a table


C.

an index


D.

a view


Expert Solution
Questions # 52:

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

Question # 52


Expert Solution
Questions # 53:

Which storage solution supports role-based access control (RBAC) at the file and folder level?

Options:

A.

Azure Disk Storage


B.

Azure Data Lake Storage


C.

Azure Blob storage


D.

Azure Queue storage


Expert Solution
Questions # 54:

Which three actions are used when performing diagnostic analytics?

Options:

A.

• Identify data anomalies

• Collect anomaly-related data

• Discover relationships and trends that explain anomalies.


B.

• Identify data anomalies

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.


C.

• Apply serf-learning loops to draw inferences from anomalies.

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.


D.

• Identify data anomalies

• Use machine learning to find patterns in large datasets.

• Discover relationships and trends that explain anomalies.


Expert Solution
Questions # 55:

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 # 55


Expert Solution
Questions # 56:

You have data in a tabular format as shown in the following table.

Question # 56

Of which type of data is this an example?

Options:

A.

unstructured data


B.

semi-structured data


C.

document


D.

structured data


Expert Solution
Questions # 57:

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 # 57


Expert Solution
Questions # 58:

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a

complete solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

a report page


B.

a Microsoft PowerPoint slide


C.

a visualization from a report


D.

a dataflow


E.

a text box


Expert Solution
Questions # 59:

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

Options:

A.

MERGE


B.

ALTER


C.

INSERT


D.

UPDATE


Expert Solution
Questions # 60:

You have the following JSON document.

Question # 60

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.

NOTE: Each correct selection is worth one point.

Question # 60


Expert Solution
Viewing page 6 out of 10 pages
Viewing questions 51-60 out of questions