DP-900 practice questions – Describe the concepts of relational data

In a relational database, entities are modelled as:

Columns

Tables

Views

Primary Keys

Correct! Wrong!

True or false? Rows in a table can have a flexible number of columns.

True

False

Correct! Wrong!

Although nullable columns can be empty, each row has a fixed number of columns.

True or false? Primary keys uniquely identify each row in a table.

True

False

Primary key values must be unique on each row but can be made up of multiple columns. (These are known as composite primary keys).

Show hint

Correct! Wrong!

For each value in a foreign key column, there must be a row with the same value in the corresponding ______ column in the related table.

Foreign Key

3rd normal form

Primary Key

Identity

Correct! Wrong!

Select the use cases for which a relational database is the most suitable option.

Please select 2 correct answers

E-Commerce (Online shopping)

Social networks

Online banking

Digital media collections

Correct! Wrong!

E-commerce and banking are suitable for relational databases. Graph databases are suitable for social networks and blob storage is suitable for digital media collections.

Please select a benefit of indexes on relational tables.

Helps you search efficiently for data

Reduces storage space

Speeds up insert, update, and delete operations

Indexes are virtual tables

Correct! Wrong!

Which phrase best describes a view?

8kb of data

A virtual table based on the results of a query

A data compression technique

A subset of a data table

Correct! Wrong!

Can views can be joined to SQL tables and other views.

Tables only

Views only

Tables and views

Can't join to either

Correct! Wrong!

If you need full control of your SQL Server in the Azure cloud, which option should you choose?

Azure SQL Database (PaaS)

SQL Managed Instance (PaaS)

SQL Server on VMs (IAAS)

Elastic Cloud Compute VMs (EC2)

Correct! Wrong!

Although EC2 would give you full control of your SQL Server, this is a service from AWS, not Azure. Any PaaS solutions have limited features so don't allow full control.

Select all the benefits of using a PaaS solution for your relational database.

Please select 3 correct answers

Automatic backups

Automatic patching

Install and managed database software yourself

Quick and easy scaling

Correct! Wrong!

Besides Azure SQL database, which other popular DBMSs have a PaaS solution in Azure?

Please select 3 correct answers

Azure Database for PostgreSQL

Azure Database for Oracle

Azure Database for MySQL

Azure Database for MariaDB

Azure Database for Snowflake

Azure Database for Access

Correct! Wrong!

DP-900 practice questions – Describe the concepts of relational data

In a relational database, entities are modelled as:

True or false? Rows in a table can have a flexible number of columns.

True or false? Primary keys uniquely identify each row in a table.

For each value in a foreign key column, there must be a row with the same value in the corresponding ______ column in the related table.

Select the use cases for which a relational database is the most suitable option.

Please select a benefit of indexes on relational tables.

Which phrase best describes a view?

Can views can be joined to SQL tables and other views.

If you need full control of your SQL Server in the Azure cloud, which option should you choose?

Select all the benefits of using a PaaS solution for your relational database.

Besides Azure SQL database, which other popular DBMSs have a PaaS solution in Azure?

Related

About John McCormack

Leave a ReplyCancel reply