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.

Select all answers that apply.

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 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?

Select only one answer.

When importing data from an Excel workbook into Power BI, you receive the error message: “We couldn't find any data formatted as a table.”

What should you do to resolve the error?

Select only one answer.

You use Power BI Desktop to transform a query that retrieves data from an Excel spreadsheet.

You need to view and modify multiple steps in all the M code.

Which interface should you use?

Select only one answer.

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?

Select only one answer.

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?

Select only one answer.

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?

Select only one answer.

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 a fact table that contains sales data.

The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options.

You load the fact table into Power BI Desktop.

You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort.

What should you do?

Select only one answer.

You have an Azure SQL database that contains two tables named SalesOrders and SalesOrderDetails.

You load the SalesOrders and SalesOrderDetails tables into Power BI Desktop. The tables have a relationship based upon the SalesOrderID column.

You need to combine the two tables into one table. The solution must meet the following requirements:

• There is a row for every SalesOrderDetails row in the resulting table, even if there is no corresponding SalesOrders row.

• For every SalesOrderDetails row, the row in the resulting table includes the corresponding SalesOrders row data if the SalesOrder row exists.

• Any SalesOrder row data that does not have corresponding SalesOrderDetails rows is not included in the resulting table.

What should you do to combine the two tables?

Select only one answer.

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

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

Select only one answer.

When multiple reports use the same Power BI dataset vs each having their own import model, you reduce the number of datasets that are needed to be published to the Power BI service. Fewer datasets mean fewer refreshes, less storage space requirements, and less overhead for admins.

You have a Power BI model with the following fact tables and storage modes.

• FactStoreSales (Import mode)

• FactOnlineSales (DirectQuery mode)

You have a dimension table named DimCalendar that has a relationship to both fact tables.

You need to assign a storage mode for DimCalendar. The solution must minimize the time to execute queries that combine data from the dimension table and the fact tables.

Which storage mode should you use?

You plan to use Power BI Desktop to create a report with multiple visualizations.

You need to create a visual that supports the following:

• filters other visuals on the same report page

• allows users to search for values by which to filter the other visuals

Which type of visualization should you use?

Select only one answer.

You plan to create a report in Power BI Desktop.

You need to create a visualization to display a running total. The solution must meet the following requirements:

• The initial and the final value columns must start on the horizontal axis.

• The intermediate values must be floating columns.

Which type of visualization should you use?

Select only one answer.

You plan to create a report in Power BI Desktop.

You need to identify the type of visualization that displays data as a set of nested rectangles.

Which visualization should you use?

You need to create a custom R visual by using Power BI Desktop.

What do you need to do first?

Select only one answer.

You need to create a custom Python visual by using Power BI Desktop.

What do you need to do first?

Select only one answer.

You need to create a visual that displays sales by employees, trending over months.

The visual must clearly show how employees are performing against each other and have a ranking for each period.

Which visual should you use? Select only one answer.

You implement the Q&A feature in a report, so users can get answers to their questions on their own.

You need to improve your Q&A search capabilities for end-users.

Which two configurations can you add? Each correct answer presents a complete solution.

Select all answers that apply.

You are modifying a report in Power BI Desktop. The report contains a single report page that has three card visuals and one clustered bar chart.

You need to create a bookmark that displays only the clustered bar chart and hides the cards. The solution must minimize development effort.

What should you do first?

Select only one answer.

You plan to build a Power BI report and set up conditional formatting of data fields.

You need to identify two visuals that support the conditional formatting functionality.

Which two types of visuals should you identify? Each correct answer presents a complete solution.

Select all answers that apply

You have a bar chart and column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value.

Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data?

Select only one answer.

You have a Power BI report that uses a dataset that is imported from a database.

You add a slicer to a report.

You need to sync the slicer to use it on other report pages.

What is required to sync slicers between report pages?

Select only one answer.

You plan to create a report in Power BI Desktop that will display the relationship between the number of orders and the number of orders shipped by product category.

You need to identify the visual that will clearly identify outliers in the data set by displaying them away from the bulk of data.

Which visual should you use?

Select only one answer.

You need to create a visual that will display information on a continuous axis.

Which two data types can be used to display a continuous axis on a visual? Each correct answer presents a complete solution.

Select all answers that apply.

Which native AI visual helps explain correlations for a metric within the dataset?

Select only one answer.

You plan to build a Power BI dashboard and set up alerts that will notify you when data presented in the visuals on the dashboard reach specific thresholds.

Which three types of visuals support the alert functionality? Each correct answer presents a complete solution.

Select all answers that apply.

You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety of reports.

Which three objects from a report page can be pinned to the dashboard?

Select all answers that apply.

You upload reports to the Power BI service and pin several visuals to a dashboard.

You plan to create alerts rules for several visuals.

What are two locations you can view the alerts? Each correct answer presents a complete solution.

Select all answers that apply.

You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace.

What should you do first?

Select only one answer.

You plan to certify a Power BI dataset.

You need to identify at which level within your organization the permissions to certify a dataset are assigned.

Which level should you identify?

Select only one answer.

1.      Your company has a SharePoint server located in a datacentre in Montreal.

You plan to create a report in the Power BI service that will use Microsoft Excel files stored on the SharePoint server.

You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily.

What should you include in the recommendation?

Select only one answer.

You have a row level security role (RLS) in a dataset called User Security Group. This role needs to filter a RLS table that contains a column with the emails of users in the following format:

name@company.com

Which function should be used in the code for the RLS role to match the users Microsoft Entra ID login credentials with the emails contained in the RLS table column?

Select only one answer.

You manage a Power BI workspace that includes a dataset with your company's sales data. You create a report that displays the sales data grouped by department.

You need to use row-level security to ensure that, once the report is published, employees in each department can only see the sales data for their department.

What should you do first?

Select only one answer.

You have designed a star schema to simplify your data.

You need to understand the relationship between the tables in the star schema.

What is the relationship between the fact table and dimension tables?

Select only one answer

You have the following Power Query M formula that generates a range of dates.

= List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0))

What is the resulting date range?

Select only one answer.

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?

Select only one answer.

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.

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.

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.

Select all answers that apply.

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

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

Select all answers that apply

1.      You have a Power BI Desktop model.

You need to determine when to use implicit and explicit measures.

What is a feature of an implicit measure that explicit measure does NOT have?

Select only one answer.

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?

Select only one answer.

You have Power BI Desktop.

You need to determine query timings for a report page visual.

Which method should you use?

Select only one answer

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.

Select all answers that apply.

You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals.

You plan to use Performance Analyzer to evaluate the performance of the visuals.

You need to eliminate the impact of visual caching during the evaluation.

What should you do first?

Select only one answer

You have a Power BI Desktop dataset 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 dataset.

Which function should you use?

Select only one answer.

You are creating a report in a Power BI Desktop by using a dataset 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?

Select only one answer.