You have an Azure Synapse Analytics notebook.
You run the xxsq1 magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.
display (df1, summary = true)
Which three attributes will be returned by the command? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics.
You need to present the data distribution statistics from a DataFrame in a tabular view.
Which method should you invoke on the DataFrame?
pandas.DataFrame.corr computes pairwise correlation of columns, excluding NA/null values.
Incorrect:
* freqItems
pyspark.sql.DataFrame.freqItems
Finding frequent items for columns, possibly with false positives. Using the frequent element count algorithm described in https://doi.org/10.1145/762471.762473, proposed by Karp, Schenker, and Papadimitriou.'
* summary is used for index.
* There is no panda method for rollup. Rollup would not be correct anyway.
You have an Azure Synapse Analytics notebook.
You run the xxsq1 magic command to render data into an Apache Spark DataFrame named df1, and then you run the following code.
display (df1, summary = true)
Which three attributes will be returned by the command? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You have a Power Bl tenant and an Azure subscription named Sub1. The Power Bl tenant and Sub1 are linked to a single Azure AD tenant.
In Sub1, you create a storage account named storage1.
You need to configure a Power Bl workspace to store dataflows in storage1. The solution must use the principle of least privilege.
Which three roles should you assign for storage1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool named Pool1.
You plan to deploy a data lake that will record the history of transactions executed against Pool1.
You need to recommend which type of file to use to store the history. The solution must ensure that the history is written in the scope of the related transaction.
Which file type should you recommend?
Jutta
1 months agoJina
2 months agoTeresita
3 months agoAliza
3 months agoTimmy
3 months agoDaniela
3 months agoKatina
3 months agoMillie
4 months agoDaniela
5 months ago