Exam (elaborations)
DA-100 Data analyst Exam with Questions with 100% Correct Answers |Verified
- Course
- Institution
DA-100 Data analyst Exam with Questions with 100% Correct Answers |Verified
[Show more]
Content preview
DA-100 Data analyst Exam with Questions with100% Correct Answers |Verified
B. Create a button for each business question and set the action type to Bookmark. - ✔✔You
are developing a sales report that will have multiple pages. Each page will answer a different
business question. You plan to have a menu page that will show all the business questions. You
need to ensure that users can click each business question and be directed to the page where
the question is answered. The solution must ensure that the menu page will work when
deployed to any workspace. What should you include on the menu page?
A. Create a text box for each business question and insert a link.
B. Create a button for each business question and set the action type to Bookmark.
C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain
the business questions.
A. the tab order - ✔✔You are developing a report page. Some users will navigate the report
by using a keyboard, and some users will consume the report by using a screen reader.You
need to ensure that the users can consume the content on a report page in a logical
order.What should you configure in Microsoft Power BI Desktop?
A. the tab order
B. the layer order
C. the bookmark order
D. the X position
D. Too many records were sent to the visual. - ✔✔You use an 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?
A. The visual was built by using a different version of R.
B. The data comes from a Microsoft SQL Server source.
C. The data is deduplicated.
,D. Too many records were sent to the visual.
A. Add a salary to the tooltips.
(maybe also B. Add a salary to the visual filters.) - ✔✔You have a line chart that shows the
number of employees in a department over time.You need to see the total salary costs of the
employees when you hover over a data point.What are two possible ways to achieve this goal?
Each correct answer presents a complete solution.NOTE: Each correct selection is worth one
point.
A. Add a salary to the tooltips.
B. Add a salary to the visual filters.
C. Add salary to the drillthrough fields.
B. highlight - ✔✔You have a report that contains a bar chart and a column chart. The bar
chart shows customer count by customer segment. The column chart shows sales by
month.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.How should the
visual interactions be set on the column chart when the bar chart is selected?
A. no impact
B. highlight
C. filter
B. Key influencers - ✔✔You build a report to help the sales team understand its performance
and the drivers of sales.The team needs to have a single visualization to identify which factors
affect success.Which type of visualization should you use?
A. Line and clustered column chart
B. Key influencers
C. Q&A
D. Funnel chart
,C. Change the dashboard theme. - ✔✔You have a dashboard that contains tiles pinned from
a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard
tab.)You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit.
(Click the Modified Dashboard tab.)What should you do?
A. Edit the details of each tile.
B. Change the report theme.
C. Change the dashboard theme.
D. Create a custom CSS file
Analyze = Total Sales
Explain by = Occupation
Exand by = City - ✔✔You have a table that contains the following three columns:
✑ City
✑ Total Sales
✑ Occupation
You need to create a key influencers visualization as shown in the exhibit. How should you
configure the visualization?
A. Add a Top N filter to the visual. - ✔✔You need to ensure that the visual shows only the 10
cities that have the highest sales profit.What should you do?
B. No - ✔✔You have a clustered bar chart that contains a measure named Salary as the value
and a field named Employee as the axis. Salary is present in the data as numerical amount
representing US dollars.You need to create a reference line to show which employees are
above the median salary.Solution: You create an average line by using the Salary measure.Does
this meet the goal?
A. Yes
B. No
, A. Yes - ✔✔You have a clustered bar chart that contains a measure named Salary as the
value and a field named Employee as the axis. Salary is present in the data as numerical amount
representing US dollars.You need to create a reference line to show which employees are
above the median salary.Solution: You create a percentile line by using the Salary measure and
set the percentile to 50%.Does this meet the goal?
A. Yes
B. No
1. Duplicate the Customer Query and name the new query CustomerGrouped
2. Group the CustomerGrouped query by Customer ID and output the max Modified Date value
into a column called Modified Date
3. Merge the two queries based on Customer ID and modified Date by using an inner join -
✔✔You have a query named Customer that imports CSV files from a data lake. The query
contains 500 rows as shown in the exhibit. (Click the Exhibit tab.) Each file contains deltas of
any new or modified rows from each load to the data lake. Multiple files can have the same
customer ID. You need to keep only the last modified row for each customer ID. Which three
actions should you perform in sequence? To answer, move the appropriate actions from the list
of actions to the answer area and arrange them in the correct order. Select and Place:
There are *9* CSV files
Removing Duplicates will reduce teh dataset to *10* rows - ✔✔The query gets CSV files from
a folder. Use the drop-down menus to select the answer choice that completes each statement
based on the information presented in the graphic. NOTE: Each correct selection is worth one
point.
B. Create a new group on the state column and set the Group type to List. - ✔✔Your
company has employees in 10 states. The company recently decided to associate each state to
one of the following three regions: East, West, and North. You have a data model that contains
employee information by state. The model does NOT include region information. You have a
report that shows the employees by state. You need to view the employees by region as quickly
as possible. What should you do?
A. Create a new aggregation that summarizes by employee.
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 $13.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77858 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now