John McCormack DBA

SQL Server Databases and Cloud

  • Personal
    • About
  • Free Training
    • SQL Server on Amazon RDS (Free Course)
    • Free practice questions to help you pass DP-900
  • Save money in Azure
    • Azure IaaS SQL Backups – Stop burning money
    • Your Azure SQL Database and Managed Instance is too big
    • Turn the cloud off at bedtime to save 70%
    • Your Azure SQL Virtual Machine might be too big
    • Save money with Azure SQL DB serverless
    • Save up to 73% with reserved instances
    • Delete unused instances to save money in Azure
  • Hire me
    • 60 minute cost optimization
    • Let me solve your SQL Server problems
    • Take a look at my Sessionize speaker’s profile

DP-900 practice questions – Explore concepts of data analytics

29th January 2021 By John McCormack 1 Comment

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

Correct! Wrong!

Select the TRUE statements regarding data ingestion

Please select 2 correct answers

Correct! Wrong!

SELECT the valid approaches to data processing

Please select 2 correct answers

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?

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?

Correct! Wrong!

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

Correct! Wrong!

SSIS is integration software but is not cloud based.

Describe the purpose of reporting.

Correct! Wrong!

Describe the purpose of business intelligence

Correct! Wrong!

Describe the purpose of data visualisation

Correct! Wrong!

Select all valid data visualisation options

Please select 3 correct answers

Correct! Wrong!

Select all valid data visualisation options

Please select 4 correct answers

Correct! Wrong!

Select all valid data analytics categories

Please select 5 correct answers

Correct! Wrong!

Which statement is true regarding diagnostic analytics?

Correct! Wrong!

Which statement is true regarding predictive analytics?

Correct! Wrong!

Which statement is true regarding descriptive analytics?

Correct! Wrong!

Which statement is true regarding cognitive analytics?

Correct! Wrong!

Which statement is true regarding prescriptive analytics?

Correct! Wrong!

DP-900 practice questions – Explore concepts of data analytics
DP-900 Practice questions - Explore concepts of data analytics

Related

About John McCormack

John McCormack is an experienced SQL DBA with extensive knowledge of the two largest public clouds: AWS and Azure.

Comments

  1. Sujithkumar C says

    2nd April 2022 at 3:11 pm

    Well thought through , good sample questions Thanks John

    Reply

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

John McCormack · Copyright © 2025