Exam (elaborations)
PL-300 EXAM SAMPLES POWERBI QUESTIONS AND ANSWERS
- Course
- Institution
PL-300 EXAM SAMPLES POWERBI QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:150 Multiple choice questions
,Term 1 of 150
You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query
Editor.
You need to identify outliers in a text column within the data source.
Which information should you use from Power Query Editor?
Select only one answer.
1. the min and max values in Column profile
2. the top and bottom entries in Value distribution
3. the value of the Distinct entry in Column statistics
4. the value of the Unique entry in Column statistics
2
(MS)
Using Dual mode means that either an import query can be run when accessing data
from FactStoreSales, or a DirectQuery query can be run when accessing data from
FactOnlineSales.
Using Import mode means the queries are only optimized for FactStoreSales (Import).
Using DirectQuery mode means the queries are only optimized for FactOnlineSales
(DirectQuery).
A storage mode of Import, DirectQuery, or Dual must be assigned.
2
(MS)
The error message indicates that the Excel workbook does not contain a table. To create
it, in the Excel workbook, you need to select the data you want to import, press Ctrl+T or
choose the Table button, click OK and save the change.
Using the Data Validation button in Excel does not create a table.
Organizational and template apps provide a way to implement functionality within Power
BI, but, in this case, the issue is caused by an absence of a table in the Excel workbook,
so installing an app would have no effect on resolving the issue.
2
(MS)
The top and bottom entries in Value distribution identify outliers, which appear,
respectively, the greatest and the smallest number of times in that column.
,The value of the Distinct entry in Column statistics indicates the total count of different
values.
The value of the Unique entry in Column statistics indicates the total count of different
values that appear only once.
The min and max values in the Column profile of a text column designate the entries
which appear, respectively, first and last in alphabetical order.
1,2
(MS)
Adding synonyms to model fields will help users search for them. For example, you can
give a synonym of (Actuals) for the (Sales) measure.
A linguistic schema describes terms and phrases that Q&A should understand for
objects within a dataset, including parts of speech, synonyms, and phrasings that relate
to that dataset.
Composite models are not supported by Q&A today. Organizing fields by display folders
will not impact Q&A search capabilities.
, Term 2 of 150
You have a Power BI report that uses a dataset that is imported from a database.
You add a slicer to a report.
You need to sync the slicer to use it on other report pages.
What is required to sync slicers between report pages?
Select only one answer.
1 Each slicer must be the same slicer type.
2 Each slicer must be visible.
3 Each slicer must have the same title.
4 Each slicer must use the same column.
4
(MS)
The Performance analyzer will show the query timings for each object on a report page.
Session diagnostics measures Power Query query performance as it relates to refresh
times. It is unrelated to measuring DAX performance or report page query timings.
The Best Practices analyzer reviews the model for best practices around things like
model design, relationships, field naming conventions, and measures. But is unrelated to
any query timings for report page visuals.
2.
(MS)
By default, column profiling is only based on the first 1000 rows of the preview.
Changing the column profile status to entire dataset will query the entire dataset for the
column profiling information.
4
(MS)
The same column must be used in each slicer for them to recognize each other in the
sync slicers settings.
Slicers can sync even when hidden. Slicers do not need to be the same slicer type. One
slicer could be a list, and the other a dropdown. Slicers do not need the same title to
allow them to be synced.
3
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)
84669 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now