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 111
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 112
- Exam Question
- Correct Answer
- DP-900 Question 113
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 114
- Exam Question
- Correct Answer
- DP-900 Question 115
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 116
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 117
- Exam Question
- Correct Answer
- DP-900 Question 118
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 119
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 120
- Exam Question
- Correct Answer
- Explanation
- Reference
DP-900 Question 111
Exam Question
To complete the sentence, select the appropriate option in the answer area.
__________ physically sorts the data in a table based on the values in a specified column.
Answer Area:
A. A view
B. A clustered index
C. A stored procedure
D. A nonclustered index
Correct Answer
B. A clustered index
Reference
Microsoft Learn > SQL > SQL Server > Clustered and nonclustered indexes described
DP-900 Question 112
Exam Question
To complete the sentence, select the appropriate option in the answer area.
Relational data is stored in __________.
Answer Area:
A. a file system as unstructured data.
B. a hierarchal folder structure.
C. a tabular form of rows and columns.
D. comma-separated value (CSV) files.
Correct Answer
C. a tabular form of rows and columns.
DP-900 Question 113
Exam Question
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
A. Azure Table storage
B. Azure Data Lake Storage
C. Azure Queue storage
D. Azure Files
Correct Answer
B. Azure Data Lake Storage
Reference
Microsoft Learn > Azure > Storage > Blobs > Access control lists (ACLs) in Azure Data Lake Storage Gen2
DP-900 Question 114
Exam Question
To complete the sentence, select the appropriate option in the answer area.
__________ natively supports the analysis of relationships between entities.
Answer Area:
A. Column family databases
B. Document databases
C. Graph databases
D. Key-value stores
Correct Answer
A. Column family databases
DP-900 Question 115
Exam Question
To answer, select the appropriate options in the answer area.
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options?
PostgreSQL on Azure VMs: __________
Answer Area:
- Infrastructure as a service (IaaS)
- Platform as a service (PaaS)
- Software as a service (SaaS)
Azure Database for PostgreSQL: __________
Answer Area:
- Infrastructure as a service (IaaS)
- Platform as a service (PaaS)
- Software as a service (SaaS)
Correct Answer
PostgreSQL on Azure VMs: Software as a service (SaaS)
Azure Database for PostgreSQL: Platform as a service (PaaS)
Reference
DP-900 Question 116
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems.
Statement 2: Extract, load, and transform (ELT) transform data by using a compute resource independent of the source system and destination system.
Statement 3: Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.
Correct Answer
Statement 1: Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems: No
Statement 2: Extract, load, and transform (ELT) transform data by using a compute resource independent of the source system and destination system: Yes
Statement 3: Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems: No
Reference
Microsoft Learn > Azure > Architecture > Data Architecture Guide> Extract, transform, and load (ETL)
DP-900 Question 117
Exam Question
You need to modify a view in a relational database by adding a new column.
Which statement should you use?
A. MERGE
B. ALTER
C. INSERT
D. UPDATE
Correct Answer
B. ALTER
DP-900 Question 118
Exam Question
To complete the sentence, select the appropriate option in the answer area.
The Azure Cosmos DB ___________ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB.
Answer Area:
A. Core (SQL)
B. Gremlin
C. MongoDB
D. Table
Correct Answer
A. Core (SQL)
Explanation
Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL) syntax.
Reference
Microsoft Learn > Azure > Azure Cosmos DB > Choose an API in Azure Cosmos DB
DP-900 Question 119
Exam Question
You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
A. az storage share create
B. az storage account create
C. az cosmosdb create
D. az storage container create
Correct Answer
D. az storage container create
Reference
Microsoft Learn > Azure > Azure CLI > Reference > Azure Storage > storage > az storage container
DP-900 Question 120
Exam Question
To complete the sentence, select the appropriate option in the answer area.
An extract, load, and transform (ELT) process requires __________.
Answer Area:
A. a separate transformation engine.
B. a target data store powerful enough to transform data.
C. data that is fully processed before being loaded to the target data store.
D. a data pipeline that includes a transformation engine.
Correct Answer
B. a target data store powerful enough to transform data.
Explanation
With ELT, the data store used to perform the transformation is the same data store where the data is ultimately consumed.
Reference
Microsoft Learn > Azure > Architecture > Data Architecture Guide > Extract, transform, and load (ETL)