DP-900 practice questions - Explore core data concepts - John McCormack Engineering Manager

Structured data is typically represented in which format?

Rows and columns of a database table

Azure Blob Storage

JSON

Customer records

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?

Rows and columns of a database table

Azure Blob Storage

JSON

Customer records

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?

Online Transactional Processing (OLTP)

Stocks and shares database

Data visualisation

Information about complex relationships

Correct! Wrong!

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

Azure SQL DB

Azure Synapse Analytics

Azure blob storage

Cosmos DB

Correct! Wrong!

Select a benefit of normalizing data.

The need to write complex queries makes SQL salaries higher than average for IT jobs

Fast throughput for transactions

Tables need to be joined to make sense

It is ideal for storing documents

Correct! Wrong!

Select all valid tasks for an Analytical Data Processing System?

Please select 3 correct answers

Data Ingestion

Data Destruction

Data Transformation

Data Assembly

Data Visualisation

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

Structured data is typically represented in which format?

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

Which option would be a good use for graph databases?

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

Select a benefit of normalizing data.

Select all valid tasks for an Analytical Data Processing System?

About John McCormack