microsoft dp-900 practice test

microsoft azure data fundamentals

Last exam update: Sep 01 ,2024
Page 1 out of 27. Viewing questions 1-10 out of 279

Question 1

DRAG DROP 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? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Answer:


Box 1: The CRM system -
Data is extracted from the CRM system.

Box 2: The data warehouse -
Data is loaded to the data warehouse.
Box 3: A standalone data analysis 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:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Discussions
0 / 1000

Question 2

Structured data where each row represents a single data entity uses which type of schema?

  • A. XML
  • B. tabular
  • C. blob
  • D. JSON
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%

None

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

Which type of Azure resource supports the serverless configuration of an Azure SQL database?

  • A. SQL Server on Azure Virtual Machines
  • B. an Azure SQL Database elastic pool
  • C. a single database in Azure SQL Database
  • D. Azure SQL Managed Instance
Answer:

c

User Votes:
A
50%
B
50%
C
50%
D
50%

None

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.
What should you do on the dedicated SQL pool?

  • A. Scale down the data warehouse units (DWUs).
  • B. Pause the pool.
  • C. Create a user-defined restore point.
  • D. Delete the pool
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Answer:

Discussions
0 / 1000

Question 6

You need to store data by using Azure Table storage.
What should you create first?

  • A. an Azure Cosmos DB instance
  • B. a storage account
  • C. a blob container
  • D. a table
Answer:

b

User Votes:
A
50%
B
50%
C
50%
D
50%

First create an Azure storage account, then use Table service in the Azure portal to create a table.
Note: An Azure storage account contains all of your Azure Storage data objects: blobs, files, queues, and tables.
Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-quickstart-portal https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

DRAG DROP Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Answer:


Box 1: Azure Data factory -
Relevant Azure service for the three ETL phases are Azure Data Factory and SQL Server Integration Services (SSIS).

Box 2: Azure Synapse Analytics -
You can copy and transform data in Azure Synapse Analytics by using Azure Data Factory
Note: Azure Synapse Analytics connector is supported for the following activities:
Copy activity with supported source/sink matrix table
Mapping data flow
Lookup activity
GetMetadata activity
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse

Discussions
0 / 1000

Question 8

DRAG DROP Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Answer:


Reference:
https://en.wikipedia.org/wiki/Table_(database)
https://en.wikipedia.org/wiki/View_(SQL)
https://en.wikipedia.org/wiki/Database_index

Discussions
0 / 1000

Question 9

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

  • A. document
  • B. columnar
  • C. graph
  • D. time series
Answer:

a

User Votes:
A
50%
B
50%
C
50%
D
50%

None

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

Which language is used to define queries in Azure Synapse Data Explorer?

  • A. Bash
  • B. PowerShell
  • C. KQL
  • D. SQL
Answer:

c

User Votes:
A
50%
B
50%
C
50%
D
50%

None

Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2