259 Teil 6: Performance and Visuals

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

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

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

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

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

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

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

1. 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 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? A. ribbon chart B. scatter chart C. line chart D. key influencers

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?