DP-600: Implementing
Analytics Solutions latest
updated version
You have an Azure SQL database that contains a customer
dimension table. The table contains two columns named CustomerID
and CustomerCompositeKey.
You have a Fabric workspace that contains a Dataflow Gen2 query
that connects to the database.
You need to use Dataflows Query Editor to identify which of the two
columns contains non-duplicate values per customer.
Which option should you use? - answer Column distribution - distinct
values
You have a Fabric tenant that contains a lakehouse.
You are creating a notebook to explore the data in the lakehouse.
You need create a query to find the total number of records in the
fact table for every individual product. The displayed results must
be sorted in descending order.
How should you structure the query? - answer
df.groupBy("ProductKey").count().sort("count",
descending=True).show()
You are profiling the data stored in a Fabric lakehouse.
You run the following statement.
df.describe().show()
Which three functions will be included in the results for the numeric
data? Each correct answer presents a complete solution. - answer
COUNT,MEAN,STD (standard deviation)
Analytics Solutions latest
updated version
You have an Azure SQL database that contains a customer
dimension table. The table contains two columns named CustomerID
and CustomerCompositeKey.
You have a Fabric workspace that contains a Dataflow Gen2 query
that connects to the database.
You need to use Dataflows Query Editor to identify which of the two
columns contains non-duplicate values per customer.
Which option should you use? - answer Column distribution - distinct
values
You have a Fabric tenant that contains a lakehouse.
You are creating a notebook to explore the data in the lakehouse.
You need create a query to find the total number of records in the
fact table for every individual product. The displayed results must
be sorted in descending order.
How should you structure the query? - answer
df.groupBy("ProductKey").count().sort("count",
descending=True).show()
You are profiling the data stored in a Fabric lakehouse.
You run the following statement.
df.describe().show()
Which three functions will be included in the results for the numeric
data? Each correct answer presents a complete solution. - answer
COUNT,MEAN,STD (standard deviation)
