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 non-relational data

28th January 2021 By John McCormack Leave a Comment

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

Please select 2 correct answers

Correct! Wrong!

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

Correct! Wrong!

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

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

Correct! Wrong!

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

Correct! Wrong!

Which if the following data types use a columnar format?

Please select 2 correct answers

Correct! Wrong!

Which of the following would be described as unstructured data?

Please select 3 correct answers

Correct! Wrong!

JSON is described as semi-structured data

NoSQL databases fall into which general categories?

Please select 4 correct answers

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

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

Correct! Wrong!

Select the TRUE statements regarding column family databases.

Please select 3 correct answers

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

Correct! Wrong!

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

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