Power BI Test 1

You are creating a Power BI dashboard.

You need to apply a custom theme to the dashboard from another Power BI dashboard theme.

Which type of file should you use?

You are evaluating whether you need to create a dashboard in Power BI.

In which scenario do you need a dashboard instead of a report in Power BI?

Select only one answer.

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 plan to create a Power BI workspace.

You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created.

Which setting should you configure when creating the workspace?

Select only one answer.

You manage a Power BI workspace in shared capacity. The workspace contains a dataset named DS1. You plan to schedule the refresh of DS1.

What is the maximum number of data refreshes per day?

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

You need to set the dataset as discoverable.

Which two configurations will allow the dataset to be marked as discoverable? Each correct answer presents a complete solution.

Select all answers that apply.

You have a collection of datasets and reports.

You need to share the datasets and report together. This solution must NOT send any email notifications to internal users after sharing.

What should you create in the Power BI Service?

Select only one answer.

You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson’s Azure AD 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.

Select all answers that apply.

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

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?

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

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

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

Select all answers that apply.

You need to create a row level security (RLS) role for a dataset.

What should you do first?

Select only one answer.

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.

You have a Power BI Desktop dataset that includes a table named Warehouse. The Warehouse table includes a column named Inventory Count, which contains the current number of items for each row of a particular type on a given day.

You have the following Data Analysis Expression (DAX) query that calculates the sum of all values in the Inventory Count column of the Warehouse table:

Current Inventory Count =
CALCULATE (
SUM ( ‘Warehouse'[Inventory Count] ))

You need to ensure that Current Inventory Count returns only the current total number of inventory items, rather than the sum of all inventory items that includes item counts from previous days.

What DAX function should you include in the query?

Select only one answer.

You need to reduce the size of a Power BI 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 dataset supports reports that analyze average temperature by hour and location.

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

Select all answers that apply.

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?

Select only one answer.

You have implemented role-based security that restricts access to a Power BI Desktop dataset for users who are assigned the role named Salespeople.

You need to validate that the implementation works.

What should you do?

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

Select only one answer.

You plan to create a report in Power BI Desktop that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted.

You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next.

Which visualization should you use?

Select only one answer.

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 bookmark that toggles the visibility of a visual.

This bookmark must only toggle the visibility state and perform no other action.

Which three configurations should you make? Each correct answer presents part of the solution.

Select all answers that apply.

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 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 are using Power BI Desktop to edit a stacked column chart that displays gross sales data with a date hierarchy that contains year, quarter, month, and day.

You need to prevent users from viewing the hierarchy based on the year.

What should you do?

Select only one answer.

You have a visual that is being cross-highlighted.

By default, what data will be displayed in a report tooltip?

Select only one answer.

You plan to use Power BI Desktop to analyze sales data for products sold by your company.

You need to create a DAX formula that will list 10 best-selling products sorted by their total sales.

Which DAX function should you use?

Select only one answer.

You plan to use Power BI Desktop to analyze sales data of your company.

You need to identify two types of data you will be able to use for creating bins that group the sales data.

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

Select all answers that apply.

You need to create a report in Power BI Desktop that will display the sales data of your company such that customers of a similar age will be grouped into clusters.

Which visual should you add to the report?

Select only one answer.

You need to create a histogram that will display ranges of integers in groups.

Which two resources do you need to create the histogram? Each correct answer presents part of the 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 get data from flat files for a Power BI dataset.

You need to select a location to store the files.

Which location requires an on-premises data gateway?

Select only one answer.

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

You need to select a location for the files. The location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365 credentials.

Which two location types should you recommend? Each correct answer presents a complete solution.

Select all answers that apply.

You have a Power BI dataset that gets data from a table in a SQL Server database.

From which view in Power BI Desktop can you modify the storage mode of the table?

Select only one answer.

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 DirectQuery instead of Import? Each correct answer presents a complete solution.

Select all answers that apply.

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 plan to publish a dataset from Power BI Desktop.

You need to ensure that a server name can be changed after the dataset has been published to the Power BI Service.

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

Select all answers that apply.

You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries.

When importing data from the data source into Power BI, you receive the following error message: “Timeout expired.”

You verify that network connection to the SQL Server has sufficient available bandwidth and low latency.

You need to minimize the occurrences of the timeout issues indicated by the message.

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 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 connect Power Query Editor to a database table.

You need to remove the Row ID column. Your solution must ensure that new columns do NOT display in the table model during a scheduled refresh in the future.

What transformation should you use?

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.

You have an Excel spreadsheet that contains two columns as follows:
• Category: Contain names of categories
• Subcategory: Contain names of subcategories for each category

You import the Excel spreadsheet into Power BI Desktop.

You need to transform the data to meet the following requirements:
• Have multiple columns, where one column represents one category
• Have a single row that includes the total count of subcategories for each category

Which transformation should you use?

Select only one answer.

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