DP-900 M4

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

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

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.