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 core data concepts

26th January 2021 By John McCormack Leave a Comment

Structured data is typically represented in which format?

Correct! Wrong!

Structured data is typically represented in a database table, with columns for field for each record. e.g. Name, DOB, CustomerID. Each record is a row within the table.

What is a good storage option for semi-structured data?

Correct! Wrong!

As it has some structure, but fields can vary, JSON is good option for semi-structured data.

Which option would be a good use for graph databases?

Correct! Wrong!

Which option is best suited to storing multimedia data such as videos?

Correct! Wrong!

Select a benefit of normalizing data.

Correct! Wrong!

Select all valid tasks for an Analytical Data Processing System?

Please select 3 correct answers

Correct! Wrong!

Data ingestion, transformation and visualisation are all valid steps. So too is data querying which is not listed.

DP-900 practice questions - Explore core data concepts
Your Score

Share your Results:

Related

About John McCormack

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

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