DA-100 Exam Study Questions with 100% Correct
Answers |Verified
R visual to produce a map of 500,000 customers. You include the values of CustomerID,
Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.In
powerbi.com, when users load the visual, they only see some of the customers. What is the
cause of the issue? - ✔✔Too many records were sent to the visual.
>Data size limitations ג€" data used by the R visual for plotting is limited to 150,000 rows
You need to see the total salary costs of the employees when you hover over a data point. -
✔✔Add a salary to the tooltips.
>Once tooltips are added to Tooltips, hovering over a data point on the visualization shows the
values for those fields.
You need to ensure that when a segment is selected in the bar chart, you see which portion of
the total sales for the month belongs to the customer segment. - ✔✔Highlight
>selecting a state on a map visualization highlights the column chart and filters the line chart to
display only data that applies to that one state
You are using existing reports to build a dashboard that will be viewed frequently in portrait
mode on mobile phones.You need to build the dashboard. - ✔✔1. Pin items from report to
Dashboard.
2. Open Dashboard.
3. Change the dashboard view to Phone view.
4. Rearrange, resize the visuals.
, Single visualization to identify which factors affect success. - ✔✔Key influencers
You need to create a visualization that shows the relationship between Unit Price and Quantity
Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
- ✔✔Visualization: A scatter plot of Quality Ordered
Feature: Auto find clusters
Create a reference line to show which employees are above the median salary. - ✔✔You
create a percentile line by using the Salary measure and set the percentile to 50%.
> not average line
A report contains four pages.
Each page contains slicers for the same four fields.
Users report that when they select values in a slicer on one page, the selections are not
persisted on other pages.
You need to ensure that users can select a value once to filter the results on all the pages. -
✔✔1. Replace the sliders with report-level filters
>Report-level filter to filter entire report. The visuals on the active page, and on all pages in the
report, change to reflect the new filter
2. Sync the slicers across the pages
Create the dashed horizontal line denoting the 40th percentile of daily sales - ✔✔Add a new
percentile line that uses Total Sales as the measure and 40% as the percentile.
outliers in the table - ✔✔scatter plot
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 Examsplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.