- (Exam Topic 4)
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?
Correct Answer:
C
DirectQuery: No data is imported or copied into Power BI Desktop.
Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data.
Benefits of using DirectQuery
There are a few benefits to using DirectQuery:
DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation. Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data.
The 1-GB dataset limitation doesn't apply to DirectQuery. Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
- (Exam Topic 4)
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
Graphical user interface, text Description automatically generated with medium confidence
Box 1: Append Queries as New.
There are two primary ways of combining queries: merging and appending. When you have one or more columns that you’d like to add to another query, you merge the queries. When you have additional rows of data that you’d like to add to an existing query, you append the query.
Box 2: Disable loading the query to the data model
For every query that loads into model memory will be consumed. and Memory is our asset in the Model, less memory consumption leads to better performance in most of the cases. The best approach is to disable loading.
Reference:
https://docs.microsoft.com/en-us/power-query/append-queries
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 4)
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID 
Customer City Customer State Customer Name Customer Address 1 Customer Address 2 Customer Postal Code
The Invoice table contains the following fields: Order ID Invoice ID Invoice Date Customer ID Total Amount Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information: The number of customers invoiced in each state last month The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Solution:
Box 1: One-to-many
A customer can have many invoices within one month. Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 4)
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
Correct Answer:
B
You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to: Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh. Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly. Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that
have been certified.
Email subscriptions don't support R-powered custom visuals at this time. Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
- (Exam Topic 2)
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Solution:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions
Does this meet the goal?
Correct Answer:
A
