Kartenstapel

You plan to create a report in Power BI Desktop.

You need to create a visualization that displays data in two or more dimensions and cross-highlights with other visuals on the same report page.

Which type of visualization should you use?

Select only one answer.

Card

You need to create a Power BI dashboard.

Which tool should you use?

You have a Power BI model.

You need to assign items to a display folder.

Which three items can be assigned to a display folder? Each correct answer presents part of the solution.

Your organization is designing a Power BI semantic model to analyze sales performance. The model includes a 'Sales' fact table and dimension tables: 'Product', 'Customer', and 'Date'.

You need to establish relationships between these tables for accurate data filtering and aggregation.

Each correct answer presents part of the solution. Which two actions should you perform?

Select all answers that apply.

Define one-to-many relationships from dimension tables to the fact table.

Enable bi-directional cross-filtering.

Set single-direction cross-filtering.

Use many-to-many relationships between the fact table and dimension tables.

You need to create a new hierarchy in Power BI Desktop.

What should you do first?

You plan to use the calculated table functionality to add a duplicate table in Power BI Desktop.

Which characteristics of the original table will be duplicated?

You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report.

In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.

You need to develop a quick measure in Power BI Desktop.

Which two elements can you use? Each correct answer presents a complete solution.

In Power BI Desktop, you need to create a measure.

Which two interfaces can you use? Each correct answer presents a complete the solution.

You are creating a report in a Power BI Desktop by using a semantic model that contains sales data.

You need to create a measure that always provides the value of total sales for the year 2022, regardless of which year is selected in any visual in the same report.

Which DAX function should you use in combination with the SUM function to override the context and provide the result?

You have a Power BI Desktop semantic model that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson’s Microsoft Entra ID account.

You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name.

Which two actions should you perform? Each correct answer presents part of the solution.

You have a Power BI Desktop semantic model based on a star schema data source.

You need to use Data Analysis Expression (DAX) to create a date table in the dataset and populate the table with a range of dates based on the earliest and latest date within the semantic model.

Which function should you use?

You need to reduce the cardinality of a column in a Power BI semantic model.

What should you do?

Sie erstellen ein Power BI-Dashboard.

Sie müssen ein benutzerdefiniertes Design aus einem anderen Power BI-Dashboarddesign auf das Dashboard anwenden.

Welche Art von Datei sollten Sie konfigurieren?

You plan to get data from flat files for a Power BI semantic model.

You need to select a location to store the files.

Which location requires an on-premises data gateway?

You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode.

What are two benefits of using Import instead of DirectQuery? Each correct answer presents a complete solution.

You have multiple Excel files stored in a folder synced with OneDrive for Business.

You need to import data from the files. The solution must NOT use a data gateway.

Which type of connector should you use?

You plan to publish a semantic model from Power BI Desktop.

You need to ensure that your data source server name can be changed after the semantic model has been published to the Power BI Service.

Which two actions should you perform? Each correct answer presents part of the solution.

You have created a Power BI semantic model and need to create multiple reports.

What is a benefit of using a Power BI semantic model as a data source for multiple reports compared to each report having a separate semantic model?

From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows.

You plan to identify data anomalies within the data source.

You need to ensure that column distribution considers all rows in the Excel file.

What should you do?

You have a query that retrieves data from a table that contains more than 8,000 rows of data.

In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000.

You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query.

What should you do?

You are analyzing query data by using Power Query Editor.

You need to ensure that the Column statistics are based on an analysis of the entire dataset.

What should you do?

Your organization is using Microsoft Power BI to analyze sales data, which contains null values in the 'Sales Amount' column and text entries in numeric fields.

You need to clean the data to resolve these inconsistencies.

Which two actions should you take? Each answer is part of the solution.

You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year.

You import data from the Excel spreadsheet into Power BI Desktop.

You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year.

Which transformation should you use first?

You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month.

You need to reshape the table to have all sales amount values in a single column.

A new column should also be added and contain the relevant month year for each row of data.

What should you do from the Power Query Editor?

You have a table that contains a column named ProductID.

The ProductID column contains values that have a prefix of PD followed by five numbers. For example: PD15332.

You plan to convert the ProductID values to numbers (integer).

You need to remove the leading two letters from the current ProductID values.

Which two commands can you use? Each correct answer presents a complete solution.

You have a Power BI data source that contains the following tables:

• ProductCategory: Lists the product category ID and category name

• ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID

• ProductList: Lists the product ID, name, and subcategory ID

You need to optimize the data to create a dimension for use in a star schema data model.

How should the tables be transformed before loading into the model?

From Power BI Desktop, you create a data source by importing a Cosmos DB for NoSQL item collection.

You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record.

You need to select individual fields from items in the collection that you want to load into Power BI Desktop.

What should you do first?

You have begun the process of creating a Power BI Semantic model by connecting to a data source based on multiple tables in a SQL Server database.

You need to modify the relationship between the tables.

Which interface should you use in the Power BI Desktop?

You are designing a data model in Power BI.

You need to avoid introducing ambiguity into your data model design.

Which type of cardinality should you avoid?

You have a fact table that contains sales data and the following two date columns:

• OrderDate

• ShipDate

Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates.

You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships.

What should you do?

Select only one answer.

Disable Make this relationship active for both relationships.

Enable Apply security filter in both directions for both relationships.

Enable Make this relationship active for both relationships.

Set the cross-filter direction to both for each relationship.

Your organization is designing a Power BI semantic model to analyze sales performance. The model includes a 'Sales' fact table and dimension tables: 'Product', 'Customer', and 'Date'.

You need to establish relationships between these tables for accurate data filtering and aggregation.

Each correct answer presents part of the solution. Which two actions should you perform?

Select all answers that apply.

You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report.

In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? Each correct answer presents a complete solution.

You need to use DAX quick measures to generate results to use in a report.

Which type of DAX quick measure calculations will NOT work against a DirectQuery table?

In Power BI Desktop, you plan to use M-language to define a common date table spanning a period of 10 years.

You need identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. Your solution must minimize administrative effort.

Which syntax should you use?

You need to reduce the cardinality of a column in a Power BI semantic model.

What should you do?

You need to reduce the size of a Power BI semantic model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields:

• Reading Time (datetime)

• DateKey (date)

• LocationKey (whole number)

• Temp C (decimal)

You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships.

You need to reduce the cardinality of the table. The solution must ensure that the semantic model supports reports that analyze average temperature by hour and location.

What two actions should you perform? Each correct answer presents part of the solution.

You plan to run Power BI Desktop Performance Analyzer.

You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop.

What should you do first?

You are designing a data model for Power BI Desktop.

You need to reduce the model size.

Which technique should you use to reduce the model size?

You decide to start using variables when creating DAX formulas.

What are two benefits of using variables in DAX measures over using original expressions? Each correct answer presents a complete solution.