Best Quality DA-100 Exam Questions Microsoft Test To Gain Brilliante Result!
Preparations of DA-100 Exam 2021 Microsoft Certified: Data Analyst Associate Unlimited 142 Questions
NEW QUESTION 34
You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE:
Each correct selection is worth one point.
- A. Sync the slicers across the pages.
- B. Replace the slicers with report-level filters.
- C. Replace the slicers with visual-level filters.
- D. Create a bookmark for each slicer value.
- E. Replace the slicers with page-level filters.
Answer: D,E
NEW QUESTION 35
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter.
Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
- A. The user will receive an error and will not be able to see the data in the report.
- B. The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
- C. The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
- D. The user will see only data for which the State Province value is Kentucky.
Answer: C
Explanation:
When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
NEW QUESTION 36
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
- A. Share the dashboard to the user.
- B. Create a subscription.
- C. Create a data alert.
- D. Tag the user in a comment.
Answer: B
Explanation:
You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:
Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.
Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly.
Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that have been certified.
Email subscriptions don't support R-powered custom visuals at this time.
Incorrect Answers:
A: Set data alerts to notify you when data in your dashboards changes beyond limits you set.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
NEW QUESTION 37
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Text Description automatically generated
Box 1: Yes
The Related function returns a related value from another table.
The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.
Box 2: Yes
Box 3: No
TX only occurs in the Sales table, but not in the CityData table.
Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/calculate-function-dax
NEW QUESTION 38
You have the dataset shown in the following exhibit.
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
- A. Add a Top N filter to the visual.
- B. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
D18912E1457D5D1DDCBD40AB3BF70D5D - C. Configure the Sales Profit measure to use the RANKX function.
- D. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
Answer: A
Explanation:
Explanation
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.
Note:
* Select the Column you want to display the Top Sales Profit
* Then change the Filter Type of that Column to Top N
* Fill in Top / Bottom number field
* And lastly drag to the By Value filed your Sales Profit
Reference:
https://www.tutorialgateway.org/power-bi-top-10-filters/
NEW QUESTION 39
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?
- A. Viewer
- B. Member
- C. Admin
- D. Contributor
Answer: B
Explanation:
Explanation
A Member can add members or others with lower permissions.
Note:
NEW QUESTION 40
You have the following table named Location.
The GeoCode column represents the country where each customer is located.
You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)
You need to ensure that the map displays the country locations.
What should you do?
- A. Change the Default Summarization of the GeoCode column.
- B. Change the name of the GeoCode column to Country.
- C. Replace the values in the GeoCode column with postal codes or zip codes.
- D. Change the Data Type of the GeoCode column.
- E. Change the name of the Location table to Country.
- F. Add a Geoportal column to the Location table.
Answer: B
Explanation:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
NEW QUESTION 41
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
* CustomerID
* Customer City
* Customer State
* Customer Name
* Customer Address 1
* Customer Address 2
* Customer Postal Code
The Invoice table contains the following fields:
* Order ID
* Invoice ID
* Invoice Date
* Customer ID
* Total Amount
* Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
* The number of customers invoiced in each state last month
* The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: One-to-many
A customer can have many invoices within one month.
Box 2: Single
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the
"many" side (bi-directional). For
Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
NEW QUESTION 42
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?
- A. donut chart
- B. stacked area chart
- C. waterfall chart
- D. line chart
Answer: D
Explanation:
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.
Example:
Incorrect Answers:
A: 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.
Note: A stacked area chart is the extension of a basic area chart. It displays the evolution of the value of several groups on the same graphic. The values of each group are displayed on top of each other, what allows to check on the same figure the evolution of both the total of a numeric variable, and the importance of each group.
Reference:
https://www.data-to-viz.com/graph/line.html
NEW QUESTION 43
You need to create a measure that will return the percentage of late orders.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 44
You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
* First name
* Last name
* Email address
* State/Region
* Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Open the Advanced Editor.
- B. Select Column profile.
- C. Select Column distribution.
- D. Select Column quality.
- E. Enable Column profiling based on entire dataset.
Answer: B,C
Explanation:
Data Profiling, Quality & Distribution in Power BI / Power Query features To enable these features, you need to go to the View tab Data Preview Group Check the following:
* Column quality
* Column profile
* Column distribution
* Column profile
Turn on the Column Profiling feature.
Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.
Reference:
https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/
https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/
NEW QUESTION 45
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
NEW QUESTION 46
You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?
- A. key influencers
- B. scatter chart
- C. ribbon chart
- D. line chart
Answer: D
Explanation:
The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.
Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.
Reference:
https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365
NEW QUESTION 47
Hotspot Question
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate.
You have a data model that contains the following tables.
The affiliate has a one to-many relationship to the Transactions table based on the AffiliatelD column.
You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point
Answer:
Explanation:
NEW QUESTION 48
You have a data model that contains many complex DAX expressions.
The expressions contain frequent references to the related and relatedtable functions.
You need to recommend a solution to minimize the use of the related and relatedtable functions.
What should you recommend?
- A. Merge tables by using Power Query. )
- B. Hide unused columns in the model. )
- C. Transpose.
- D. Split the model into multiple models.
Answer: A
Explanation:
Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you'd like to add to another query, you merge the queries.
Note: The RELATEDTABLEfunction is a shortcut for CALCULATETABLE function with no logical expression.
CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
NEW QUESTION 49
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales.
You need to compare the year-to-date sales with the previous year for the same time period.
Which DAX function should you use?
- A. LASTDATE
- B. PREVIOUSYEAR
- C. TOTALYTD
- D. SAMEPERIODLASTYEAR
Answer: D
NEW QUESTION 50
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/related-function-dax
https://docs.microsoft.com/en-us/dax/calculate-function-dax
NEW QUESTION 51
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. Key influences
- B. Q&A
- C. Line and clustered column chart
- D. Funnel chart
Answer: A
Explanation:
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?
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
NEW QUESTION 52
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 Bl Desktop?
- A. the bookmark order
- B. the X position
- C. the layer order
- D. the tab order
Answer: D
NEW QUESTION 53
You view a query named Transactions as shown in the following exhibit.
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.
Answer:
Explanation:
NEW QUESTION 54
......
Focus on DA-100 All-in-One Exam Guide For Quick Preparation: https://www.updatedumps.com/Microsoft/DA-100-updated-exam-dumps.html
DA-100 All-in-One Exam Guide For Quick Preparation: https://drive.google.com/open?id=12INIEbukOjEQWMlVaZYYm4Pw9LTXAwFq