DP-900 practice questions – Explore concepts of data analytics

_______ is the process of transforming and mapping raw data into a useful format for analysis?

Ingestion

Deduplication

Wrangling

Visualisation

Correct! Wrong!

Select the TRUE statements regarding data ingestion

Please select 2 correct answers

Data can arrive as a continuous stream or in batches

Data capture and storage are the primary purposes of the ingestions process

Complex calculations should be run at the ingestion stage for optimal performance

Data ingestion provides meaningful insights into the data captured

Correct! Wrong!

SELECT the valid approaches to data processing

Please select 2 correct answers

ETL

LET

ELT

TLE

Correct! Wrong!

https://docs.microsoft.com/en-us/learn/modules/explore-concepts-of-data-analytics/2-describe-data-ingestion-process

Which data processing approach is best suited where the data has privacy concerns?

ETL

LET

ELT

TLE

Correct! Wrong!

Sensitive data can be discarded or masked before loading into a databases.

Which data processing approach is best suited for large volumes of data?

ETL

LET

ELT

TLE

Correct! Wrong!

Which of these options is a cloud-based data integration service?

SSIS

Azure SQL Database

Synapse Analytics

Azure Data Factory

Correct! Wrong!

SSIS is integration software but is not cloud based.

Describe the purpose of reporting.

Creating a graphical representation of data to help understand trends and patterns

Organising data into easily digested informational summaries

Explaining why events happened and what you can do about them

To support better decision making

Correct! Wrong!

Describe the purpose of business intelligence

Creating a graphical representation of data to help understand trends and patterns

Organising data into easily digested informational summaries

Explaining why events happened and what you can do about them

To support better decision making

Correct! Wrong!

Describe the purpose of data visualisation

Creating a graphical representation of data to help understand trends and patterns

Organising data into easily digested informational summaries

Explaining why events happened and what you can do about them

To support better decision making

Correct! Wrong!

Select all valid data visualisation options

Please select 3 correct answers

Bar and column chart

Tabular chart

Line chart

Matrix

JSON

Correct! Wrong!

Select all valid data visualisation options

Please select 4 correct answers

Key influencers

Weekly digest

Treemap

Filled Map

Scatter

Correct! Wrong!

Select all valid data analytics categories

Please select 5 correct answers

Descriptive

Real time

Diagnostic

Databricks

Predictive

Prescriptive

Machine Learning

Cognitive

Inferred

Correct! Wrong!

Which statement is true regarding diagnostic analytics?

Helps answer questions about what has happened

Helps answer questions about why something has happened

Helps answer questions about what will happen in the future

Helps answer questions about what actions need to be taken in order to achieve a goal or target

Helps you learn what might happen if circumstances change

Correct! Wrong!

Which statement is true regarding predictive analytics?

Helps answer questions about what has happened

Helps answer questions about why something has happened

Helps answer questions about what will happen in the future

Helps answer questions about what actions need to be taken in order to achieve a goal or target

Helps you learn what might happen if circumstances change

Correct! Wrong!

Which statement is true regarding descriptive analytics?

Helps answer questions about what has happened

Helps answer questions about why something has happened

Helps answer questions about what will happen in the future

Helps answer questions about what actions need to be taken in order to achieve a goal or target

Helps you learn what might happen if circumstances change

Correct! Wrong!

Which statement is true regarding cognitive analytics?

Helps answer questions about what has happened

Helps answer questions about why something has happened

Helps answer questions about what will happen in the future

Helps answer questions about what actions need to be taken in order to achieve a goal or target

Helps you learn what might happen if circumstances change

Correct! Wrong!

Which statement is true regarding prescriptive analytics?

Helps answer questions about what has happened

Helps answer questions about why something has happened

Helps answer questions about what will happen in the future

Helps answer questions about what actions need to be taken in order to achieve a goal or target

Helps you learn what might happen if circumstances change

Correct! Wrong!

DP-900 practice questions – Explore concepts of data analytics

DP-900 Practice questions - Explore concepts of data analytics

_______ is the process of transforming and mapping raw data into a useful format for analysis?

Select the TRUE statements regarding data ingestion

SELECT the valid approaches to data processing

Which data processing approach is best suited where the data has privacy concerns?

Which data processing approach is best suited for large volumes of data?

Which of these options is a cloud-based data integration service?

Describe the purpose of reporting.

Describe the purpose of business intelligence

Describe the purpose of data visualisation

Select all valid data visualisation options

Select all valid data visualisation options

Select all valid data analytics categories

Which statement is true regarding diagnostic analytics?

Which statement is true regarding predictive analytics?

Which statement is true regarding descriptive analytics?

Which statement is true regarding cognitive analytics?

Which statement is true regarding prescriptive analytics?

About John McCormack

Comments