Search Header Logo

DP-900 M4

Authored by Miguel Saavedra

Computers

Professional Development

Used 63+ times

DP-900 M4
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

When should you use Azure Synapse Analytics?

To perform very complex queries and aggregations

To create dashboards from tabular data

To enable large number of users to query analytics data

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the purpose of data ingestion?

To perform complex data transformations over data received from external sources

To capture data flowing into a data warehouse system as quickly as possible

To visualize the results of data analysis

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the primary difference between a data lake and a data warehouse?

A data lake contains structured information, but a data warehouse holds raw business data

A data lake holds raw data, but a data warehouse holds structured information

Data stored in a data lake is dynamic, but information stored in a data warehouse is static

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which component of an Azure Data Factory can be triggered to run data ingestion tasks?

CSV File

Pipeline

Linked service

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

When might you use PolyBase?

To query data from external data sources from Azure Synapse Analytics

To ingest streaming data using Azure Databricks

To orchestrate activities in Azure Data Factory

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of these services can be used to ingest data into Azure Synapse Analytics?

Azure Data Factory

Power BI

Azure Active Directory

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

You have a large amount of data held in files in Azure Data Lake storage. You want to retrieve the data in these files and use it to populate tables held in Azure Synapse Analytics. Which processing option is most appropriate?

Use Azure Synapse Link to connect to Azure Data Lake storage and download the data

Synapse SQL pool

Synapse Spark pool

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?