Exam (elaborations)
PL-300 PART 8 QUESTIONS AND ANSWERS
- Course
- Institution
PL-300 PART 8 QUESTIONS AND ANSWERS
[Show more]
Content preview
Name: Score:135 Multiple choice questions
,Term 1 of 135
You have a Q&A visual that displays information from a table named Carriers as shown in the
following exhibit. You need to ensure that users can ask questions by using the term airline or
carrier. The solution must minimize changes to the data model. What should you do?
- Add a duplicate query named Airline.
- Add airline as a synonym of carrier.
- Rename the carrier column as airline in the Carriers query.
- Rename the query from Carriers to airlines.
- append queries as new
- disable loading the query to the data model
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.
- When you have additional rows of data that you'd like to add to an existing query, you
append the query.
For every query that loads into model memory will be consumed. and Memory is our
asset in the Model, less memory consumption leads to better performance in most of
the cases. The best approach is to disable loading.
- scatter plot of Quantity Ordered and Unit Price by item
- automatically find clusters
A scatter chart always has two value axes to show: one set of numerical data along a
horizontal axis and another set of numerical values along a vertical axis. The chart
displays points at the intersection of an x and y numerical value, combining these values
into single data points. Power BI may distribute these data points evenly or unevenly
across the horizontal axis. It depends on the data the chart represents.
Scatter charts are a great choice to show patterns in large sets of data, for example by
showing linear or non-linear trends, clusters, and outliers.
- Add airline as a synonym of carrier.
Add synonyms to tables and columns: This step applies specifically to Q&A (and not to
Power BI reports in general). Users often have a variety of terms they use to refer to the
same thing, such as total sales, net sales, total net sales. You can add these synonyms to
tables and columns in the Power BI model.
This step can be important. Even with straightforward table and column names, users of
Q&A ask questions using the vocabulary that first comes to them. They're not choosing
,from a predefined list of columns. The more sensible synonyms you add, the better your
users' experience is with your report.
- Performance Analyzer in Power BI Desktop
In Power BI Desktop you can find out how each of your report elements, such as visuals
and DAX formulas, are performing. Using the Performance Analyzer, you can see and
record logs that measure how each of your report elements performs when users
interact with them, and which aspects of their performance are most (or least) resource
intensive.
, Term 2 of 135
You need to create a visualization that compares revenue and cost over time. Which type of
visualization should you use?
- stacked area chart
- donut chart
- line chart
- waterfall chart
- line chart
A line chart or line graph displays the evolution of one or several numeric variables.
Data points are connected by straight line segments. A line chart is often used to
visualize a trend in data over intervals of time - a time series - thus the line is often
drawn chronologically.
Stacked area charts are not appropriate to study the evolution of each individual group:
it is very hard to substract the height of other groups at each time point.
- Key influencers
The key influencers visual helps you understand the factors that drive a metric you're
interested in. It analyzes your data, ranks the factors that matter, and displays them as
key influencers.
The key influencers visual is a great choice if you want to:
- See which factors affect the metric being analyzed.
- Contrast the relative importance of these factors. For example, do short-term contracts
have more impact on churn than long-term contracts?
permissions required in powerbi.com: the viewer role to the workspace
permissions for the profit and loss dataset: build
The Viewer role gives a read-only experience to its users. They can view dashboards,
reports, or workbooks in the workspace, but can't browse the datasets or dataflows. Use
the Viewer role wherever you would previously use a classic workspace set to "Members
can only view Power BI content".
The analysts must be able to build new reports from the dataset that contains the profit
and loss data.
- Member
A Member can add members or others with lower permissions.
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)
82191 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now