Exam (elaborations)
COURSERA PL-300 MOCK EXAM 3 QUESTIONS AND ANSWERS
- Course
- Institution
COURSERA PL-300 MOCK EXAM 3 QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:50 Multiple choice questions
Definition 1 of 50
You need to create a data source that can be used offline. Which type of data source should
you use?
Common data services
SQL Server
SharePoint
Microsoft OneDrive
Definition 2 of 50
Your Power BI data model has a Sales fact table and a Date table. The Sales table contains two
date columns: ShipDate and OrderDate.
Both date columns have a relationship to the Date column in the Date table, and DAX
measures have been defined to use these relationships for calculations related to order date
or ship date.
You need to make sure that the Date table does not filter the Sales table unless it is using DAX
measures that use these relationships. What should you do?
Disable Make this relationship active for both relationships.
Enable a security filter in both directions for both relationships.
Set the cross-filter direction to Both for both relationships.
Enable Make this relationship active for both relationships.
,Definition 3 of 50
You manage a Power BI workspace. You need to delegate the task to update workspace
metadata. The solution must use the principle of least privilege. Which role should you use?
point
Contributor
Viewer
Member
Admin
Definition 4 of 50
In the Power query editor, the column statistics show a count of 1000 rows, but your query is
retrieving data from a data source that contains 5000 rows. What should you do for the column
statistics to show the statistics based on entire data rows?
Change the query load from Import to DirectQuery.
Create a Top N row count parameter for the query.
Add a Table.Buffer applied step using M in the query.
From the query window, select Column profiling on the entire dataset.
Definition 5 of 50
Which Power BI refresh options require you to set parameters?
On-demand refresh
Incremental refresh
Scheduled refresh
,Definition 6 of 50
You have accessed the data from a SQL Server as DirectQuery. The dataset contains millions of
rows. The objective of the analysis is to group data by year and region. Creating aggregated
tables has the capacity to reduce the dataset sourced through DirectQuery. Which Power BI
element allows you to create aggregations?
Data view of Power BI desktop
Power query editor
Model view of Power BI desktop
Page view of Power BI desktop
Definition 7 of 50
You are developing a Power BI desktop report to visualize the sales performance of
salespeople. The sales team is comprised of over 20 salespeople. You also need to make sure
the sales values are visualized monthly. What should you do?
Create a Column chart displaying salespersons on the X-axis and create a Slicer for data
hierarchy.
Create a Column chart displaying Date hierarchy on the X-axis and create a Slicer drop-
down for salespersons.
Create a Column chart displaying the month on the X-axis.
Create a Bar chart displaying the salesperson on the Y-axis.
Definition 8 of 50
A fundamental principle of data storytelling is a cohesive report page and visuals should be
placed in a logical order. Which Power BI element allows you to visualize the order of visuals in
the report page and configure them according to the narrative of your data story?
Page navigator from Power BI desktop.
Visualizations pane of Power BI desktop.
Selection pane from the query editor.
Selection pane from Power BI desktop.
, Definition 9 of 50
You want to create a common date table within your Power BI data model. The start and end
of the date table must match the date range available in the fact table of the data model. How
can you create this table?
Use the CALENDAR function and specify the dates.
Use CALENDAR with MIN and MAX to specify the dates.
Use CALENDARAUTO and specify the dates.
Use CALENDARAUTO with MIN and MAX to specify the dates.
Definition 10 of 50
You have a Waterfall chart showing the increase and decrease of Sales by States in Power BI
report in Power BI service and want to analyze the data using the Analyze feature of Power BI.
You selected the first data point of the Waterfall chart and the Analyze option is not available
in the context menu. What could be the probable reason?
The Analyze feature cannot be used for the first data point of the visual.
The Analyze feature can only be used in Power BI desktop.
The Waterfall chart does not support the Analyze feature.
Definition 11 of 50
Which of the following Power BI components can you use to configure the column and table
properties of your data model? Select all that apply.
point
The Model view of Power BI desktop.
The Power query editor.
Visualizations pane of Power BI desktop.
Advanced editor.
The Model view of Power BI desktop.
The Power query editor.
Reference queries allow you to reuse query logic and transformation.
You need to display visuals that use different datasets.
Use CALENDAR with MIN and MAX to specify the dates.
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)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now