DP-900_Modulo_4

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

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

• CSV File

• Pipeline

• Linked service

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

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

• Azure Data Factory

• Power BI

• Azure Active Directory

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

Which of the components of Azure Synapse Analytics allows you to train AI models using AzureML?

• Synapse Studio

• Synapse Pipelines

• Synapse Spark

In Azure Databricks how do you change the language a cell uses?

• The first line in the cell is %language. For example, %scala.

• Change the notebook language before writing the commands.

• Wrap the command in the cell with ##language##.

What is the common flow of activity in Power BI?

• Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.

• Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.

• Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.

• Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

Which of the following are building blocks of Power BI?

• Tiles, dashboards, databases, mobile devices.

• Visualizations, datasets, reports, dashboards, tiles.

• Visual Studio, C#, and JSON files.

A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI?

• The canvas.

• Scheduled refresh.

• An app.