Explanation:
You must first design an incremental refresh policy, which calls for specifying filter parameters, before you can implement an incremental refresh of the dataset. A Premium SKU upgrade is not required for an incremental refresh policy. The last step in configuring an incremental refresh is publishing the dataset to the Power BI service, which is necessary for the incremental refresh policy to take effect.
Explanation:
Since an on-premises SharePoint server is an on-premises data source, a Power BI gateway must be used. Connectivity to an Azure virtual network would be available via VPN-based solutions, but not the Power BI service. This situation does not apply to Azure Data Box, a solution for moving data to Azure.
Explanation:
The dashboards, paginated reports, and report pages that are most important to you can be subscribed to by you, your coworkers, and yourself.
You can: With Power BI email subscribers, you can:
- Select the frequency of your email delivery: daily, weekly, hourly, monthly, or once per day following the initial data refresh.
- Select the frequency of the email delivery: daily, weekly, hourly, or monthly.
The majority of bespoke visuals are not supported by email subscriptions. Those bespoke images that have received certification are the lone
exception.
R-powered custom visuals are not supported at this moment in email subscribers.
Explanation:
The other visualizations on the page can be filtered using the slicer visualization. Users can look for values to filter using a search box that can be enabled in a slicer. A funnel visualization is a diagram with connected stages that are ordered sequentially and show the sequential movement of things from one stage to the next. On the same report page as other graphics, a matrix visualization highlights data in two or more dimensions. A chart featuring one set of numerical values along the horizontal axis and another set along the vertical axis is known as a scatter chart visualization. There is no search box available for the matrix, scatter chart, or funnel.
Explanation:
After the data is imported, the filter is used.
Instead, amend the SQL query to include a WHERE clause.
Explanation:
For a Power BI workspace with a shared capacity, the daily maximum for refreshes is 8.
Explanation:
The Dataset Certification tenant admin setting defines the admin users who can certify a dataset.
Explanation:
You can add the visual to an existing dashboard or make a new one using the Pin visual option. You can copy a visual to the Clipboard as a picture by choosing the Copy visual as image option. You cannot construct a dashboard using the Export data option, however you may export data in the xlsx or csv formats. You cannot construct a dashboard using the Spotlight option, but you can highlight a graphic on the report page.
Explanation:
You must first construct a role and a corresponding DAX expression before you can utilize row-level security to guarantee that after the report is published, employees in each department can only see the sales data for that department. Row-level security is not the only usage for filter parameters; the incremental refresh policy is another. The row-level security is enabled once the relevant roles are created because it needs to be deployed to the Power BI service for it to work. Row-level security can be enabled without switching to the Premium SKU.
Please select 2 correct answers
Explanation:
Users without access can request access to a certified dataset by configuring it to be discoverable. A promoted dataset can be set up such that users who do not have access can nevertheless find it and seek access. A dataset need not have RLS in order to be discoverable. A dataset need not be premium (capacity or shared) to be discoverable.
Explanation:
Before the data is imported, the WHERE clause takes effect.
Explanation:
We must separate the time and date tables. Additionally, since the time is repeated each day, we don't need to enter it in the date table.
To connect the date to the date table and the time to the time table, separate the DateTime column into distinct date and time columns in your fact
table. To ensure that every time in your data correlates to a row in your table, the time needs to be adjusted to the nearest round minute or second.
Explanation:
Instead, change the queries' source step such that DataSourceExcel is used as the file path.
It should be noted that parameterizing a data source has numerous potential applications. from connecting to several data sources listed in the
Query Parameters to load various column combinations.
Explanation:
Power BI dashboard creation is supported by the Power BI service. Dashboards can be seen but not made on the Power BI mobile app. Power BI dashboard creation is not supported by Power BI Desktop. The Microsoft Excel utility Power Query is used for data importation but not for dashboard creation.
Explanation:
DirectQuery: Power BI Desktop does not import or copy any data.
Import: Power BI Desktop imports the chosen tables and columns. The imported data is utilized by Power BI Desktop while you design or interact
with a visualization.
Features of DirectQuery -
Using DirectQuery has the following advantages:
- Whereas it would be impossible to import all the data using pre-aggregation, DirectQuery enables you to create visualizations over very big
datasets.
- Data can need to be refreshed when the underlying data changes. Reimporting data may not be possible for some reports because the requirement
to display current data may necessitate huge data transfers. In contrast, DirectQuery reports constantly employ up-to-date information.
For DirectQuery, the 1-GB dataset restriction is not an issue.
Note: This exam question comes in a variety of forms. Other inappropriate response choices for the question include the following:
Row-level security (RLS) implementation
- Increase the frequency with which the dataset is updated.
Explanation:
For example, change the text ""ur"" to ""or"" in the table.