exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 12 discussion

Actual exam question from Microsoft's DP-600
Question #: 12
Topic #: 1
[All DP-600 Questions]

HOTSPOT -
You have a Fabric tenant.
You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power BI visuals.
You run the following code.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Momoanwar
Highly Voted 1 year, 3 months ago
I think : No yes no To display summary its describe() or sumarry()
upvoted 47 times
scorradi
5 months, 1 week ago
My guess: No, Yes, Yes. The "summary" word in this question is not referring to a function called summary. But summary is what QuickVisualization does for us.
upvoted 1 times
...
bltemrah
1 year ago
The code displays a summary of the DataFrame. The last one should be Yes: The QuickVisualize function generates and displays a summary visualization of the DataFrame.
upvoted 11 times
...
dev2dev
1 year ago
Correct! but display() function is MS fabric native function which gives more control on summarizing df including various vizualizations
upvoted 2 times
...
...
TashaP
Highly Voted 1 year, 3 months ago
Answer is No, Yes, Yes The code is displaying a summary of the data frame using the visualizations. Point 3 is a technicality and I think to some extent depends on your interpretation of the question. I am going with Yes.
upvoted 20 times
dp600
1 year, 1 month ago
I understand your reasoning but i would go with No in 3, when I think in a summary of a dataframe I'm imagining something different.
upvoted 4 times
...
...
Mfathli
Most Recent 1 week, 3 days ago
My guess: No, Yes, Yes. The third point depends on how you interpret summary in the statement, it’s not a textual or statistical summary like .describe(), so the term "summary" is only applicable if regarded as a visual summary of the dataframe contents(which is what Quickvisualize does)
upvoted 1 times
...
hmoej
2 months, 3 weeks ago
No, Yes, Yes IMO the report itself is a summary of the dataframe. It is a bad question though, you could interpret it either way.
upvoted 1 times
...
goldy29
4 months, 2 weeks ago
So, My final answer would be No, Yes, No from powerbiclient import QuickVisualize, get_dataset_config # Create a Power BI visualization from a Spark DataFrame PBI_visualize = QuickVisualize(get_dataset_config(df)) # Display the visualization in the notebook PBI_visualize To emebed a power bi report in notebook, you need to import these libraries and then authenticate from powerbiclient import Report, models from IPython.display import display # Provide your Power BI report ID and workspace ID workspace_id = "your_workspace_id" report_id = "your_report_id" # Create an embedded report object report = Report(group_id=workspace_id, report_id=report_id) # Display the report inside the notebook display(report) For summary, you can either use describe() or summary()
upvoted 1 times
...
Egocentric
5 months ago
No, Yes, No if it is a typo dateframe or yes if not dataframe
upvoted 1 times
...
Sowwy1
6 months, 4 weeks ago
I think it's no, yes, no
upvoted 1 times
...
Rakesh16
7 months ago
No-->yes-->yes
upvoted 1 times
...
semauni
7 months, 2 weeks ago
No, No, Yes 1) The code will display the contents of a dataframe, not an existing report. 2) The code does not create a new PBI report. Only after you click 'save' is a new report made. 3) The result of this code is a newly rendered block called 'Quick summary' with PBI visualisations. So if Microsoft calls it a summary, it is a summary. Reference: https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization
upvoted 4 times
MultiCloudIronMan
6 months, 1 week ago
No No Yes for the reason above
upvoted 1 times
...
semauni
7 months, 1 week ago
Correction for 2: Yes. What I wrote is not wrong, however, Microsoft itself talks about 'creating a new report' and 'an embedded' report. So while I personally wouldn't consider it a new report, Microsoft does, and as long Microsoft grade you and not me, I would say Yes :) Reference:https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization#embed-a-power-bi-report-in-a-notebook
upvoted 1 times
...
...
jass007_k
7 months, 3 weeks ago
The provided answer is correct (No Yes Yes). Because with this code, we do get a Quick summary in the visualization. Please check the documentation and visualization image on this link: https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization
upvoted 3 times
...
cafb698
9 months, 3 weeks ago
No, Yes, Yes
upvoted 1 times
...
vka11
1 year ago
The answer is No Yes Yes. See the documentation link, contains the exact code that is in the question https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization
upvoted 10 times
vka11
1 year ago
The doc clearly states that the last code line i.e. PBI_visualize renders new report
upvoted 3 times
...
...
Plb2
1 year ago
Creates a PBI report? Not so sure, it shows a visualization like a PBI report, does not save it as such until you hit save.
upvoted 2 times
...
282b85d
1 year ago
The code embeds an existing Power BI report: No: Typically, embedding an existing Power BI report involves using Power BI REST API or embedding URLs, not Spark DataFrame operations within a notebook. The provided code snippet seems more focused on data manipulation and visual creation within the notebook itself, rather than embedding an external report. The code creates a Power BI report: Yes: When working with Spark DataFrames in a Fabric notebook, you can generate visuals that can be published to Power BI. This involves converting DataFrames to a format that Power BI can consume and using integration features provided by Fabric to create reports based on this data. The code displays a summary of a DataFrame: Yes: If the code snippet includes functions like display(df), df.show(), or similar methods, it is intended to display a summary or the contents of the DataFrame. These functions are commonly used to provide a quick overview of the data within the notebook environment.
upvoted 5 times
...
laitoanthang
1 year ago
No yes no The third one is a little bit confused though. Anyway, the QuickVisualize is using the DataFrame, but it doesn't directly display a summary of the DataFrame itself You'd need to use another method like describe() or summary()
upvoted 2 times
bltemrah
1 year ago
The code displays a summary of the DataFrame. The last one should be Yes: The QuickVisualize function generates and displays a summary visualization of the DataFrame.
upvoted 1 times
...
...
stilferx
1 year, 1 month ago
IMHO, No -> Yes -> Yes. Link is here: https://learn.microsoft.com/en-us/power-bi/create-reports/jupyter-quick-report#create-and-render-a-quick-visualize-instance It is not embedded, it is an actual report. The 3rd one - is philosophical, but it summarizes the info from the data frame, so it makes sense to have "Yes" there
upvoted 8 times
stilferx
1 year, 1 month ago
Probably, as colleagues said before, maybe the last one is No (it would be 100% yes for describe() )
upvoted 2 times
...
...
cmonte2
1 year, 1 month ago
No, Yes and According to https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization#displaydf-summary-view the third should be No
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...