Exam (elaborations)
PL-300 MICROSOFT POWER BI DATA ANALYST QUESTIONS AND ANSWERS
- Course
- Institution
PL-300 MICROSOFT POWER BI DATA ANALYST QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:47 Multiple choice questions
Term 1 of 47
Which of the following filters are not available in Power BI reports?
Drillthrough
-Page type
-Report level
-Page level
Visualizations, datasets, reports, dashboards, tiles.
-Building blocks for Power BI are visualizations, datasets, reports, dashboards, tiles.
Page type
-Page type filters are not available in Power BI reports.
Searching for help topics about Power BI.
- Searching for help topics about Power BI is not a feature of the Q&A visual.
Abbreviate column names.
-Abbreviations lead to confusion because they are often overused or not universally
agreed on.
Term 2 of 47
What benefit do you get from analyzing the metadata?
The benefit of analyzing the metadata is that you can clearly identify data
inconsistences with your dataset.
The benefit of analyzing the metadata is to get familiar with your data.
The benefit of analyzing the metadata is to know the number of rows, columns and
tables being loaded into your model.
,Term 3 of 47
Which of the following options isn't one of the four components in the Q&A visualization?
The question box, where users enter their question and are shown suggestions to help
them complete their question.
A pre-populated list of suggested questions
Automatic creation of a custom tooltip
An icon that users can select to convert the Q&A visual into a standard visual.
An icon that users can select to open Q&A tooling, which allows designers to configure
the underlying natural language engine.
Term 4 of 47
What is one way that reports and dashboards differ?
They are the same.
In reports, you can have multiple pages; in dashboards, you can have only one page.
You can only build reports and dashboards in Power BI service.
Term 5 of 47
When connecting to a SQL Server database to get data, what language should you use to
extract data?
DAX
T-SQL
MDX
Term 6 of 47
Where are dataset-scheduled refreshes configured?
Power BI service
Power BI Desktop
AppSource
,Term 7 of 47
What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
Deleting unnecessary rows and columns will reduce a dataset size and its good practice
to load only necessary data into your data model.
Deleting unnecessary rows and columns can damage the structure of the data model.
Term 8 of 47
If you have two queries that have different data but the same column headers, and you want to
combine both tables into one query with all the combined rows, which operation should you
perform?
Append
Merge
Combine Column
Term 9 of 47
A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in
Power BI?
The canvas.
Scheduled refresh.
An app.
Term 10 of 47
What is the benefit of using a report tooltip?
To give users additional information about a report visual, such as the author and
date/time it was created.
To provide additional detail that is specific to the context of the data that is being
hovered over.
To give users the ability to export data from the visual.
, Term 11 of 47
How do you use an inactive relationship in a single measure?
Change the active relationship in the Modeling tab.
Use the USERELATIONSHIP function.
Delete one relationship.
Term 12 of 47
Where are time series charts located?
The filter pane is where all filters on visuals and pages are located.
Time series charts can be imported from AppSource.
The fields pane is where all charts are located.
Term 13 of 47
Which one of the following options is the best description of a workspace?
A workspace is a feature in Power BI service that allows you to view reports only.
A workspace is a feature of Power BI Desktop that allows you to build reports only.
A workspace is a centralized location or repository that allows you to collaborate with
colleagues and teams to create collections of reports, dashboards, and so on.
A workspace is a feature that allows you to view and edit the data model, build
visualizations, and transform the data.
Term 14 of 47
You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When
the data refreshes in the cube, you would like to see it immediately in the Power BI report. How
should you connect?
Import
T-SQL
Live connection
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