Microsoft Certification Azure Data Fundamentals (DP-900) 3

Question 1

What does ETL stand for in data processing pipelines?

Accepted Answer

Extract, Transform, Load

Answer

ETL stands for Extract, Transform, Load — the three-step process of extracting data from source systems, transforming it into the desired format, and loading it into a destination.

Question 2

Which type of analytics answers the question 'What happened in the past?'

Accepted Answer

Descriptive analytics

Answer

Descriptive analytics analyzes historical data to describe past events and trends, forming the foundation for other types of analytics.

Question 3

What is the primary purpose of Microsoft Power BI?

Accepted Answer

Creating and sharing interactive data visualizations and business reports

Answer

Power BI is a business analytics tool that enables users to visualize data, create interactive reports, and share insights across an organization.

Question 4

Which type of NoSQL database is best suited for storing and querying highly connected data with complex relationships?

Accepted Answer

Graph database

Answer

Graph databases store data as nodes and edges, making them ideal for representing and traversing complex relationships between entities such as social networks.

Question 5

What does the term 'data lake' refer to in modern data architecture?

Accepted Answer

A centralized repository that stores raw data in its native format at any scale

Answer

A data lake is a centralized storage repository that holds raw data in its native format until it is needed, supporting structured, semi-structured, and unstructured data.

Microsoft Certification Practice Test

Microsoft Certification Practice Test

Microsoft Certification Azure Data Fundamentals (DP-900) 3