Microsoft DP-900 Practice Test - Questions Answers, Page 19

Section: Describe core data concepts

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Section: Describe core data concepts

Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.

Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing

Section: Describe how to work with relational data on Azure

Azure SQL Database is relational database and a managed service.

Incorrect Answers:

A, B: Cosmos DB, HDInsight are non-relational databases.

D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing

Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

Section: Describe how to work with relational data on Azure

When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Section: Describe how to work with non-relational data on Azure

With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given region to provide high availability and resiliency to zonal failures.

Note: Azure Cosmos DB provides high availability in two primary ways. First, Azure Cosmos DB replicates data across regions configured within a Cosmos account. Second, Azure Cosmos DB maintains 4 replicas of data within a region.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

Section: Describe how to work with non-relational data on Azure

Multi-master support for Azure Cosmos DB is now available in all public regions.

Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/table-support

Section: Describe how to work with non-relational data on Azure

Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.

A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB's Gremlin API supports the property graph model.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases

Section: Describe an analytics workload on Azure

Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data. Data visualization brings data to help you find key business insights quickly and effectively.

Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization