[Aug-2023] The Best Microsoft Certified: Azure Data Fundamentals DP-900 Professional Exam Questions [Q134-Q154]

QUESTION 134
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.

QUESTION 135
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

QUESTION 136
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

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

QUESTION 138
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?

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

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

QUESTION 141
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

QUESTION 142
match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

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

QUESTION 144
You have the following SQL query.

NOTE: Each correct selection is worth one point.

QUESTION 145
Which type of database is Azure Database for PostgreSQL?

QUESTION 146
Select the answer that correctly completes the sentence.

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

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

QUESTION 149
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

QUESTION 150
Your company plans to load data from a customer relationship management (CRM) system to a data
warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate
locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to
drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

QUESTION 151
Which storage solution supports access control lists (ACLs) at the file and folder level?

QUESTION 152
You have structured data in tabular format.
What represents an individual instance of a data entity?

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

QUESTION 154
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.