What does data integration involve?

Creating a backup of a database

Deleting duplicate records from a single table

Combining data from multiple sources into a unified view

A data analyst has created a report showing that sales in the eastern region have declined for three consecutive months. What should the analyst do to generate a business insight?

Investigate possible causes, such as competitor activity or supply chain issues, and present findings with recommended actions to management.

Store the report in a data lake for future analysis.

Ask the data engineer to collect more data from other regions.

Publish the report to the company's Power BI workspace so others can see the decline.

Which of the following is an example of data transformation?

Granting a user access to a database

Copying a file from one folder to another

Backing up a database to a different server

Converting date formats from MM/DD/YYYY to YYYY-MM-DD

Which of the following is a data storage solution that a data engineer might implement?

A web server for hosting a website

A data lake for storing raw data in its native format

A customer relationship management (CRM) system

A firewall for network security

Microsoft Certified:Azure Data Fundamentals

Domain 1Objective 4

Identify Roles and Responsibilities for Data Workloads DP-900 Practice Questions (Page 3)

Part of the Describe core data concepts domain, which accounts for 25–30% of the DP-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~5–9 in this domain), expect 1–2 from this objective — we provide 52 practice questions to prepare you well beyond it. (estimate)

52questions here

11free pages

10concepts

25–30%of the exam

Questions 11–15

11foundation · easy
What does data integration involve?
Select an answer first
12application · medium
A data analyst has created a report showing that sales in the eastern region have declined for three consecutive months. What should the analyst do to generate a business insight?
Select an answer first
13application · medium
A data analyst is analyzing customer churn data. The analyst wants to identify which customer attributes (e.g., age, usage frequency, support tickets) are most strongly associated with churn. Which data analysis technique should the analyst use?
Select an answer first
14foundation · easy
Which of the following is an example of data transformation?
Select an answer first
15foundation · easy
Which of the following is a data storage solution that a data engineer might implement?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-900

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-900” is a trademark of its owner, used for identification only.