Power BI PL-300 Certification Exam Questions and Answers.
4 views 0 purchase
Course
Power BI PL-300
Institution
Power BI PL-300
PowerBIPL-300CertificationExamQuestionsand
Answers.
There is a matrix using a standard date hierarchy. It is currently showing a range of years.
How do you display just a specific year and that year's quarters? - Correct Answer Select
'Drill Down', which concentrates on one particular item
Wha...
Power BI PL-300 Certification Exam Questions and
Answers.
There is a matrix using a standard date hierarchy. It is currently showing a range of years.
How do you display just a specific year and that year's quarters? - Correct Answer Select
'Drill Down', which concentrates on one particular item
What pane allows the user to set the order that visuals move between after pressing Tab?
- Correct Answer Selection. It provides a list of all objects on the current page and allows
the user to group and hide visuals as well as change the layer and tab order.
What Power Query feature removes spaces from the beginning and the end of any string
in a column? - Correct Answer Trim (Under Transform > Format). This removes leading
and trailing spaces from a string
How can you add a custom visual from the online Microsoft Store to a Power BI report? -
Correct Answer Go to the Home tab, select More Visuals, and select "From AppSource" or
go the Insert tab, select the dropdown containing all of the visuals, and select "Get more
Visuals"
There is a dataset of Employee Data which includes the 'Department' and 'Salary' fields.
To understand whether Department has an influence on Salary, what two actions need to
be taken? There is a Key Influencers visual. - Correct Answer Drag Salary into the
'Analyze' section and Department into the 'Explain By' section. The field in the Analyze
section is the numerical field that you are wanting to have explained. The field(s) in the
"Explain by" are the fields you want to see have an influence.
What AI visual allows users to analyze data by drilling down into various fields? - Correct
Answer Decomposition Tree
When filtering a visual to values containing certain text, what wildcard represents zero to
many characters? For example, I want to show all values starting with 'St' that include
another 'T' - Correct Answer Asterisks (Example: St*t*)
What does Column Distribution in the Power Query editor show? - Correct Answer Unique
and Distinct values
, How are changes to an original column reflected in Duplicated and Referenced columns,
respectively? - Correct Answer Duplicating a query means that the query as it currently is
will be copied into another query. Subsequent changes to the original query will not affect
a duplicated query.
Referencing a query means that there is a link to the original query. Subsequent changes
to the original query will affect a referenced query
Is a Power BI Pro license needed to use Sync Slicers? - Correct Answer No, it is not
What needs to be entered into the 'Starting Index' and 'Number of Characters' fields in the
Extract Text Range feature of the Power Query Editor to extract the 3rd character from a
field? - Correct Answer Starting Index = 2, Number of Characters = 1 (Note STARTING
INDEX = STARTING FROM)
What happens when the data type of a column that contains text and numbers is changed
to Decimal Number? - Correct Answer Any text (non-numerical) data returns an Error
There is a dataset which includes a Date field, and "Total Pay" and "Department" fields.
There has been a visual which uses anomaly detection created.
Which type of visual is being used, and what fields could be used in that visual? - Correct
Answer A line chart, with a date field in the X-axis, Total Pay in the Y-axis (the Legend
section is empty).
Anomaly detection cannot be used on charts with legends or a stacked column
What storage mode would help reduce a delay in visuals being affected by slicers when
the data used is from a SQL server? - Correct Answer Import storage mode, since the
visuals changed are based on data already loaded from the cache imported
What feature allows you to combine the rows of one query into another? - Correct Answer
Append Queries
What are all of the ways that you can see empty values in a column in Power Query
Editor? - Correct Answer View - Column Profile and View - Column Quantity
What does Column Quality in Power Query Editor display? - Correct Answer Displays
valid, error, and empty values
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 Pronurse. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $23.49. You're not tied to anything after your purchase.
