Microsoft DP-600 Exam Practice Questions (P. 4)
- Full Access (184 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #16
You are analyzing the data in a Fabric notebook.
You have a Spark DataFrame assigned to a variable named df.
You need to use the Chart view in the notebook to explore the data manually.
Which function should you run to make the data available in the Chart view?
You have a Spark DataFrame assigned to a variable named df.
You need to use the Chart view in the notebook to explore the data manually.
Which function should you run to make the data available in the Chart view?
- AdisplayHTML
- Bshow
- Cwrite
- Ddisplay
Correct Answer:
D
D
GPT-4o - Answer
When exploring data within a Fabric notebook, employing the 'display' function enables you to directly make a Spark DataFrame visible in the Chart view. This utility is specifically tailored for interactive data exploration and visualization, allowing you to efficiently analyze and derive insights from the data. Importantly, while other functions like displayHTML offer data rendering capabilities, they are not designed for the direct interactive visualization capabilities facilitated by the Chart view for which 'display' is optimal.
Question #17
You have a Fabric tenant that contains a Microsoft Power BI report named Report1. Report1 includes a Python visual.
Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed.
You need all rows to appear in the visual.
What should you do?
Data displayed by the visual is grouped automatically and duplicate rows are NOT displayed.
You need all rows to appear in the visual.
What should you do?
- AReference the columns in the Python code by index.
- BModify the Sort Column By property for all columns.
- CAdd a unique field to each row.
- DModify the Summarize By property for all columns.
Correct Answer:
A
A
GPT-4o - Answer
Reference the columns in the Python code by index as mentioned in official Microsoft documentation. This approach ensures that each row in the dataset is treated as unique, thus preventing automatic grouping and allowing all rows, including duplicates, to be displayed properly in the Python visual. While there are multiple potential solutions, referencing columns by index adheres closely to the guidelines provided for the exam. Be aware of this strategy when preparing for your certification exams.
Question #18
DRAG DROP -
You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.
You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return a table of stores that have opened since December 1, 2023.
How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.
You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return a table of stores that have opened since December 1, 2023.
How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Question #19
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2,000 rows.
You view the query in Power Query as shown in the following exhibit.
What can you identify about the pickupLongitude column?
You view the query in Power Query as shown in the following exhibit.
What can you identify about the pickupLongitude column?
Question #20
You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dataset named DS1.
You need to ensure read-write access to DS1 is available by using XMLA endpoint.
What should be modified first?
You need to ensure read-write access to DS1 is available by using XMLA endpoint.
What should be modified first?
- Athe DS1 settings
- Bthe WS1 settings
- Cthe C1 settings
- Dthe Tenant1 settings
Correct Answer:
C
C
GPT-4o - Answer
To ensure read-write access to the dataset DS1 via XMLA endpoint, you start with adjusting the C1 settings, specifically the capacity settings. This approach is necessary because read/write permissions for XMLA operations are managed at the capacity level, not at the dataset or workspace level. Initially setting permissions here enables controlled access for tasks such as real-time querying or management within external tools.
All Pages