DP-900 Exam QUESTIONS with Correct
Verified Solutions
Which storage solution allows you to aggregate data stored in JSON files for use in
analytical reports without additional development effort?
Azure cosmos, DB
Which two keys are needed to create a one to many relationship between two tables in a
relational database?
A primary key and a foreign key
What are two advantages of using normalization over not using normalization in a
relational database?
Uses less storage space and optimizes for updates
(blank) is a process to reduce duplicate data in a database and ensure data integrity
Normalization
What should you create to improve the performance of a query accessing a table that
contains millions of rows?
An index
Do you have a complex query that select data from multiple tables. Which three database
objects should allow you to use the query definition?
A view, a function, a stored procedure
,Which three statements accurately describe the properties of a table in a relational
database?
A) each row, and a table has the same number of columns
B) a table can have a primary key build on multiple columns
C) a table can have only one foreign key
D) all columns must contain values
E) each column must have a data type
A, B, E
Which three open-source databases are available as a platform as a service (PaaS) in
Azure?
A) MariaDB
B) MySQL
C) PostgreSQL
D) CockroachDB
E) CouchDB
A, B, C
Which data service allows you to create a single database that can scale up and down
without downtime?
Azure SQL database
Which data service allows you to migrate an entire Microsoft SQL server to the cloud,
without requiring that you manage the infrastructure after the migration?
, Azure SQL managed instance
Which open source database is a hybrid, relational object database?
PostgreSQL
Which open source database has built-in support for temporal data?
MariaDB
Which SQL engine is optimized for IOT scenarios?
Azure SQL edge
What should you use to create an run data ingestion pipelines?
Azure data factory
Which native azure service can you use to process data by running Apache spark jobs?
Azure synapse analytics
Which data integration service allows you to orchestrate data flow without coding?
Azure data factory
What is a characteristic of stream processing?
Latency is measured in seconds or milliseconds
What is a characteristic of batch processing?
Batch processing is used to perform complex analysis
Which two services can be used as a source for stream processing?
A) Azure event hubs.
Verified Solutions
Which storage solution allows you to aggregate data stored in JSON files for use in
analytical reports without additional development effort?
Azure cosmos, DB
Which two keys are needed to create a one to many relationship between two tables in a
relational database?
A primary key and a foreign key
What are two advantages of using normalization over not using normalization in a
relational database?
Uses less storage space and optimizes for updates
(blank) is a process to reduce duplicate data in a database and ensure data integrity
Normalization
What should you create to improve the performance of a query accessing a table that
contains millions of rows?
An index
Do you have a complex query that select data from multiple tables. Which three database
objects should allow you to use the query definition?
A view, a function, a stored procedure
,Which three statements accurately describe the properties of a table in a relational
database?
A) each row, and a table has the same number of columns
B) a table can have a primary key build on multiple columns
C) a table can have only one foreign key
D) all columns must contain values
E) each column must have a data type
A, B, E
Which three open-source databases are available as a platform as a service (PaaS) in
Azure?
A) MariaDB
B) MySQL
C) PostgreSQL
D) CockroachDB
E) CouchDB
A, B, C
Which data service allows you to create a single database that can scale up and down
without downtime?
Azure SQL database
Which data service allows you to migrate an entire Microsoft SQL server to the cloud,
without requiring that you manage the infrastructure after the migration?
, Azure SQL managed instance
Which open source database is a hybrid, relational object database?
PostgreSQL
Which open source database has built-in support for temporal data?
MariaDB
Which SQL engine is optimized for IOT scenarios?
Azure SQL edge
What should you use to create an run data ingestion pipelines?
Azure data factory
Which native azure service can you use to process data by running Apache spark jobs?
Azure synapse analytics
Which data integration service allows you to orchestrate data flow without coding?
Azure data factory
What is a characteristic of stream processing?
Latency is measured in seconds or milliseconds
What is a characteristic of batch processing?
Batch processing is used to perform complex analysis
Which two services can be used as a source for stream processing?
A) Azure event hubs.
