Microsoft - DP-900: Microsoft Azure Data Fundamentals
Sample Questions
Question: 205
Measured Skill: Identify considerations for relational data on Azure (20–25%)
Select the answer that correctly completes the sentence.
| A | Microsoft SQL Server database tables store non-relational. |
| B | Microsoft SQL Server database tables store relational data. |
| C | Microsoft SQL Server database tables store semi-structured data. |
Correct answer: BExplanation:
Microsoft SQL Server is a relational database management system (RDBMS). Applications and tools connect to a SQL Server instance or database, and communicate using Transact-SQL (T-SQL).
A database in SQL Server is made up of a collection of tables that stores a specific set of structured data. A table contains a collection of rows, also referred to as records or tuples, and columns, also referred to as attributes. Each column in the table is designed to store a certain type of information, for example, dates, names, dollar amounts, and numbers.
References:
What is SQL Server?
Databases
Question: 206
Measured Skill: Identify considerations for relational data on Azure (20–25%)
Select the answer that correctly completes the sentence.
| A | An Azure SQL server enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power. |
| B | An elastic pool enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power. |
| C | The Data Migration Assistant (DMA) enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power. |
| D | A virtual network enables multiple Azure SQL databases to share resources such as memory, data storage space, and processing power. |
Correct answer: BExplanation:
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases with varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in SQL Database enable software-as-a-service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.
Reference: Elastic pools help you manage and scale multiple databases in Azure SQL Database
Question: 207
Measured Skill: Describe an analytics workload on Azure (25–30%)
What is required to provision Azure Data Lake Storage in an Azure Storage account?| A | Versioning must be enabled. |
| B | Hierarchical namespace must be enabled. |
| C | Hierarchical namespace must be disabled. |
| D | Versioning must be disabled. |
Correct answer: BExplanation:
A key mechanism that allows Azure Data Lake Storage to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.
Reference: Azure Data Lake Storage hierarchical namespace
Question: 208
Measured Skill: Describe considerations for working with non-relational data on Azure (15–20%)
What is a characteristic of a non-relational database?| A | Full support for Transact-SQL |
| B | Fixed schema |
| C | Self-describing entities |
Correct answer: CExplanation:
Nonrelational databases, also called NoSQL databases, optimize for flexible schemas, horizontal scale, and specific access or aggregation patterns. They typically relax some aspects of relational behavior, such as schema rigidity and transaction scope, for scalability or agility.
One of the characteristics of non-relational data is that it often consists of self-describing entities. Unlike in a relational database where the schema is predefined and structured, non-relational data allows for more flexibility in the structure and schema. Each entity can have its own set of properties and attributes, and the data itself carries information about its structure and meaning. This self-descriptive nature of non-relational data allows for dynamic and adaptable data models.
Reference: Understand data models
Question: 209
Measured Skill: Describe core data concepts (25–30%)
Select the answer that correctly completes the sentence.
| A | Varying fields for each entity in a JSON document is an example of relational data. |
| B | Varying fields for each entity in a JSON document is an example of semi-structured data. |
| C | Varying fields for each entity in a JSON document is an example of structured data. |
| D | Varying fields for each entity in a JSON document is an example of unstructured data. |
Correct answer: BExplanation:
Semi-structured data is data that does not follow a rigid, predefined table schema like relational databases, but does include tags, keys, or metadata that give it structure and make it easy to interpret.
JSON (JavaScript Object Notation) is one of the most commonly used semi-structured data formats. It is lightweight, human-readable, and widely used for data interchange between applications, particularly in web and mobile development.
References:
Understand data models
JSON data in SQL Server