Practice Free DP-900 Exam Online Questions
Which service can be used to build extract, transform, and load (ETL) pipelines?
- A . Azure SQL Database
- B . Azure Pipelines
- C . Azure Databricks
- D . Azure Cosmos DB
- E . Azure Data Factory
DRAG DROP
Match the job roles to the appropriate tasks.
To answer, drag the appropriate job role from the column on the left to its task on the right Each role may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
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.
Explanation:
Box 1: Yes
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.
Box 2: Yes
You can stream data into Azure Databricks using Event Hubs.
Box 3: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector.
Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs
Which statement is an example of Data Manipulation Language (DML)?
- A . INSERT
- B . DISABLE
- C . ALTER
- D . DROP
A
Explanation:
Data Manipulation Language (DML) statements:
DELETE
INSERT
UPDATE
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements
Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends.
Which type of data store should you use?
- A . relational
- B . columnar
- C . graph
- D . time series
D
Explanation:
Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
What is the responsibility of a database administrator?
- A . applying data cleaning routines
- B . creating data visualizations
- C . managing data integration processes
- D . storing backup copies of data
Which type of Azure resource supports the serverless configuration of an Azure SQL database?
- A . Azure SQL Managed Instance
- B . SQL Server on Azure Virtual Machines
- C . a single database in Azure SQL Database
- D . an Azure SQL Database elastic pool
Select the answer that correctly completes the sentence.
You have structured data in tabular format.
What represents an individual instance of a data entity?
- A . a column
- B . a cell
- C . a row
- D . a table
DRAG DROP
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement on the right.
Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Box 1: Azure Data Factory
Box 2: Azure Data Lake Storage
Azure Data Lake Storage (ADLA) now natively supports Parquet files. ADLA adds a public preview of the native extractor and outputter for the popular Parquet file format
Box 3: Azure Synapse Analytics
Use Azure Synapse Analytics Workspaces.
Reference: https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs