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

Execute, Transfer, Link

Answer

Export, Translate, Log

Answer

Extract, Transfer, Launch

Question 2

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

Accepted Answer

Descriptive analytics

Answer

Predictive analytics

Answer

Prescriptive analytics

Answer

Cognitive analytics

Question 3

What is the primary purpose of Microsoft Power BI?

Accepted Answer

Creating and sharing interactive data visualizations and business reports

Answer

Managing cloud infrastructure resources and virtual machines

Answer

Developing and deploying machine learning models

Answer

Storing and querying large relational datasets

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

Document database

Answer

Key-value database

Answer

Column-family database

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 structured relational database optimized for reporting

Answer

A real-time data streaming and processing service

Answer

A data visualization and dashboard tool

Question 6

Which type of analytics uses statistical algorithms and machine learning to forecast future outcomes?

Accepted Answer

Predictive analytics

Answer

Descriptive analytics

Answer

Diagnostic analytics

Answer

Prescriptive analytics

Question 7

What is the role of Azure Cognitive Services in data and AI solutions?

Accepted Answer

Providing pre-built AI capabilities like vision, speech, and language processing via APIs

Answer

Managing data storage costs and lifecycle policies

Answer

Optimizing SQL query execution plans

Answer

Replicating data across Azure regions for high availability