Topic 4, Misc. Questions
You are configuring a Microsoft Power Bl data model to enable users to ask natural
language questions by using Q&A. You have a table named Customer that has the
following measure.
Customer Count = DISTINCTCOUNT(Customer[CustomerID])
Users frequently refer to customers as subscribers.
You need to ensure that the users can get a useful result for "subscriber count" by using
Q&A. The solution must minimize the size of the model.
What should you do?
A.
Add a description of "subscriber count" to the Customer Count measure.
B.
Set Summarize By to None for the CustomerlD column.
C.
Add a description of "Subscriber" to the Customer table.
D.
Add a synonym of "subscriber" to the Customer table.
Set Summarize By to None for the CustomerlD column.
Explanation:
You can add synonyms to tables and columns.
Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users
often have a variety of terms they use to refer to the same thing, such as total sales, net
sales, total net sales. You can add these synonyms to tables and columns in the Power BI
model.This step applies specifically to Q&A (and not to Power BI reports in general). Users often
have a variety of terms they use to refer to the same thing, such as total sales, net sales,
total net sales. You can add these synonyms to tables and columns in the Power BI model.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices
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?
A.
Change any DAX measures to use iterator functions.
B.
Replace the default visuals with AppSource visuals.
C.
Change the imported dataset to DirectQuery.
D.
Remove unused columns from tables in the data model.
Change the imported dataset to DirectQuery.
Explanation:
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
You publish a report to a workspace named Customer Services. The report identifies
customers that have potential data quality issues that must be investigated by the customer
services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel
based on the data.
Which report setting should you configure?
A.
Don't allow end user to save filters on this report.
B.
Change default visual interaction from cross highlighting to cross filtering.
C.
Enable the updated filter pane, and show filters in the visual header for this report.
D.
Allow users to add comments to this report.
E.
Choose the type of data you allow your end users to export.
Choose the type of data you allow your end users to export.
Explanation: https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-theservice/
You open powerbi.com as shown in the following exhibit.
In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured You need to create a relationship between the tables. The solution must ensure that
bidirectional cross-filtering honors the RLS settings.
What should you do?
A.
Create an active relationship between the tables and select Assume referential integrity.
B.
Create an inactive relationship between the tables and select Assume referential
integrity.
C.
Create an inactive relationship between the tables and select Apply security filter in both
directions.
D.
Create an active relationship between the tables and select Apply security filter in both
directions.
Create an active relationship between the tables and select Apply security filter in both
directions.
Explanation:
By default, row-level security filtering uses single-directional filters, whether the
relationships are set to single direction or bi-directional. You can manually enable bidirectional
cross-filtering with row-level security by selecting the relationship and checking
the Apply security filter in both directions checkbox. Select this option when you've also
implemented dynamic row-level security at the server level, where row-level security is
based on username or login ID.
Graphical user interface, application, Word
Description automatically generated
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
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 create a parameter named DataSourceExcel that holds the file name and location of a
Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded
copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?
A.
Yes
B.
No
No
Explanation:
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From
connecting to different data sources defined in Query Parameters to load different
combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.
You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?
A.
Add a duplicate query named Airline.
B.
Add airline as a synonym of carrier.
C.
Rename the carrier column as airline in the Carriers query.
D.
Rename the query from Carriers to airlines.
Add airline as a synonym of carrier.
Explanation:
Add synonyms to tables and columns: This step applies specifically to Q&A (and not to
Power BI reports in general). Users often have a variety of terms they use to refer to the
same thing, such as total sales, net sales, total net sales. You can add these synonyms to
tables and columns in the Power BI model.
This step can be important. Even with straightforward table and column names, users of
Q&A ask questions using the vocabulary that first comes to them. They're not choosing
from a predefined list of columns. The more sensible synonyms you add, the better your
users' experience is with your report.
Reference:
https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices
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.
A.
Add the same slicer to each page and configure Sync slicers.
B.
Edit the interactions of the KPI visualization.
C.
Configure a page-level filter.
D.
Edit the interactions of the slicer that is on the same page as the KPI visualization.
E.
Configure a report-level filter.
Add the same slicer to each page and configure Sync slicers.
Edit the interactions of the slicer that is on the same page as the KPI visualization.
Explanation:
Slicers are another way of filtering. They narrow the portion of the dataset that is shown in
the other report visualizations.
By default, slicers on report pages affect all the other visualizations on that page, including
each other. Use visual interactions to exclude some page visualizations from being affected
by others.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName
value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
A.
From Power BI Desktop, create a new role that has the following
filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”
B.
Add the following filters in Query Editor.CountryRegionName is United
StatesProductCategory is Clothing
C.
From Power BI Desktop, create a new role that has the following
filters.[CountryRegionName]= “United States”
D.
Add the following filters to a report.CountryRegionName is United
SatesProductCategory is Clothing
Add the following filters to a report.CountryRegionName is United
SatesProductCategory is Clothing
References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter
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.
| Page 7 out of 29 Pages |
| Previous |
Copyright © - All Rights Reserved