DP-900 practice questions – Explore concepts of non-relational data

Which of these data types would be most suitable for non-relational database?

Please select 2 correct answers

Log data

Data which follows a set structure

Data with a flexible structure

Sales and order data for an e-commerce store

Correct! Wrong!

Each entity in a non-relational database should have a unique ______

Foreign Key

Composite Key

Key Value

JSON beautifier

Correct! Wrong!

Which Azure based non-relational DBMS supports indexing, even when the structure of the indexed data varies from record to record?

PostGreSQL

Azure Database for PostgreSQL

Azure Database for Snowflake

Azure Cosmos DB

Correct! Wrong!

https://docs.microsoft.com/en-us/azure/cosmos-db/index-overview

Select the suitable use cases for non-relational databases

Please select 3 correct answers

IoT and Telematics

Gaming

Online Banking

Web and mobile applications

Correct! Wrong!

Which option is best when data needs to be ingested quickly?

Non-Relational database

Relational database

Correct! Wrong!

Which if the following data types use a columnar format?

Please select 2 correct answers

JSON

Avro

ORC

Parquet

Correct! Wrong!

Which of the following would be described as unstructured data?

Please select 3 correct answers

Audio files

GIFs

JSON

Video files

Correct! Wrong!

JSON is described as semi-structured data

NoSQL databases fall into which general categories?

Please select 4 correct answers

Key-Value stores

Document databases

MySQL databases

Column family databases

Parquet

Graph databases

Correct! Wrong!

MySQL is a relational database. Parquet is a compressed columnar data format.

Select the technology choices suitable for a key-value store in Azure?

Please select 2 correct answers

Azure table storage

Azure Cosmos DB

Blob Storage

Azure SQL Managed Instance

RDS Aurora

Correct! Wrong!

Blob storage is not suitable for key-values. Managed Instance is a SQL relational database service. RDS Aurora is in AWS, and is also a relational dbms.

Select the TRUE statements regarding document store databases.

Please select 3 correct answers

Each document has a unique ID

The fields in the documents are opaque to the database management system

The fields in the documents are transparent to the database management system

Data is often stored as JSON, but could be in other formats such as XML, YAML and BSON

Typically, a document contains part of the data for an entity

Correct! Wrong!

Select the TRUE statements regarding column family databases.

Please select 3 correct answers

Rows and columns are used to organise data

Logically related columns such as name and address are stored together in column families

Azure database for Cassandra is a widely used column family database

Azure Cosmos DB uses the Cassandra API to support column family data

Correct! Wrong!

Although Cassandra is a column family database, Azure database for Cassandra is not a valid service in Azure.

Select the TRUE statements regarding graph databases

Please select 4 correct answers

Graph databases are designed to visualize complex logarithmic data (log scale graphs)

Graph databases focus on relationships between entities

Azure Cosmos DB uses the Gremlin API to support graph databases

Graph databases are queried using T-SQL

Nodes are instances of entities

Edges are relationships between nodes

Correct! Wrong!

DP-900 practice questions – Explore concepts of non-relational data

DP-900 practice questions - Explore concepts of non-relational data

Which of these data types would be most suitable for non-relational database?

Each entity in a non-relational database should have a unique ______

Which Azure based non-relational DBMS supports indexing, even when the structure of the indexed data varies from record to record?

Select the suitable use cases for non-relational databases

Which option is best when data needs to be ingested quickly?

Which if the following data types use a columnar format?

Which of the following would be described as unstructured data?

NoSQL databases fall into which general categories?

Select the technology choices suitable for a key-value store in Azure?

Select the TRUE statements regarding document store databases.

Select the TRUE statements regarding column family databases.

Select the TRUE statements regarding graph databases

About John McCormack