Power BI Test 2

You need to create a dashboard from a published report in Power BI.

Which option in the report should you use?

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

Select only one answer.

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

What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule?

Select only one answer.

You manage a Power BI workspace.

You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege.

Which role should you use?

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 need to assign an app workspace role for users who consume reports.

Users should only have permissions to examine the report.

Which role should you assign to users?

Select only one answer.

You have several on-premises Microsoft SQL Server databases.

You need to provide Power BI Service users access to the data sources without exposing the database servers directly to the internet.

The solution must minimize the configurations that must be performed by each user.

What should you deploy?

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

Select all answers that apply.

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 create a Power BI Desktop dataset by importing and transforming 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?

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 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 need to create a new hierarchy in Power BI Desktop.

What should you do first?

Select only one answer.

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?

Select only one answer.

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

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

Select all answers that apply.

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

What should you do?

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 decide to remove unnecessary columns from your data model.

What are two potential performance benefits of doing this? Each correct answer presents a complete solution.

Select all answers that apply.

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 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 need to make changes to your data sources.

Which three changes are supported by the Data Source Settings in the Power Query interface? 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 DirectQuery instead of Import? 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?

Select only one answer.

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.

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?

Select only one answer.

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?

Select only one answer.

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.

You have a query named FactSales that retrieves data from a SQL Server table.

You need to update the query to prevent new columns that may be added to the table in the future from getting imported during dataset refreshes.

You select the existing columns in the query.

Which two applied steps can you use in Power Query Editor to achieve the goal? Each correct answer presents a complete solution.

Select all answers that apply.

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

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?

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.

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 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 identify the type of visualization that displays data as a set of nested rectangles.

Which visualization should you use?

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

From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate.

You add a button to the Main page for navigation.

You need to implement a solution that meets the following requirements:
• The navigation destination must change based on the output of a DAX measure named [Error Rate].
• If [Error Rate] is greater than 5%, the button must display the text “Error Rate” and navigate to the Error Rate page.
• Otherwise, the button must display the text “On-time Rate” and navigate to the On-Time Rate page.

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

Select all answers that apply.

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

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.

You need to add an analytics line to a visual. The value for the line must equal the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line.

Which type of analytics line should you use?

Select only one answer.