The latest Microsoft DP-900 Azure Data Fundamentals certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft DP-900 Azure Data Fundamentals exam and earn Microsoft DP-900 Azure Data Fundamentals certification.
Table of Contents
- DP-900 Question 131
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 132
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 133
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 134
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 135
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 136
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 137
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 138
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 139
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 140
- Exam Question
- Correct Answer
- Explanation
DP-900 Question 131
Exam Question
To complete the sentence, select the appropriate option in the answer area.
A key/value data store is optimized for __________.
Answer Area:
A. enforcing constraints
B. simple lookups
C. table joins
D. transactions
Correct Answer
B. simple lookups
Explanation
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference
Microsoft Learn > Azure > Architecture > Application Architecture Guide > Understand data store models
DP-900 Question 132
Exam Question
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?
A. an index
B. a view
C. a scalar function
D. a table
Correct Answer
B. a view
Explanation
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
Microsoft Learn > SQL > SQL Server > Views
DP-900 Question 133
Exam Question
Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT
Correct Answer
C. INSERT
Explanation
Data Manipulation Language (DML) statements:
- DELETE
- INSERT
- UPDATE
Reference
Microsoft Learn > Azure > Synapse Analytics > T-SQL statements supported for dedicated SQL pool in Azure Synapse Analytics
DP-900 Question 134
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offerings.
Statement 2: Platform as a service (PaaS) database offerings in Azure provide end users with the ability to control and update the operating system version.
Statement 3: All relation and non-relational platform as a service (PaaS) database offerings in Azure can be paused to reduce costs.
Correct Answer
Statement 1: Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offerings: Yes
Statement 2: Platform as a service (PaaS) database offerings in Azure provide end users with the ability to control and update the operating system version: No
Statement 3: All relation and non-relational platform as a service (PaaS) database offerings in Azure can be paused to reduce costs: No
Explanation
Statement 1: Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offerings: Yes
Like IaaS, PaaS includes infrastructure — servers, storage, and networking — but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources
Statement 2: Platform as a service (PaaS) database offerings in Azure provide end users with the ability to control and update the operating system version: No
You manage the applications and services you develop, and the cloud service provider typically manages everything else.
Statement 3: All relation and non-relational platform as a service (PaaS) database offerings in Azure can be paused to reduce costs: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft’s official answer “Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB.”
Reference
DP-900 Question 135
Exam Question
You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account?
A. zone-redundant storage (ZRS)
B. read-access geo-redundant storage (RA-GRS)
C. locally-redundant storage (LRS)
D. geo-redundant storage (GRS)
Correct Answer
B. read-access geo-redundant storage (RA-GRS)
D. geo-redundant storage (GRS)
Explanation
D: Azure Storage offers two options for copying your data to a secondary region:
- Geo-redundant storage (GRS)
- Geo-zone-redundant storage (GZRS)
B: With GRS or GZRS, the data in the secondary region isn’t available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Reference
Microsoft Learn > Azure > Storage > Azure Storage redundancy
DP-900 Question 136
Exam Question
Match the types of visualizations to the appropriate descriptions. Each visualization type may be used once, more than once, or not at all.
Visualizations:
- Key Influencer
- Scatter
- Treemap
Descriptions:
- A chart of colored, nested rectangles that displays individual data points represented by the size and color of a relative rectangle.
- A chart that displays the major contributors of a selected result or value.
- A chart that shows the relationship between two numerical values.
Correct Answer
Treemap: A chart of colored, nested rectangles that displays individual data points represented by the size and color of a relative rectangle.
Key Influencer: A chart that displays the major contributors of a selected result or value.
Scatter: A chart that shows the relationship between two numerical values.
Explanation
Treemap: A chart of colored, nested rectangles that displays individual data points represented by the size and color of a relative rectangle.
Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.
Key Influencer: A chart that displays the major contributors of a selected result or value.
A key influencer chart displays the major contributors to a selected result or value.
Scatter: A chart that shows the relationship between two numerical values.
Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures — whether or not, in which order, etc.
DP-900 Question 137
Exam Question
To complete the sentence, select the appropriate option in the answer area.
A visualization that shows a university’s current student enrollment versus the maximum capacity is an example of __________ analytics.
Answer Area:
A. cognitive
B. descriptive
C. predictive
D. prescriptive
Correct Answer
B. descriptive
Explanation
Generally speaking, data analytics comes in four types (Figure 1):
- Descriptive, to answer the question: What s happening?
- Diagnostic, to answer the question: Why s happening?
- Predictive, to answer the question: What will happen?
- Prescriptive, to answer the question: What actions should we take?
Reference
Describe, diagnose, and predict with IoT Analytics
DP-900 Question 138
Exam Question
To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all.
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process?
Locations:
- An in-memory data integration tool
- The CRM system
- The data warehouse
Stages:
- Extract:
- Load:
- Transform:
Correct Answer
Extract: The CRM system
Load: The data warehouse
Transform: An in-memory data integration tool
Explanation
Extract: The CRM system
Data is extracted from the CRM system.
Load: The data warehouse
Data is loaded to the data warehouse.
Transform: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
Reference
Microsoft Learn > Azure > Architecture > Data Architecture Guide > Extract, transform, and load (ETL)
DP-900 Question 139
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: Batch processing can output data to a file store.
Statement 2: Batch processing can output data to a relational database.
Statement 3: Batch processing can output data to a NoSQL database.
Correct Answer
Statement 1: Batch processing can output data to a file store: Yes
Statement 2: Batch processing can output data to a relational database: No
Statement 3: Batch processing can output data to a NoSQL database: No
Explanation
Statement 1: Batch processing can output data to a file store: Yes
Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the data for analysis. Usually these jobs involve reading source files from scalable storage (like HDFS, Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files in scalable storage.
Statement 2: Batch processing can output data to a relational database: No
Statement 3: Batch processing can output data to a NoSQL database: No
Reference
Microsoft Learn > Azure > Architecture > Data Architecture Guide > Batch processing
DP-900 Question 140
Exam Question
To complete the sentence, select the appropriate option in the answer area.
A relational database is appropriate for scenarios that involve a high volume of __________.
Answer Area:
A. changes to relationships between entities
B. geographically distributed writes
C. transactional writes
D. writes that have varying data structures
Correct Answer
C. transactional writes
Explanation
Disadvantages of non-relational databases include: Data Consistency — non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
Incorrect Answers:
Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.
Use Cloud storage (no relational database) for geographically distributed writes.