Exam (elaborations)
POWER BI PL 300 QUESTIONS AND ANSWERS
- Course
- Institution
POWER BI PL 300 QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:76 Multiple choice questions
Term 1 of 76
Implicit measures are...
Benefits with implicit measures...
Calculated tables are best for intermediate calculations and data you want to store as
part of the model.
automatic behaviors that allow visuals to summarize model column data.
Several benefits are associated with implicit measures. Implicit measures are simple
concepts to learn and use, and they provide flexibility in the way that report authors
visualize model data. Additionally, they mean less work for you as a data modeler
because you don't have to create explicit calculations.
Date
Decimal Number
Date data types display well on a continuous (range) axis where report users understand
chronological order. Number data types display well on a continuous (range) axis where
report users understand the order between min and max values. Binary data and text
(categorical) data cannot be displayed on a continuous (range) axis. Date, time, or
number are the only data types comparable with a continuous axis.
Disable the Data option.
Disable the Current Page option.
Enable the Display option.
The current page capture allows the bookmark to navigate back to the page of capture.
The data capture updates filters and drillthrough which should not occur for this
bookmark. The display capture updates visual visibility on the report page.
,Term 2 of 76
What does the Value distribution graph present?
Counts for each unique value in a specific column.
Averages of all numerical entries across multiple columns.
Summaries of categorical data without specific counts.
Trends over time for a selected dataset.
Term 3 of 76
You plan to create a Power BI workspace.
You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint
Online document library is available to workspace users once the workspace is created.
Which setting (1) should you configure when creating the workspace?
Allow contributors to update the app
Develop a template app
License mode
Workspace OneDrive
,Term 4 of 76
You need to reduce the size of a Power BI model that contains two dimension tables named
Date and Location, and one fact table named Temperatures. The Temperatures table contains
the following fields:
Reading Time (datetime)
DateKey (date)
LocationKey (whole number)
Temp C (decimal)
You have one row for every 5-minute interval for each location. The Temperatures table is
related to the Date and Location dimensions by using many-to-one relationships. You need to
reduce the cardinality of the table. The solution must ensure that the dataset supports reports
that analyze average temperature by hour and location.
What two actions should you perform? Each correct answer presents part of the solution.
1. Create a column that contains the time values for the start of the hour of the Reading
Time value.
2. Disable the query load on the Temperatures query in the Power Query Editor.
3. Remove the rows that occur exactly at 0
Term 5 of 76
You have a Power BI Premium per user workspace.
What is the maximum number of refreshes that can be scheduled each day?
Select only one answer.
1
8
16
48
, Term 6 of 76
You have a Power BI model.
You need to assign items to a display folder.
Which three items can be assigned to a display folder? Each correct answer presents part of
the solution.
Calculated column
Column
Measure
Report
Table
8
The maximum number of refreshes per day for a Power BI workspace in a shared
capacity is 8.
Calculated column
Column
Measure
Tables and reports cannot be assigned a display folder. Columns, calculated columns,
and measures can be assigned a display folder.
48
In a Premium per user workspace the limit is 48 refreshes per day for a dataset.
Admin
The Admin role is the only one that has the permission to update workspace metadata.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller selftest. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now