You are building a Power BI report that uses data from an Azure SQL database named erp1. You import the following tables.
You need to perform the following analyses:
✑ Orders sold over time that include a measure of the total order value Orders by attributes of products sold
The solution must minimize update times when interacting with visuals in the report. What should you do first?
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned. You build a report analyzing the internal networks of employees based on whom they send emails to. You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size. What should you do?
You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?
46.
HOTSPOT You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model. Sales contains the data shown in the following table.
You are evaluating how to optimize the model. 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 are creating an analytics report that will consume data from the tables shown in the following table
There is a relationship between the tables. There are no reporting requirements on employee_id and employee_photo. You need to optimize the data model. What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
56.
HOTSPOT You have a column named UnitsInStock as shown in the following exhibit
UnitsInStock has 75 non-null values, of which 51 are unique. 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
Explanation: Box 1: 75 rows Is nullable allows NULL values in the column. Box 2: reduce We're not dealing with a matric here, we're dealing with a simple table. In simple tables values that occur more than once won't be shown in the rows multiple times. Since you're they tell you you have 51 unique values (and the other ones aren't null values) you can be sure it's more than 51. Since you'll already have 51 rows of unique values. So the first is answer is 75. Furthermore, when you add another table, change the sign to summarize, you will add up all the values of the 51 unique values and all the rest. Which means you will get one single row, displaying the sum of all these values. Therefore, the second answer is reduce
You import a Power BI dataset that contains the following tables:
✑ Date CertyIQ
✑ Product
✑ Product Inventory
The Product Inventory table contains 25 million rows. A sample of the data is shown in the following table
The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?
HOTSPOT You have a Power BI report named Orders that supports the following analysis:
✑ Total sales over time
✑ The count of orders over time
✑ New and repeat customer counts
The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit
The data view for the Orders table is shown in the following exhibit
The Orders table relates to the Customers table by using the CustomerID column. The Orders table relates to the Date table by using the OrderDate column. 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
You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table
The report will facilitate the following analysis:
✑ The count of orders and the sum of total sales by Order Date
✑ The count of customers who placed an order
✑ The average quantity per order You need to reduce data refresh times and report query times.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You are creating a Power BI model that contains a table named Store. Store contains the following fields
You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped properly?
A. Change the data type of City, State/Province, and Country. B. Set Summarization for City, State/Province, and Country to Don't summarize. C. Set the data category of City, State/Province, and Country. D. Create a calculated column that concatenates the values in City, State/Province, and Country
You have a Power BI report for the procurement department. The report contains data from the following tables
There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table
You need to minimize the size of the dataset without affecting the visuals. What should you do?
You have a Power BI report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables
There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table.
The dataset takes a long time to refresh. You need to modify Posts and Traffic queries to reduce load times. Which two actions will reduce the load times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. 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 remove the IoT GUID column and retain the IoT ID column. Does this meet the goal?
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 change the IoT DateTime column to the Date data type. Does this meet the goal?
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 create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns. Does this meet the goal?
You have a Power BI data model that contains two tables named Sales and Date. The Sales table contains three measures named Order Quantity, Product Cost, and Sales Amount. You need to create the visual shown in the following exhibit.
In which section of the Fields well should you place the measures?
You have Power BI report that contains the fields 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.
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected?
You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?
HOTSPOT You have a report in Power BI Desktop. You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)
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:
Explanation: Box 1: adding more fields to Explain By Box 2: 3 0.30 instead of 0.10. A factor of 3 greater. moving fields from explain to expand should not add any new factors in analysis
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?
HOTSPOT You have a table that contains the following three columns:
City
✑ Total Sales
✑ Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
Box 1: Total Sales The key influencers visual helps you understand the factors that drive a metric you're interested in, here Total Sales. It analyses your data, ranks the factors that matter, and displays them as key influencers. Box 2: Occupation Measures and summarized columns are automatically analysed at the level of the Explain by fields used.
You are using the key influencers visual to identify which factors affect the quantity of items sold in an order. You add the following fields to the Explain By field:
✑ Customer Country
✑ Product Category
✑ Supplier Country
✑ Sales Employee
✑ Supplier Name
✑ Product Name
✑ Customer City
The key influencers visual returns the results shown in the following exhibit.
What can you identify from the visual?
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values in a slicer on one page, the selections are not persisted on other pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
You have a report that includes a card visualization. You need to apply the following conditional formatting to the card while minimizing design effort:
✑ For values that are greater than or equal to 100, the font of the data label must be dark red.
✑ For values that are less than 100, the font of the data label must be dark gray.
Which type of format should you use?
HOTSPOT You need to create a visual as shown in the following exhibit
The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only. How should you configure the visual? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area
Explanation: Box 1: Background color To apply conditional formatting, select a Table or Matrix visualization in Power BI Desktop. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply.
Box 2: Rules To format cell background or font color by rules, in the Format by field of the Background color or Font color dialog box, select Rules
You plan to create the chart shown in the following exhibit
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings. You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column. What should you do?
HOTSPOT You have a report page that contains the visuals shown in the following exhibit
Box 1: not affect
Box 2: cross-filter The map has the cross-filter icon active.
"You can only cross-filter line charts, scatter charts, and maps. You can't cross-highlight them" So Cross-filter for the map
You are creating a Power BI report by using Power BI Desktop. You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals. Which type of visual should you use?
In Power BI Desktop, you have a dataset that contains a table. You create a table visual on a Power BI report page as shown in the following exhibit
You need to configure the visual to display the referenced image instead of the URL in the Plant Image column. What should you do?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a constant line and set the value to .5. Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create an average line by using the Salary measure. Does this meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a percentile line by using the Salary measure and set the percentile to 50%. Does this meet the goal?
You have a Power BI report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?
HOTSPOT You have a dataset that contains revenue data from the past year. You need to use anomaly detection in Power BI to show anomalies in the dataset. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Explanation: Box 1: Line Anomaly detection is only supported for line chart visuals containing time series data in the Axis field. Box 2: Populate the axis with a date field Incorrect: * Anomaly Explanations doesn't work with 'Show Value As' options. * Drilling down to go to the next level in the hierarchy isn't supported. Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detectio
You have a line chart that shows the number of employees in a department over time. You need to see the total salary costs of the employees when you hover over a data point. What should you do?
You have the visual shown in the Original exhibit. (Click the Original tab.
You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)
What should you add to the visual?
You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit
Which type of visual should you use?
You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months. Which type of visualization should you use?
HOTSPOT You need to create a Power BI report. The first page of the report must contain the following two views:
✑ Sales By Postal Code
✑ Sales by Month
Both views must display a slicer to select a value for a field named Chain. The Sales By Postal Code view must display a map visual as shown in the following exhibit
The Sales By Month view must display a column chart visual as shown in the following exhibit
Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views. What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: 2 One for each visual. Note: When you edit a report in Power BI Desktop and the Power BI service, you can add report bookmarks to capture the current state of a report page. Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order, and so on. When others view your report, they can get back to that exact state by selecting your saved bookmark. Box 2: Display Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views. You can select whether each bookmark will apply Data properties, such as filters and slicers; Display properties, such as spotlight and its visibility; and Current page changes, which present the page that was visible when the bookmark was added. These capabilities are useful when you use bookmarks to switch between report views or selections of visuals, in which case you'd likely want to turn off data properties, so that filters aren't reset when users switch views by selecting a bookmark. Note: When you create a bookmark, the following elements are saved with the bookmark: The current page Filters Slicers, including slicer type (for example, dropdown or list) and slicer state Visual selection state (such as cross-highlight filters) Sort order Drill location
You have the visual shown in the exhibit. (Click the Exhibit tab.)
You need to show the relationship between Total Cost and Total Sales over time. What should you do?
You are building a Power BI report to analyze customer segments. You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort. Which type of visualization should you use?
You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
HOTSPOT You have a Power BI visual that uses indicators to show values that are out of range as shown in the following exhibit
Explanation: Box 1: a line Incorrect: * not line and clustered column The Line and Clustered Column Chart is a combo charts that combines the Line chart and Column chart together in one visual. By combining these two visuals together, you can make a very quick comparison between two sets of measures
Box 2: anomaly detection Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis. With just a couple of clicks, you can easily find insights without slicing and dicing the data. Example
You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?
HOTSPOT You are creating a line chart in a Power BI report as shown in the following exhibit
Explanation: Box 1: an average reference line With the Analytics pane in Power BI Desktop, you can add dynamic reference lines to visuals, and provide focus for important trends or insights. https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane Box 2: Axis The question is about drill-down and not drill-through. https://radacad.com/drill-down-and-up-in-power-bi-explained "For example, in the visual below I have Sales Amount as the Value of the column chart, and the Date field (Order Date) as the X-Axis. Date hierarchy in a Power BI visual This will lead to seeing drill down/up buttons on the top of the visual (or at the bottom of it if the visual is touched at the very top of the report)"
You have a Power BI report. The report contains a visual that shows gross sales by date. The visual has anomaly detection enabled. No anomalies are detected. You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do?
You have a Power BI report. You have a table named Data1 that contains 10 million rows. Data1 is used in the following visuals:
✑ A card that shows the number of records
✑ A bar chart that shows total transaction amount by territory
✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory
You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals. What should you do?
HOTSPOT You have a dataset named Pens that contains the following columns:
✑ Item
✑ Unit Price
✑ Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity. Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: A scatter plot of Quantity Ordered and Unit Price by item A scatter chart shows the relationship between two numerical values. Note: Scatter charts are a great choice: To show relationships between two numerical values. To plot two groups of numbers as one series of x and y coordinates. To use instead of a line chart when you want to change the scale of the horizontal axis. To turn the horizontal axis into a logarithmic scale. To display worksheet data that includes pairs or grouped sets of values. To show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers. To compare large numbers of data points without regard to time. The more data that you include in a Scatter chart, the better the comparisons that you can make. Box 2: Automatically find clusters Scatter charts are a great choice: * To show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers.
You have a Power BI report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?
You have a Power BI report that contains five pages. Pages 1 to 4 are visible and page 5 is hidden. CertyIQ You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report. What should you do first?
You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals:
• Switch the measures used in the visuals.
• Change the visualization type.
• Add a legend.
The solution must minimize development effort. What should you do?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure.
Does this meet the goal?
DRAG DROP CertyIQ You have a Power BI report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to 5. You need to format the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.
Which three actions should you perform in sequence in Power BI Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country. You need to ensure that when a user selects a country on page 1, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages. What should you do?
DRAG DROP You use Power BI Desktop to create a Power BI data model and a blank report. You need to add the Word Cloud visual shown in the following exhibit to the report.
The solution must minimize development effort. 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.
DRAG DROP You have a Power BI report that contains five bookmarks. CertyIQ You need to add an object to the report from which users can navigate between three specific bookmarks. How should you complete the task? To answer, drag the appropriate actions to the correct steps. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point
DRAG DROP You have a Power BI report that contains three pages. The pages are used to analyze sales across various countries. You add a slicer named Country to each page of the report.
You need to configure the report to meet the following requirements:
•When a user selects a country on the first page, the report must filter the other pages.
•The second and third pages must display only the filtered results.
Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point
You have a Power BI report that contains a page. The page contains the following:
•A shape named Shape1
•A card named Sales Summary
•A clustered bar chart named Sales by Region
You need to ensure that Sales Summary renders on top of Shape1. What should you modify?
In Power BI Desktop, you are creating a report that will contain three pages. You need to create a custom tooltip page and prepare the page for use. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You have a Power BI report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What should you do?
You need to create a visual that compares profit across 10 product categories fora selected quarter. What is the best visual to use to achieve the goal?
You have a Power BI report that contains a visual. The visual contains a measure. You need to ensure that the report meets the following requirements:
•All values must be set to two decimal places.
•All negative values must be displayed in red font and parentheses.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
HOTSPOT You have a Power BI report that contains a page. The page contains the following visuals:
•A card
•A matrix
•A bar chart
You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix. The card and the bar chart must change when a user selects a cell in the matrix. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point
You have a Power BI dataset that contains quarterly sales performance data. You need to enable managers to review the data in a format that meets the following requirements:
•Is optimized for printing.
•Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.
What should you create?
You have a Power BI report that contains the visuals shown in the following table
You need to modify the location of each visual. What should you modify for each visual?
You have a Power BI report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report that will enable users to filter the sales data to include only a selected region. Which two elements achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
DRAG DROP You plan to use Power BI to create a quarterly profit report that meets the following requirements:
•Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
•Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point
Last changeda month ago
