PL-300 Power BI Exam with Verified Answers Graded A+
0 view 0 purchase
Course
PL-300 Power BI
Institution
PL-300 Power BI
PL-300 Power BI Exam with Verified Answers Graded
A+
Which of the following options would you configure to email an image of a report and a link
to the report in Power BI Service? - - Create a subscription; Subscriptions allow you
to send daily emails with snapshots of metrics and visuals
You'...
PL-300 Power BI Exam with Verified Answers Graded
A+
Which of the following options would you configure to email an image of a report and a link
to the report in Power BI Service? - - Create a subscription; Subscriptions allow you
to send daily emails with snapshots of metrics and visuals
You're prioritizing report development updates and need to understand how making
changes to a dataset will influence other downstream reports and dashboards. What tool
should you use? - - Impact Analysis; Impact analysis provides you the tools to
understand how making changes to a dataset will impact downstream reports and
dashboards
Suppose you have a table containing hourly-level sales data, and want to aggregate or roll it
up to a daily summary. Which Power Query tool would you use to do this? - -
Transform > Group By; Group By, available in the Transform tab, is used when you want
create a summary view or group various values in many rows into a single value
You're asked by a coworker to add a mean line to a line chart. Which of the following
analytics pane options should you use? - - Add an average line; The analytics pane
options change by chart type but for a line chart you can add an average line (mean)
Which of the following tools will help Power BI report users ask natural language questions
using the built in Q&A feature? - - Adding synonyms to tables from the data model
view and using the Q&A tooling interface to manage Q&A are both best practices
You add a clustered column chart to a report. Which of the following analytics features
allows you to see different divisions in the data? - - Percentile line; A percentile line
, PL-300 Power BI Exam with Verified Answers Graded
A+
allows you to add a dynamic line to a visual that will visually indicate values that fall below
the specified percentile. For example, adding a 75th percentile line would show you the
value below which 75% of the observations are found
Which Power Query tool could you use to add columns from a related table? - -
Merge; There are two primary ways of combining queries: merging and appending. When
you have one or more columns that you'd like to add to another query, you merge the
queries.
Which of the following DAX functions lets you use an inactive relationship for the duration
of the calculation? - - USERELATIONSHIP; USERELATIONSHIP let's you traverse
inactive relationships in your data model
You have two tables in a data model: Calendar_Lookup and Sales_Fact. The
Calendar_Lookup table contains a single column of Date values. In the Sales_Fact table,
there is a column called 'Transaction Date' which has unique DateTime records for every
sale. Based on this, which of the following statements are true? - - In a large dataset
(1 million + rows) with a date/time column that contains unique values, the cardinality of
that column is very large and leads to performance issues. Splitting out the time
component from the date helps reduce the model size. Additionally, because the lookup
table contains a single column of Date values and all DateTime values in the Sales_Fact
table are unique, the relationship between Lookup and Fact table is one-to-many
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 MERCYTRISHIA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.69. You're not tied to anything after your purchase.
