DRAG DROP
You have a shared dataset in Power Bl named Dataset1.
You have an on-premises Microsoft SQL Server database named DB1.
You need to ensure that Dataset1 refreshes data from DB1.
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.
Select and Place:
HOTSPOT
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry was captured.
You have the following query in Power Query Editor.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point
Hot Area:
HOTSPOT
You have the Power BI workspaces shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT
You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:
Returns the fiscal prior year-to-date value for [sales Amount]
Uses a fiscal year end of June 30
Produces no result for dates in the future
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT
You have the following code in an Azure Synapse notebook.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code. NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT
You are using an Azure Synapse notebook to create a Python visual.
You run the following code cell to import a dataset named Iris.
A sample of the data is shown in the following table.
You need to create the visual shown in the exhibit. (Click the Exhibit tab.)
How should you complete the Python code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Hot Area:
You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins. You need to reduce the load time of the dataflow. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Reduce the memory assigned to the dataflows.
B. Execute non-foldable operations before foldable operations.
C. Execute foldable operations before non-foldable operations.
D. Place the ingestion operations and transformation operations in a single dataflow.
E. Place the ingestion operations and transformation operations in separate dataflows.
You are creating a Python visual in Power Bl Desktop.
You need to retrieve the value of a column named Unit Price from a DataFrame.
How should you reference the Unit Price column in the Python code?
A. pandas.DataFrame('Unit Price')
B. dataset['Unit Price']
C. data = [Unit Price]
D. ('Unit Price')
You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1. DB1 is a transactional database in the third normal form.
You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality. What should you include in the recommendation?
A. Create calculated columns in Dataset1.
B. Remove the relationships from Dataset1.
C. Normalize the tables in DB1.
D. Denormalize the tables in DB1.
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
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
You have a development workspace in the Power BI service.
You plan to use Tabular Editor to develop and deploy a new dataset, and then use Power BI Desktop to create and publish a report to the Power BI service.
Which three components should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. the Read Write XMLA endpoint in a capacity
B. a Premium Per User workspace
C. the Read Write XMLA endpoint in the tenant
D. a .pbix file that has an imported dataset
E. a .pbix file that has a live connection
The new process for deploying Power BI reports and datasets to the User Experience workspace must ensure that the datasets point to the lake database to which the relevant dataset is deployed. The views in each lake database must present the data in a tabular format.
You need to meet the technical requirements for deploying reports and datasets to the User Experience workspace.
What should you do?
A. From the Corporate Data Models and User Experience workspaces, select Allow contributors to update the app.
B. From the Corporate Data Models and User Experience workspace, set License mode to Premium per user.
C. From the Tenant settings, set Allow specific users to turn on external data sharing to Enable.
D. From the Developer settings, set Allow service principals to use Power BI APIs to Enable.
The enterprise analytics team needs to resolve the DAX measure performance issues. What should the team do first?
A. Use Performance analyzer in Power BI Desktop to get the DAX durations.
B. Use DAX Studio to get detailed statistics on the server timings.
C. Use DAX Studio to review the Vertipaq Analyzer metrics.
D. Use Tabular Editor to create calculation groups.
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You split the IoT DateTime column into a column named Date and a column named Time.
Does this meet the goal?
A. Yes
B. No