NEW QUESTION 1

You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?

• A. PIVOT
• B. GROUPING
• C. PREDICT
• D. CAST

Answer: A

NEW QUESTION 2

You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table.

You need to create a Transact-SQL query that will return the source IP address.
Which function should you use in the select statement to retrieve the source IP address?

• A. JS0N_VALUE
• B. FOR.JSON
• C. CONVERT
• D. FIRST VALUE

Answer: A

NEW QUESTION 3

You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is expected to consume 50 GB of memory.
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Increase the Max Offline Dataset Size setting.
• B. Invoke a refresh to load historical data based on the incremental refresh policy.
• C. Restart the capacity.
• D. Publish an initial dataset that is less than 10 GB.
• E. Publish the complete dataset.

Answer: CE

NEW QUESTION 4

You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.
You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table. In which file format should you recommend storing the table data?

• A. JSON
• B. Apache Parquet
• C. CSV
• D. Delta

Answer: C

NEW QUESTION 5

You plan to modify a Power Bl dataset.
You open the Impact analysis panel for the dataset and select Notify contacts. Which contacts will be notified when you use the Notify contacts feature?

• A. any users that accessed a report that uses the dataset within the last 30 days
• B. the workspace admins of any workspace that uses the dataset
• C. the Power Bl admins
• D. all the workspace members of any workspace that uses the dataset

Answer: C

NEW QUESTION 6

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Bl dataset named Datasetl.
In Dataset1, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while maintaining the current functionality. Solution: From DAX Studio, you write a query that uses grouping sets.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 7

You have a Power Bl report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?

• A. From Report setting, select Personalize visuals.
• B. From Tabular Editor, create a new perspective.
• C. From the Bookmarks pane, select Focus mode, and then select Add.
• D. From Visual options in Report settings, select Use the modern visual header with updated styling options.

Answer: A

NEW QUESTION 8

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Bl dataset named Datasetl.
In Datasetl, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while maintaining the current functionality.
Solution: From Power Bl Desktop, you group the measures in a display folder. Does this meet the goal?

• A. Yes
• B. No

Answer: A

NEW QUESTION 9

You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table.

A sample of the data in the Commission table is shown in the following table.

You need to merge the tables by using Power Query Editor without losing any rows in the Sales table. How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 10

You need to create Power Bl reports that will display data based on the customers' subscription level.
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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 11

You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Set Use datasets across workspaces to Enabled
• B. Publish the financial data to the web.
• C. Grant the Build permission for the financial data to each customer.
• D. Configure the FinData workspace to use a Power Bl Premium capacity.

Answer: C

NEW QUESTION 12

You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to the visual libraries. Which Python libraries should you use?

• A. Seaborn only
• B. Matplotlib and Seaborn
• C. Matplotlib only
• D. Matplotlib and TensorFlow
• E. TensorFlow only
• F. Seaborn and TensorFlow

Answer: E

NEW QUESTION 13

You discover a poorly performing measure in a Power Bl data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.
What should you use?

• A. Tabular Editor
• B. Performance analyzer in Power Bl Desktop
• C. Vertipaq Analyzer
• D. DAX Studio

Answer: B

NEW QUESTION 14

You have a Power Bl dataset that has only the necessary fields visible for report development.
You need to ensure that end users see only 25 specific fields that they can use to personalize visuals. What should you do?

• A. From Tabular Editor, create a new role.
• B. Hide all the fields in the dataset.
• C. Configure object-level security (OLS).
• D. From Tabular Editor, create a new perspective.

Answer: B

NEW QUESTION 15

You have a Power Bl data model.
You need to refresh the data from the source every 15 minutes. What should you do first?

• A. Enable the XMLA endpoint.
• B. Define an incremental refresh policy.
• C. Change the storage mode of the dataset.
• D. Configure a scheduled refresh.

Answer: A

NEW QUESTION 16

You are optimizing a Power Bl data model by using DAX Studio.
You need to capture the query events generated by a Power Bl Desktop report. What should you use?

• A. the DMV list
• B. a Query Plan trace
• C. an All Queries trace
• D. a Server Timings trace

Answer: D

NEW QUESTION 17

You have a file named File1.txt that has the following characteristics:
• A header row
• Tab delimited values
• UNIX-style line endings
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool. Which query should you execute?
A)

B)

C)

D)

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: A

NEW QUESTION 18

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Bl dataset named Dataset1.
In Dataset1, you currently have 50 measures that use the same time intelligence logic. You need to reduce the number of measures, while maintaining the current functionality. Solution: From Tabular Editor, you create a calculation group.
Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 19

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should you do?

• A. Replace long text with abbreviations and acronyms.
• B. Configure a unique marker for each series.
• C. Configure a distinct color for each series.
• D. Move important information to a tooltip.

Answer: B

NEW QUESTION 20

You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements:
• Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource
• The workspace templates must be stored in the publish branch.
• A branch named dev123 will be created to support the development of a new feature. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 21
......