DP-900 Exam Dumps - Microsoft Azure Data Fundamentals

Box 1: No

You can duplicate a dashboard. The duplicate ends up in the same Power BI workspace.

There is no current functionality that allows you to move reports from one workspace to another.

Box 2: No

Box 3: Yes

An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:

APPROX_COUNT_DISTINCT

AVG

CHECKSUM_AGG

COUNT

COUNT_BIG

GROUPING

GROUPING_ID

MAX

MIN

STDEV

STDEVP

STRING_AGG

SUM

VAR

VARP

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.