DA100 - Practice Questions
What are 3 ways to get app access? How about for external users?
3 ways to get app access: install through AppSource, receive a direct link, (applies to external users) automatically install via admin permission.
What are 2 ways to filter all visuals on all pages at the same time?
Adding a report level filter for Country will filter all visuals on all pages. The Sync slicers feature allows slicers on separate report pages to be synchronized so when a slicer is changed on one page, the slicer is changed on the other pages simultaneously. By adding slicers for Country on each page and configuring Sync slicers, the visuals on all pages will be filtered whenever a country is selected on any page.
How long are user questions stored to review for the Q&A feature?
Adjectives like Hot, are used as filter conditions. You can review questions asked by users for up to 28 days. The questions are stored against your data model for 28 days. You can use these questions to add suggestions and create new terms to help users with the Q&A feature.
An app is the creation of official ___ content. Does it make managing permissions easier?
An app is the creation of official packaged content. Managing permissions is easier with apps.
With a Power BI Premium license, you have the ability to share Power BI content with ___.
Anyone, even external folks, without purchasing a per-user license. Otherwise external users would need a Pro license to view shared content.
When data is exported from Power BI to excel, powerpoint or pdf, how can you ensure sensitive data remains encrypted?
Apply a sensitivity label. When data is exported from Power BI to Excel, PowerPoint, or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label's file encryption settings.
What security service prevents information from flowing over into the public internet?
Azure ExpressRoute extends on-premise networks into the cloud over a private connection.
What data source allows you to display live data using DirectQuery connection mode?
Azure SQL Database
Background colors for tiles can only be set in ____ themes, which only work with tiles pinned from reports and not ____. In dashboard theme, you can modify the tile ___, ___ and _____.
Background colors for tiles can only be set in dashboard themes. You can specify the tile background color, the tile font color, and the tile opacity. The dashboard themes only work with tiles pinned from reports. Dashboards created from pinning a live page do not use the dashboard theme.
Can background images be set in both dashboard and report themes? A report theme is based on what type of coding language?
Background images can be set in both dashboard and report themes. In a dashboard theme, you can upload an image file. For a report theme, you must edit the theme JSON file and add a base64-encoded string for the image.
[az] By default PowerQuery examines the first ____ rows.
By default, you can use Power Query to examine the first 1000 rows of your dataset, not the first 500 rows.
What are the 3 visuals that can be configured for data alerts?
Card, gauge and KPI. Data alerts are only available from the Power Bl service.
Changes you make to the workbook in Power BI are not ____.
Changes you make to the workbook in Power BI are not saved and do not affect the original workbook on OneDrive for Business. If you need to make changes that will be saved, select Edit from the upper-right corner to open it for editing in Excel Online or Excel.
[re] Many-to-many relationships are necessary when both tables are not unique and you need to filter on ____.
Changing the relationship to many-to-many is required when the rows in both tables are not unique and you need to filter on values in the tables.
In order to make sure a table contains no duplicates, what 2 methods can you use?
Click on Remove Duplicates on the table columns Add an Index column to the table making all rows unique
[az] Column profile shows the ____ and ____ of data in a column. It also shows ___ or ___ values for the selected column.
Column profile is an option in Power Query that shows the statistics and distribution of data in a column. Column profile allows you to analyze value distribution along with distinct, unique, empty or error values for the selected column.
[az] Column quality shows the number and percentage of ___, ___, and ___ values in a column. Column quality and column ___ check for ___ or ___ values.
Column quality is an option in Power Query that shows the number and percentage of valid, error, and empty values in a column. You can use the Column quality and Column profile options to check empty or error values.
[ds] What 2 storage modes are available for multidimensional data sources, like Analysis Services? You should use ____ with relational data sources, like SQL Server.
Connect live is used when connecting to multidimensional data sources, such as Analysis Services. Connect live is one of the two options available when connecting to Azure Analysis Services in Power Bl Desktop. You should not use DirectQuery. This storage mode is not available for Analysis Services. You use DirectQuery with relational data sources such as SQL Server.
What are the 3 operations you can do with Power BI Rest APIs?
Create a dataset, add rows to a dataset, and refresh an imported dataset. (aka 'Push data') You cannot retrieve rows from a dataset
How do you ensure that when printing a report, all data in a table will be displayed and not just the current view?
Create a paginated report. Paginated reports are designed to be printed or shared. They're called paginated because they're formatted to fit well on a page. They display all the data in a table, even if the table spans multiple pages. Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
When you unpublish an app, app users lose their _____ such as ____, ____, and _____.
Customizations, such as, personal bookmarks, comments, or subscriptions
You can use ____ to create visuals using JavaScript.
D3 is a JavaScript library for creating visuals. D3 is supported in Power Bl by adding a custom visualization from AppSource.
What does dashboard tile flow do?
Dashboard tile flow aligns all visuals to the top left corner of the dashboard. It has no effect on how the tiles are rendered on a mobile device.
T/F: Data classifications are defined at the tenant level.
Data classification must be enabled for the tenant in the Admin Portal. Once you enable the feature, you can define the data classifications. One of the classifications must be set as the default classification. All existing dashboards will have the default classification defined. True.
T/F: Data classifications are defined at the tenant level. ?
Data classifications apply to the entire organization and cannot be limited to specific groups. You cannot restrict a dashboard based on membership of an Azure AD security group. False
[tf] When creating a relationship between fields, they should have the same _____.
Data types on fields that are used in relationships must have the same data type.
In premium capacity, the ________ tool enables BI creators to develop and test content before releasing to production. It helps manage the lifecycle of organizational content to ensure standardization in creation and sharing.
Deployment pipelines
[ds] In _____ storage mode, no data is imported into PBI and visualizations automatically refresh with each interaction.
DirectQuery — No data is imported to Power Bl Desktop. As you create or interact with a visualization, Power Bl Desktop queries the underlying data source, i.e. you're always viewing current data. DirectQuery does not cache data but instead executes a query against the data source to return the data. DirectQuery should be used on tables with large amounts of data where you need to ensure that you are viewing the most up-to-date data.v
In order to use R scripting in Power BI, you must first download ___.
Download Microsoft R. Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It is a complete open source platform for statistical analysis and data science.
When giving access permissions in the App, you can give access to specific users, groups or ______. Users/groups with access to the ____ automatically have access to the app.
Entire organization workspace
To show the proportion of Sales for a selected segment you should set the interaction behavior to _____.
Filters remove all but the data you want to focus on. Highlighting is not filtering. It does not remove data, but instead highlights the data you want to focus on, with the other data still visible but dimmed. By highlighting you can see the proportion of the product sales for the segment.
What page view types are available in Power BI Report View?
Fit to page, fit to width and actual size. Full screen is not an option.
If users get an error message stating the company has turned off signup for Power BI, you need to run the ______
From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet. Set-MsolCompanySettings cmdlet sets company-level configuration settings.
[cn] What can you accomplish with a data gateway?
Gateway is used to refresh the data from on-premises servers to online Power BI Service.
[tf] Power Query emphasizes making changes using which of the following?
Graphical user interface (GUI)
Performance: Hidden columns cannot be ______. Do they reduce the size and improve performance of the model?
Hidden columns are not searched when using Power Bl. However, a hidden column is still processed. Hiding a column does not reduce the size of the model or improve performance.
In the new filter pane menu, you can ___ and ___ specific filters for consumers. And in the option > report settings, you can disable the ____ for the Filters pane.
Hide specific filters from report consumers. Lock specific filters so report consumers cannot edit them. You can disable the search for the Filters pane from settings: Options > Report Settings > Uncheck [Enable search for the filter pane] option. By default, search for the Filters pane is enabled.
In mobile layout view, you can ___, ___ and ___ visuals. Only include important visuals to optimize the report for mobile. You can also resize ___ and make them ___, meaning they will resize automatically.
In Power Bl desktop, you can switch to the mobile layout view of a report page. In this view, you can add and remove visuals from the report to the mobile canvas. You can also resize the visuals. You should only include important visuals in the mobile layout to optimize the report for mobile devices. Additionally, you can resize slicers and make a slicer responsive so that it will resize automatically in the mobile app.
In an App, where can you add a link to an external resource?
In the Navigation pane, Using the New option to add a link to an external resource to the nav pane.
In order to create a Hierarchy, all the involved columns need to be ____
In the same table
Viewers can only ___ with reports.
Interact
Two visuals have help identify possible causes for data anomalies is ____ and ___.
Key Influencer and Decomposition tree visuals
[ds] Live Connection is used when connecting to ________ data sources, such as Analysis Services
Live Connection is used when connecting to multidimensional data sources, such as Analysis Services
What connection mode is not support by Publish to Web? What datasets are not supported?
Live connection, shared and certified datasets
____ and ___ roles can create, delete and publish content to the workspace.
Members and contributors
Can Contributor roles publish apps?
No
Does publish to web support RLS?
No
Is exporting data or shared reports supported in Publish to Web?
No
Do dashboards support the Drill Down feature?
No. The Drill Down feature is not currently available for dashboards experience. You have to share the data as a report with your colleagues.
If I created a live connection, can I connect to another type of data source in the same Power BI Desktop file?
No. You can't explore live data and connect to another type of data source in the same file. If you've already imported data or connected to a different data source in a Power BI Desktop file, you need to create a new file to explore live.
Does removing access to an app automatically remove the person's build and reshare permissions? Users with build permission also can ____ reports. Users with the Viewer role that have build permission can ____ data.
No. You must remove the user from the manager permissions option in Datasets. App users can be given Build Permission allowing them to search for shared datasets. Users with Build permission can also have permission to copy reports from this app to another workspace. Even users with the Viewer role in the new workspace can export data if they have Build permission on the datasets in that workspace.
You plan to create a custom visualization for Power BI. What do you install first?
Node.js. The language you use to create a custom visual is JavaScript. Node.js is an open-source, cross-platform, back-end JavaScript runtime environment that runs on the V8 engine and executes JavaScript code outside a web browser.
[ds] Visuals that refer to the DirectQuery table always show the latest values in the _______. How is this different from calculated tables?
Normally, calculated tables always show the data when the dataset is refreshed, but if the calculated table refers to a DirectQuery table, visuals that refer to the DirectQuery table always show the latest values in the underlying source, the data warehouse.
In _____ admin center, you can manage members that have access to the app workspace, by modifying _____.
Office 365 Admin center, clicking Groups
PATH and PATHITEM functions generate ___ to flatten a parent-child hierarchy.
PATH and PATHITEM are functions that generate calculated columns to flatten a parent-child hierarchy. The calculated columns can then be used to create a fixed-level hierarchy for use with visualizations.
Parameters are used as ______ parameters with datasets or as ___ variables on reports. They are not created when defining ___.
Parameters are used as query parameters with datasets or as what-if variables on reports. Parameters are not created when defining RLS roles.
What's the difference between using ALL() vs REMOVEFILTERS()?
Percentage of Sales = DIVIDE(SUM(RegionalSales[Sales]), CALCULATE(SUM(RegionalSales[Sales]), REMOVEFILTERS())) The REMOVEFILTERS function removes all filters in the context so the grand total is used to calculate the percentages for the country and region rows.
A Power BI ___ license is required in order to us AutoML. Data is prepped for machine learning using ____.
Power BI Premium. Dataflows.
You can prevent users from adding custom visuals from Microsoft AppSource by disabling the Allow visuals created using the Power BI ____ option in the ___ settings of the Power BI ____
Power Bl SDK option in the tenant settings of the Power Bl service.
Power BI Report Server is available with a Power BI ____ license. It does not support ___ or ___ visuals.
Premium license. R or Python script visuals.
What 3 type of visuals are not supports by Publish to Web?
Q&A, Python and R visuals
Query Diagnostics is used to determine the ____ that occurs in ___.
Query Diagnostics is used to determine the processing that occurs in Power Query. Query Diagnostics does not identify poorly performing visuals.
[az] ______ reflects the structure and hierarchy of tables in graphical format.
Query dependency reflects the structure and hierarchy of tables in graphical format.
What is the row limit for R visuals? Does R aggregate similar data automatically? R visuals are supported in ___ but not supported with ____.
R visuals are limited to 150,000 rows. If there are more than 150,000 rows, only the top 150,000 rows are displayed and a message is displayed on the image. R aggregates similar data automatically, but there must still be less than 150,000 data points for the R visual to display data. If the data is unique, it will be displayed for R visuals. R visuals group data by default, and duplicate rows are not displayed. R visuals are supported in Power Bl apps. R visuals are not supported with Publish to Web.
What is the first operation to do to optimize data loading performance?
Remove unnecessary columns and rows.
In conditional formatting, what are the 3 Format by options?
Rules, Field value and color scale. You should not use the field value in the Format by field. This allows you to choose formatting from an already defined field in your model, which you can use for a color scheme.
How do you use the USERELATIONSHIP(___,___) function?
Sales_by_Shipping_Date = CALCULATE( SUM(Orders[Price]), USERELATIONSHIP(Orders[ShippingDate], Date[Date]))
[cn] What does Selected Related Tables do?
Select related tables will import all other tables that have a physical relation with this table.
In a Line and Clustered Column Chart, in order to create consistency between the 2 scale values, set the Y-axis start and end settings to ____.
Set to Auto the Y-axis 'start' and 'end' settings
Setting the interaction behavior to ___ means that a visual is not affect by any selection on another visual
Setting the interaction behavior to None will not filter the Sales by Segment chart when a column in the Sales by Product visual is clicked. Setting the interaction behavior to None means that a visual is not affected by any selection on the other visual.
Personal mode is for a single user and cant be______. Good for scenarios where you are the only person who creates reports.
Shared with others
You create streaming datasets in the _______ in Power BI _____.
Streaming datasets are created in the Power Bl service. Unlike other datasets, there is no schema to read in streaming data from an external source. You create the streaming dataset in the workspace in the Power Bl service.
____ is the most effective technique to reduce model size and improve performance.
Summarizing data is the most effective technique to reduce model size and improve performance.
As opposed to Text.Replace, _______ replaces an existing value with a new value in the specified columns of a table.
Table.ReplaceValue
What are the 5 types of tiles you can add to a dashboard?
Text Box, Image, Video, Web Content and Custom Streaming Data
To create a calendar by defining the start of the fiscal year in May, would you use the CALENDAR() or CALENDARAUTO() function? What would be the input argument?
The CALENDARAUTO() function allows you to define custom fiscal year. Your company requirement is to define a fiscal year that starts from May. You should use the CALENDARAUTO() function to automatically create the common date table for the data model. This DAX function creates the date table based on the minimum and maximum available dates in a data model. You can provide 4 as an argument to this function to end the fiscal year in April and start the new fiscal year from May to meet the requirements. You should not use the CALENDAR() function. This DAX function allows you to create a date table based on the start and end date provided as an argument. The CALENDAR() function does not provide the ability to define custom fiscal years. The following is the syntax for the CALENDAR() function: Date = CALENDAR(startdate, enddate)
[cn] Does Common Data Service support Query folding?
The Common Data Service does not support Query folding. The View Native Query option will always be disabled when using the Common Data Service connector. Some transformations will prevent query folding. Adding a conditional column as a step to Query Settings in Power Query will not prevent query folding. Defining measures in Power BI does not affect query folding. Measures are typically aggregations and are calculated at the time of the request.
[ds] Data connectivity mode is used to set the storage mode to ____ or ____ Query.
The Data connectivity mode is the option you can use when connecting to data to set the storage mode as Import or Direct Query.
[tf] A dimension column should have ____ values. Labels should not
The DeviceType column cannot be used as a dimension. The DeviceType column has unique values, but two of the labels are Laptop. This is probably because there are spaces on one of the Laptop labels. You must cleanse the column to remove spaces, or use Replace Values, before you can use it as a dimension.
[cn] A primary key should have the same ___ and ___ counts.
The DevicelD column is a candidate for the primary key for this table. When the distinct and unique counts are the same, the column contains unique values. The DevicelD column can be used as the primary key for this table.
[ds] Use DirectQuery when changes to the table need to be ___. In the DirectQuery method, queries are directly sent to the _____.
The DirectQuery method is preferred when you have a huge volume of data consisting of millions of rows. It is also useful in cases where any changes to the table need to be reflected immediately in the data model or report. In the DirectQuery method, queries are directly sent to the underlying data source.
[tf] You need to replace the Excel workbook with a new version that contains updated data. Must the new workbook have the same structure as the original?
The Excel workbook must have the same structure as the original file. If the columns are different either with more columns, fewer columns, or differently named columns, this will break the report.
[ds] The Import method is preferred when you have ____or _____rows with a low volume of data, meaning a few ____ rows. In the import method, data is ____ into PowerBI.
The Import method is preferred when you have fixed or static rows with a low volume of data, meaning a few thousand rows that are updated infrequently. In the Import method, data is cached into Power Bl.
[tf] Using Merge Queries what 2 join types can you perform?
The Merge Queries method performs an operation similar to a JOIN in SQL. You can specify whether the merge performs an inner or an outer Join.
If you wanted to compare sales from July 2020, what would PARALLELPERIOD() return vs SAMEPERIODLASTYEAR()? Which one is use for dynamic periods and the other static periods?
The PARALLELPERIOD() function cannot work with a dynamic period. If you compare sales from July 2020, it will return all of 2019 because it uses a static period. Instead, you can use SAMEPERIODLASTYEAR() function or DATEADD() The DAX SAMEPERIODLASTYEAR function evaluates dynamically the period for the previous year. The SAMEPERIODLASTYEAR generates a date range shifted one year from the dates in the date field. If you are aggregating or filtering your data by a date period, SAMEPERIODLASTYEAR generates a date range for the corresponding dates in the previous year.
The Page navigation action type is supported for buttons, ____ and ____.
The Page navigation Action type is supported for shapes and images, not just buttons. When you use the Page navigation Action type, you select the Report page you wish to navigate to as the destination page. Clicking on the image will navigate to the Report page associated with the image.
[ds] What is a Power BI service live connection?
The Power Bl Desktop can connect to datasets in the Power Bl service that have been shared or published. This is called Power Bl service live connection. You can then build your own reports based on this dataset and publish those reports to the Power BI service.
What the difference in where the Q&A visual is placed between adding Q&A in a report vs a dashboard?
The Q&A visual would be added to the report canvas and shown in the report and dashboard, not above all the visuals in the dashboard.
What are the steps to creating an aggregation table in DirectQuery mode?
The Telemetry table is set to DirectQuery storage mode. You need to create aggregations for date, devicetype, readingtype, and readingvalue. 1. Create a new table named Telemetry_Aggregate containing the columns to hold aggregate data. 2. Select the Telemetry table and select Manage aggregations. 3. Select the Telemetry_Aggregate table as the aggregation table. 4. Select the Summarization type. 5. Select the table and column from the Telemetry table.
[pf] The View Native Query option in Power Query is disabled if ____ is not possible based on the ____ or ____ you applied.
The View Native Query option in Power Query is disabled if Query folding is not possible for the data source and transformation steps you have specified. Query folding improves performance by using native queries against the data source.
The addition of two different RLS filters allows the member of both of them to see data for ___ and not just the ___ of them.
The addition of two different RLS filters allows the member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their intersection. (I.e. The member will see all the data that have ''USA'' as Store[State] or ''T-shirts'' as Product[ProductName].)
T/F: The data classification for a dashboard is always displayed.
The data classification for a dashboard is only displayed if the administrator has checked the Show Tag option for the classification that the dashboard has been assigned to. If Show Tag is not checked, data classification is not visible to users of the dashboard. False
[ds] Your company moved from a self-service approach to an increasingly centralized approach. The IT team created a SQL Server Analysis Server (SSAS) for you to use. When using live connections for SSAS, why might the Relationships view disappear in Power BI?
The model's relationships are managed in SSAS, not in PowerBI Desktop
What is the file size limit for importing a dataset into Power BI Service?
There's a 1-GB limit for datasets stored in Shared capacities in the Power BI service.
Performance: Does removing unnecessary columns from the data model improve performance?
This solution meets the goal. Removing unnecessary columns from the data model will reduce the model size and improve the time taken to refresh the model. You should remove columns that are not used in reports and not used in model structure or calculations. This is vertical filtering.
Which properties of a tile can be edited in the Power Bl dashboard from the Tile details window?
Title, subtitle and destination link
Real-time data visual is added to a dashboard by selecting the ___ data tile.
To add the real-time data visual, you use the Add tile menu option in the dashboard, select the Custom Streaming Data tile, and then select the streaming dataset. Power Bl can be an output from Azure Stream Analytics to visualize real-time streaming data.
To change how other visuals interact with your chosen visual, which visual do you select and how is the interaction behavior changed?
To change how other visuals interact with a visual of your choice, you should select that visual and then change the interaction behavior on the rest of the visuals. To make the Sales by Product visual show the portion of the segment selected in the Pie chart, you should select the Sales by Segment pie chart and then edit the interactions on the Sales by Product chart. You should set the interaction behavior to either filter or highlight.
In order to enable "Apply security filter in both directions" you must first set the ___ to ___.
To fix the relationship between the Employee and Region table so RLS can work, you need to perform the following two tasks: 1. Set the Cross filter direction option to Both. 2. Select Apply security filter in both directions. By setting the Cross filter direction option to Both, you allow filters and the slicer to propagate in both directions. You can filter results based on any attribute of The Employee or Region table. It also enables you to select Apply security filter in both directions. This will propagate RLS filters to tables. Setting Cross filter direction to Single would not allow you to propagate RLS filters to the tables.
Using ____ mode, user interactions with visuals cause _____ to be submitted to the data source every time the user clicks the visual. In order to improve performance, you could switch off _____.
Users complain of performance issues when using visuals on the Power Bl report. You should switch off interactions between visuals. Cross-highlighting and cross-filtering interactions causes queries to be submitted to the data source every time a user clicks on a visual when DirectQuery is used. You should disable interactions either at the report level or for each visual to solve the performance issues that users are reporting.
On-premise data gateway allows for multiple ____ to connect to _______ on-premise data sources, a single gateway that supports all services.
Users, multiple
[pf] Variables in measures are efficient because they reduce ____, which reduces _____ time.
Variables make measures more efficient because they remove the need to evaluate the same expression twice, reducing processing time.
[ds] Refresh is not supported for Excel workbooks imported from a_______. The latest data for this will be when the workbook was last loaded.
Visuals referring to the Product Managers table show the values from when the workbook was last loaded. Refresh is not supported for Excel workbooks imported from a local drive. If you need Excel data to be updated when the dataset is refreshed, you should move the worksheet to OneDrive for Business or install the Power BI On-Premises Gateway.
[cn] What feature allows you to navigate HTML tags to get website data?
Web Scraping is the new feature of Power bi that allows navigating through HTML tags to get data from the website.
When an alert rule is triggered on a dashboard tile, what 2 actions can the trigger perform?
When an alert rule is triggered, a notification is created that is visible in the notification center in Power Bl. Alerts can optionally be sent by email. A Power Automate flow can also be triggered by a Power Bl alert.
What's the difference between connecting live to a tabular model from the Power BI service versus connecting live from Power BI Desktop?
When connecting live to a tabular model from your site in the Power BI service to an Analysis Services database on-premises in your organization, an on-premises data gateway is required to secure communications between them. When connecting live to a tabular model from Power BI Desktop, a gateway isn't required because the Power BI Desktop and the Analysis Services server you're connecting to are both running on-premises in your organization. However, if you publish your Power BI Desktop file to your Power BI site, a gateway is required.
By default, which filter level behaves the same as a slicer in a report in PBI Desktop?
When you create a slicer in a report, the slicer will filter the visualizations on the current page, similar to page level filter.
When you use the Pivot feature, you have to take care of the ____ Value Functions displayed in the ______options
When you use the Pivot feature, you have to take care of the Aggregate Value Functions displayed in the Advanced options
By default, in the Power Bl mobile, all tiles on a dashboard appear the same ___ and as a ____.
When you view a dashboard in portrait mode on a phone, by default the tiles are laid out one after another in a vertical list. All tiles are the same size.
Admins can add/remove people and delete the _____
Workspace
Can Power BI Free license users access a published Power BI app?
Yes
Can you pin an Excel table in a Power BI dashboard as a tile from Excel?
Yes, from the Power BI tab in Excel you can pin a table
[ds] Would you be able to import data from Power Bl Service online using Get Data Power Bl dataset ?
Yes, if you select this option it will show you all workspace you are member of. You can import dataset from any workspace.
Where do you go to add synonyms to the Q&A? In Power BI ___ in the ___ tab's _____ pane.
You add Q&A synonyms in Power BI Desktop in the Modeling tab's Properties pane.
[dx] To define what rows are available for each role, what language (DAX or M) do you use to filter for RLS roles?
You are configuring row level security (RLS) roles for a Power Bl report. You need to define which rows are available when creating a role. You should create a DAX expression to use as a filter for the RLS role. The expression will return true or false for records, and this determines which rows in the dataset are displayed for the user's role. You should not use Power Query and create an M expression. The M language is the data transformation language of Power Query. M is not used with RLS roles.
[pf] Use ___ to identify PowerBI report performance issues. It allows you to diagnose ___ performance and ____ included in it.
You can also use Query Diagnostics to identify Power Bl report performance issues. Query Diagnostics allows you to diagnose query performance and transformations included in it. A query could have multiple steps. A step could be a transformation or a simple query.
[az] Can you use Data Preview to analyze the entire dataset?
You can change the data preview to analyze the entire dataset. To change the number of rows analyzed, select the profiling status in the status bar and select Column profiling based on the entire data set.
[ds] When changing an Excel data source does it need to retain the same folder and filepath as the original?
You can change the file path for an Excel file in Data source settings in Power Bl Desktop. The file can be in a different folder on your local computer and can have a different name.
Will creating a phone view for a dashboard affect the web view? In the phone view, you can __, ___, and ___ visuals. Without affecting the ___ view.
You can create a Phone view for a dashboard. In this view you can resize, rearrange, and hide the visuals without affecting the web view.
Is there a limit of the number of date tables you can have? A date table must have a column with a _____. In order to make a table as a date table, the date field must be ___ and must not have _____.
You can create two tables for order date and ship date and mark both tables as date tables. There is no limit on the number of tables you can mark as date tables. A date table must have a column with the Date data type. You cannot mark the table named Sales as a date table. To mark a table as a date table, the date field must be unique and must not have any missing dates.
Where can you disable or prevent reports from being Publish to Web ?
You can disable it in Power BI Admin portal
By embedding a ____ Power App, users can perform actions within Power BI reports and dashboard.
You can embed a Canvas Power App in a Power Bl report using the Power Apps visual. The Power App can interact with the data in the report and with the other visuals. Users can use the Power App to perform actions from within Power Bl reports and dashboards.
When asked to create a measure, pay attention to whether all columns are in the same table
You can simply create a measure using the FILTER function since all columns you need are in the same table.
To Share feedback on visuals with other users, what feature would you use?
You can use the Comments feature to be added to the report page and to visuals on a page. Comments are added by users to provide feedback or bring other users' attention to a visual and are available in the Power Bl service.
Where can you show and hide visuals on a report page?
You can use the Selection pane to determine which items on a report page are visible and which items are hidden. The selections are stored in bookmarks.
You can use the Teach Q&A functionality on datasets with a storage mode of ____. This mode supports many PBI features including quick ______.
You can use the Teach Q&A functionality on datasets with a storage mode of Import. Import mode supports many Power Bl features such as Q&A and Quick insights. You can refine Q&A by examining the questions asked by users in Power Bl Desktop and then publish the report to the Power Bl service.
You cannot teach Q&A ___. You can only teach___ and ___ . ___ is used for commonly used terms.
You cannot teach Q&A verbs such as Overload. You can only teach Q&A nouns and adjectives. Nouns, like SKU, Work order and Rating, are used as synonyms for terms commonly used in your organization.
In Q&A, do you need to create a measure to be able to use aggregations? What if you need more than one condition?
You do not need to create measures to be able to use the aggregations. You can define an aggregation such as "sum of" in the Q&A expression. You can define the 'sum of work orders > 1000' as 'high workload'. If you need more than one condition, you will need to create a measure with DAX and use the measure in the condition.
Where do you enable Q&A and add a featured question?
You enable Q&A in Power BI Service on the dataset and you can add a featured question.
Is Q&A available for dashboards? How is it enabled?
You must enable Q&A in the settings for the dashboard. This option shows the Q&A search box at the top of the dashboard.
In PowerBI report, what tab can Q&A be setup and where synonyms are added for tables and columns?
You should add synonyms to the table and its columns in the Modeling tab. In Q&A, users ask questions using their own terminology and do not choose from a list of predefined tables and columns. You can add synonyms so that Power Bl can identify the tables and columns when using Q&A.
[tf] In order to correct inconsistent data, use the _____ transformation.
You should apply the Replace Values transform on the Country column to change the country names so that they are consistent.
Users can export data from visuals if they have ___ level permission on a workspace or if they have ____ permission, which does not require them to be granted access to the _____.
You should grant HR users the Build permission on the dataset. You can export data from a visual in a dashboard to a CSV file. If you have filtered the visualization, then the .csv export will also be filtered. Users require the Build permission to export the underlying data of the visual to work with it outside Power Bl. If a user has Read permission on a workspace and dataset, they can export the data. Build permission allows you to control whether users can download data from visuals without having to give access to the workspace.
[pf] Do bi-directional relationships impact performance?
You should not change the cross filter directions on both relationships to Both. Bi-directional relationships require more processing and can negatively impact on performance.
___ allows users to share a dashboard or a report. It does not allow you to export data from Power BI.
You should not grant HR users the Reshare permission on the dataset. Reshare allows users to share a dashboard or a report. Reshare does not allow you to export data from Power Bl. What are sensitivity labels? Cloud App Security allows you to monitor Power Bl for user access and activity. Cloud App Security will prevent data from being exported to devices that do not meet your Azure Active Directory conditional access policies.
[tf] Will the Remove Errors transformation result in losing any data?
You should not use Remove Errors to fix the step-level error. This feature removes rows with errors. It does not solve an error in a step.
For Dynamic periods, should you use PARALLELPERIOD() or SAMEPERIODLASTYEAR()?
You should not use the PARALLELPERIOD() function. This function is used to calculate dates for a selected period either forward or backwards. It requires a valid date, number of interval, and interval as an argument. In the option set, you do not have all the available arguments for this function. You should use SAMEPERIODLASTYEAR () function to calculate previous year sales for dynamic periods. You should use 'Calendar'[Date] as an argument for the SAMEPERIODLASTYEAR () function to calculate the last year date for selected period.
Why should you add a blank page to your report and restart PowerBI on the blank page before recording in Performance Analyzer? Because you need to clear the ___. Restarting clears the ____.
You should perform the following actions in order: 1. Add a blank report page. 2. Restart Power Bl Desktop. 3. Start recording in Performance Analyzer. 4. Interact with the visuals. 5. Stop recording and review the results. First, you should add a blank page to your report. Before running Performance Analyzer, you need to clear the visual cache and data engine cache. Opening Power Bl Desktop on a blank page will not cache the visuals. Then, you should restart Power Bl Desktop. Restarting Power Bl Desktop will clear the data engine cache. Next, you should start recording in the Performance Analyzer tool. Then, you should interact with the visuals to capture performance measurements. Finally, you should stop recording and review the results.
Where do you go to set an alert and email notification for a card visual? What are the 4 steps involved?
You should perform the following actions: • Choose More options on the Manufacturing efficiency card visual and click on Manage alerts. • Click the + Add alert rule button. • Choose Below in the Condition field and set the Threshold value to 0.7. • Check the Send me email too checkbox and click Save and close.
Once you've created a detail page, how would you enable drill-through on the [city] column from the home page? What page should enable 'keep all filters on'?
You should perform the following actions: • Create a new page named Detail. • Create a table visual named Visual B to show total sales by city and product line. • On the Detail page, under the drill through option, add City column as the drill through field. • On the Detail page, under the drill through, option set Keep all filters to On.
You need to create a dashboard that will be simultaneously updated whenever the report page is updated. What should you do?
You should pin the report to a new dashboard as a live page. Pinning a report as a live page enables changes to the report to appear simultaneously in the dashboard tiles when the report page is refreshed. You should not create a new dashboard and pin each of the visuals from the report page as individual tiles.
Performance: The model will achieve the highest optimizations with ______column data, which uses ____encoding. Text columns use ____encoding that will adversely affect performance. Additionally, using ____ values in relationships instead of ___ will improve model performance.
You should remove the PO prefix from the PO Number column and change the data type to Whole Number. The model will achieve the highest optimizations with numeric column data, which uses value encoding. Text columns use hash encoding that will adversely affect performance. You should then recreate the relationship using the Vendor ID and not the Vendor name. Using numeric values in relationships instead of text will improve the model performance.
You need to configure the page for use with screen reader software for partially sighted users. What should you configure on the report page so that the screen reader follows a logical sequence?
You should set the Tab order for each visualization. You arrange the visuals in order by using the up and down arrows in the Selection Pane, or by using drag and drop into the desired order. Tab Order is used by keyboard users to navigate the report page. Screen reader software will follow the sequence set in the tab order. You can also skip visuals by hiding the visual from the Tab order. Screen reader software uses the Alt-Text on a visual to read about the visual.
Conditional formatting format by option: Color scale creates a ___ color scale.
You should then select Color scale as the Format by option. Color scale creates a graduated color scale from the lowest to the highest value.
Bookmarks allow you to preserve the ___, ____, and _____ selections of the current page
You should use Bookmarks to preserve slicer selection on a report page. Bookmarks allow you to preserve the filter, slicer, and visual state selections of current page. You can view bookmarks as a slideshow.
You can add report navigation, so users can go directly to a specific report page (without filters) using _____.
You should use Buttons to add report navigation. You can choose Page navigation as the button action type and set the destination page. You can also set the button action type to Bookmark and set its action to the destination bookmark.
[az] Column distribution shows data _____.
You should use Column distribution to find data anomalies or outliers. Data anomalies are outliers in the data. Finding the anomalies helps you identify what the normal distribution of the data looks like and, it identifies data that should be investigated. The Column distribution option in Power Query shows the distribution of data that allows you to find the anomalies. You should be aware that the preview is based on the first 1,000 rows. You should select the Column profiling based on the entire data set to verify that the column contains unique values.
[ds] You use ___ to create dataflows which uses the ____ language.
You should use Power Query to create dataflows. You should not use DAX functions to create dataflows. Power Query uses the M language
CALCULATE evaluates an expression followed by one or more _____
You should use the CALCULATE function. CALCULATE evaluates an expression with a filter. The parameters for CALCULATE are an expression followed by one or more filters.
[az] Column distribution allows you to show ____and _____values for each column in a single view.
You should use the Column distribution option to check distinct and unique rows for each column in a dataset. Column distribution allows you to show distinct and unique values for each column in a single view. You can use either Column distribution or Column profile to show if the values in a column are unique, but only Column distribution shows distinct rows. You should select profiling based on the entire data set.
[ds] What are the conditions for using dual storage mode?
You should use the Dual storage mode for slicers on the Customer and Territory tables. Slicers filter the data on the report page. If there are simple relationships in the model, Dual-mode can improve performance using either caching with the Import storage mode or executing a join relationship with the DirectQuery storage mode. The Dual storage mode allows Power Bl to use either Import or Direct Query depending on the visualizations on the report.
[ds] Is DAX fully supported in the Direct Query storage mode?
You should use the Import storage mode to be able to create a calculated table. Many DAX queries cannot be used with DirectQuery. Only DAX queries that can be translated into queries on the source data can be used. You are unable to create a calculated table using DirectQuery and must use the Import storage mode if you need a calculated table.
[ds] To use Q&A, what storage mode should you use? What mode allows all Power BI services features?
You should use the Import storage mode to be able to use Q&A in your report. Q&A features are not available if the table has a storage mode of DirectQuery. The Import storage mode allows all Power Bl service features such as Q&A to be used.
Performance analyzer examines the performance of your data model, including performance of ____ and ____
You should use the Performance analyzer in Power Bl Desktop to identify the source of the performance issues. Performance analyzer examines all aspects of your data model and report including DAX queries and visuals. Performance analyzer allows you to sort by the longest running queries, so you can identify performance bottlenecks and target these for further analysis.
[dx] You should use the ____ function to gather unique combination values from columns in another table and populate a new table.
You should use the SUMMARIZE() function to gather unique combination values from columns in another table and populate a new table.
What are 2 ways to register a new custom app for use in Power BI?
dev.powerbi.com/apps or the Azure Portal.
You can subscribe to report pages and dashboards and be ____ a snapshot. Cadence includes, daily, weekly, or upon ______.
e-mailed, upon first scheduled refresh
[pf] Performance Analyzer shows you how much time it take to _____ and _____.
how much time it takes to render a visual and how long it takes to retrieve data.
Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server databases contain the same tables. What's the easiest way to swap connection between the 2 dbs?
in the Power Query editor, by going to Home> Data source settings, it is possible to update the origin of the data for the whole model you are working on.
After you pin a visual as a tile on a dashboard, will the data refresh also update later visualization modifications?
lf you update a visualization that is used to create the tile, the tile doesn't change. If you pinned a line chart from a report and then you convert the line chart to a bar chart, the dashboard tile continues to show a line chart. The data refreshes, but the visualization type does not.
