ExamGecko
Login
Home / Microsoft / DP-600 / List of questions
Ask Question

Microsoft DP-600 Practice Test - Questions Answers, Page 2

List of questions

Question 11

Report
Export
Collapse

You have a Fabric warehouse that contains a table named Staging.Sales. Staging.Sales contains the following columns.

Microsoft DP-600 image Question 11 90424 10022024015944000000

You need to write a T-SQL query that will return data for the year 2023 that displays ProductID and ProductName arxl has a summarized Amount that is higher than 10,000. Which query should you use?

A)

Microsoft DP-600 image Question 11 90424 10022024015944000000

B)

Microsoft DP-600 image Question 11 90424 10022024015944000000

C)

Microsoft DP-600 image Question 11 90424 10022024015944000000

D)

Microsoft DP-600 image Question 11 90424 10022024015944000000

Option A
Option A
Option B
Option B
Option C
Option C
Option D
Option D
Suggested answer: B

Explanation:

The correct query to use in order to return data for the year 2023 that displays ProductID, ProductName, and has a summarized Amount greater than 10,000 is Option B. The reason is that it uses the GROUP BY clause to organize the data by ProductID and ProductName and then filters the result using the HAVING clause to only include groups where the sum of Amount is greater than 10,000. Additionally, the DATEPART(YEAR, SaleDate) = '2023' part of the HAVING clause ensures that only records from the year 2023 are included. Reference = For more information, please visit the official documentation on T-SQL queries and the GROUP BY clause at T-SQL GROUP BY.

asked 02/10/2024
Rok Nemec
31 questions

Question 12

Report
Export
Collapse

HOTSPOT

You have a data warehouse that contains a table named Stage. Customers. Stage-Customers contains all the customer record updates from a customer relationship management (CRM) system. There can be multiple updates per customer

You need to write a T-SQL query that will return the customer ID, name, postal code, and the last updated time of the most recent row for each customer ID.

How should you complete the code? To answer, select the appropriate options in the answer area,

NOTE Each correct selection is worth one point.



Microsoft DP-600 image Question 12 90425 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 12 90425 10022024015944000
asked 02/10/2024
Arkadius Thoma
49 questions

Question 13

Report
Export
Collapse

HOTSPOT

You have a Fabric tenant.

You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power Bl visuals.

You run the following code.

Microsoft DP-600 image Question 13 90426 10022024015944000000

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


Microsoft DP-600 image Question 13 90426 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 13 90426 10022024015944000
asked 02/10/2024
Anthony Steele
42 questions

Question 14

Report
Export
Collapse

You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:

* Table1: A Delta table created by using a shortcut

* Table2: An external table created by using Spark

* Table3: A managed table

You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?

ReadTable3.
ReadTable3.
Update the data Table3.
Update the data Table3.
ReadTable2.
ReadTable2.
Update the data in Table1.
Update the data in Table1.
Suggested answer: D
asked 02/10/2024
Zaneta Zagajewska
31 questions

Question 15

Report
Export
Collapse

You have a Fabric tenant that contains a warehouse.

You use a dataflow to load a new dataset from OneLake to the warehouse.

You need to add a Power Query step to identify the maximum values for the numeric columns.

Which function should you include in the step?

Table. MaxN
Table. MaxN
Table.Max
Table.Max
Table.Range
Table.Range
Table.Profile
Table.Profile
Suggested answer: B

Explanation:

The Table.Max function should be used in a Power Query step to identify the maximum values for the numeric columns. This function is designed to calculate the maximum value across each column in a table, which suits the requirement of finding maximum values for numeric columns. Reference = For detailed information on Power Query functions, including Table.Max, please refer to Power Query M function reference.

asked 02/10/2024
Kina Collins
37 questions

Question 16

Report
Export
Collapse

You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the predict function in a fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

T-SQL
T-SQL
DAX EC.
DAX EC.
Spark SQL
Spark SQL
PySpark
PySpark
Suggested answer: C, D

Explanation:

The two languages you can use to perform model scoring in a Fabric notebook using the predict function are Spark SQL (option C) and PySpark (option D). These are both part of the Apache Spark ecosystem and are supported for machine learning tasks in a Fabric environment. Reference = You can find more information about model scoring and supported languages in the context of Fabric notebooks in the official documentation on Azure Synapse Analytics.

asked 02/10/2024
Mathijn Smit
41 questions

Question 17

Report
Export
Collapse

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?

displayMTML
displayMTML
show
show
write
write
display
display
Suggested answer: D

Explanation:

The display function is the correct choice to make the data available in the Chart view within a Fabric notebook. This function is used to visualize Spark DataFrames in various formats including charts and graphs directly within the notebook environment. Reference = Further explanation of the display function can be found in the official documentation on Azure Synapse Analytics notebooks.

asked 02/10/2024
Ann Nacua
45 questions

Question 18

Report
Export
Collapse

You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. 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?

Reference the columns in the Python code by index.
Reference the columns in the Python code by index.
Modify the Sort Column By property for all columns.
Modify the Sort Column By property for all columns.
Add a unique field to each row.
Add a unique field to each row.
Modify the Summarize By property for all columns.
Modify the Summarize By property for all columns.
Suggested answer: C

Explanation:

To ensure all rows appear in the Python visual within a Power BI report, option C, adding a unique field to each row, is the correct solution. This will prevent automatic grouping by unique values and allow for all instances of data to be represented in the visual. Reference = For more on Power BI Python visuals and how they handle data, please refer to the Power BI documentation.

asked 02/10/2024
ERIK BURDETT
42 questions

Question 19

Report
Export
Collapse

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.


Microsoft DP-600 image Question 19 90432 10022024015944000
Correct answer: Microsoft DP-600 image answer Question 19 90432 10022024015944000

Explanation:

DAX FILTER Function

DAX SUMMARIZE Function

asked 02/10/2024
Nabil MHB
44 questions

Question 20

Report
Export
Collapse

You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.

Microsoft DP-600 image Question 20 90433 10022024015944000000

What can you identify about the pickupLongitude column?

The column has duplicate values.
The column has duplicate values.
All the table rows are profiled.
All the table rows are profiled.
The column has missing values.
The column has missing values.
There are 935 values that occur only once.
There are 935 values that occur only once.
Suggested answer: B

Explanation:

The pickupLongitude column has duplicate values. This can be inferred because the 'Distinct count' is 935 while the 'Count' is 1000, indicating that there are repeated values within the column. Reference = Microsoft Power BI documentation on data profiling could provide further insights into understanding and interpreting column statistics like these.

asked 02/10/2024
Laura G
57 questions
Total 118 questions
Go to page: of 12
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have a Microsoft Power Bl semantic model that contains measures. The measures use multiple calculate functions and a filter function. You are evaluating the performance of the measures. In which use case will replacing the filter function with the keepfilters function reduce execution time?
You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! 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 have a Microsoft Power Bl report named Report1 that uses a Fabric semantic model. Users discover that Report1 renders slowly. You open Performance analyzer and identify that a visual named Orders By Date is the slowest to render. The duration breakdown for Orders By Date is shown in the following table. What will provide the greatest reduction in the rendering duration of Report1?
You need to refresh the Orders table of the Online Sales department. The solution must meet the semantic model requirements. What should you include in the solution?
You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 contains a Delta table named Customer. When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table. You need to identify whether maintenance tasks were performed on Customer. Solution: You run the following Spark SQL statement: DESCRIBE HISTORY customer Does this meet the goal?
You have a Fabric tenant that contains a semantic model. You need to prevent report creators from populating visuals by using implicit measures. What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
You have a Fabric tenant that contains a Microsoft Power Bl report named Report 1. 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?
You have a Fabric tenant that contains a warehouse. You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD). You need to recommend which columns to add to the table. The columns must NOT already exist in the source. Which three types of columns should you recommend? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
HOTSPOT You have a Fabric tenant that contains lakehouse named Lakehousel. Lakehousel contains a Delta table with eight columns. You receive new data that contains the same eight columns and two additional columns. You create a Spark DataFrame and assign the DataFrame to a variable named df. The DataFrame contains the new data. You need to add the new data to the Delta table to meet the following requirements: * Keep all the existing rows. * Ensure that all the new data is added to the table. How should you complete the code? To answer, select the appropriate options in the answer area.
DRAG DROP You create a semantic model by using Microsoft Power Bl Desktop. The model contains one security role named SalesRegionManager and the following tables: * Sales * SalesRegion * Sales Ad dress You need to modify the model to ensure that users assigned the SalesRegionManager role cannot see a column named Address in Sales Address. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.