Microsoft DA-100 Dumps - 100% Cover Real Exam Questions (Updated 142 Questions)
Real DA-100 dumps - Real Microsoft dumps PDF
Certification Path
After acquiring the Microsoft Certified: Data Analyst Associate certification, you are competent to go further and broaden your expertise in the Microsoft BI platform. Although this certificate is not a direct requirement for other BI-related validations, it will sure help you get started with the higher-level certifications like the Microsoft Certified: Dynamics 365 + Power Platform Solution Architect Expert.
NEW QUESTION 13
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. Configure the Sales Profit measure to use the RANKX function.
- B. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
- C. Add a Top N filter to the visual.
- D. 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
Answer: C
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 14
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail dat a. The users require insights on the completeness of the data and the value distributions.
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.
Answer:
Explanation:
1 - Create a blank query as a data source.
2 - Specify the following query, then close and apply.-......
3 - Create a visual for the query table.
NEW QUESTION 15
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen, You create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?
- A. No
- B. Yes
Answer: B
Explanation:
Instead modify the source step of the queries to use DataSourceExcel as the file path.
Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference:
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
NEW QUESTION 16
You are creating a quick measure as shown in the following exhibit.
You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
NEW QUESTION 17
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. Replace the slicers with report-level filters.
- B. Create a bookmark for each slicer value.
- C. Replace the slicers with page-level filters.
- D. Replace the slicers with visual-level filters.
- E. Sync the slicers across the pages.
Answer: A,E
Explanation:
Add a report-level filter to filter an entire report.
The visuals on the active page, and on all pages in the report, change to reflect the new filter.
You can sync a slicer and use it on any or all pages in a report.
1. On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualizations panes.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
NEW QUESTION 18
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?
- A. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
- B. Publish the reports in an app and grant the HR managers access permission.
- C. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
- D. Publish the reports to a different workspace other than the one hosting the datasets.
Answer: D
Explanation:
Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
NEW QUESTION 19
Case Study 1 - Litware, Inc.
Overview
Litware, Inc. is an online retailer that uses Microsoft Power Bl dashboards and reports. The company plans to leverage data from Microsoft SQL Server databases, Microsoft Excel files, text files, and several other data sources.
Litware uses Azure Active Directory (Azure AD) to authenticate users.
Existing Environment
Sales Data
Litware has online sales data that has the SQL schema shown in the following table.
In the Date table, the dateid column has a format of yyyymmdd and the month column has a format of yyyymm. The week column in the Date table and the weekid column in the Weekly_Returns table have a format of yyyyww. The regionid column can be managed by only one sales manager.
Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
Reporting Requirements
Litware identifies the following technical requirements:
- Executives require a visual that shows sales by region.
- Regional managers require a visual to analyze weekly sales and returns.
- Sales managers must be able to see the sales data of their respective region only.
- The sales managers require a visual to analyze sales performance versus sales targets.
- The sale department requires reports that contain the number of sales transactions.
- Users must be able to see the month in reports as shown in the following example: Feb 2020.
- The customer service department requires a visual that can be filtered by both sales month and ship month independently.
You need to address the data concerns before creating the data model.
What should you do in Power Query Editor?
- A. Select the sales_amount column and apply a number filter.
- B. Select Column profile, and then select the sales_amount column.
- C. Select Column distribution.
- D. Transform the sales_amount column to replace negative values with 0.
Answer: C
NEW QUESTION 20
Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.
You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.
What should you recommend?
- A. Create a workspace for development and a workspace for production. From the production workspace, publish an app.
- B. In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
- C. Create one workspace for development. From the new workspace, publish an app for production.
- D. Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
Answer: A
Explanation:
Use different work stages (Development, Test, and Production).
Deploy from the Development workspace.
Reference:
https://visualbi.com/blogs/microsoft/powerbi/application-lifecycle-management-power-bi/
NEW QUESTION 21
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
- A. Remove the Subject and Body columns during the import.
- B. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
- C. From Model view, set the Subject and Body columns to Hidden.
Answer: A
NEW QUESTION 22
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.
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:
Explanation:
Box 1: CALCULATE
Start with CALCULATE and use a SUMX.
CALCULATE evaluates an expression in a modified filter context.
Box 2: SUMX
SUMX returns the sum of an expression evaluated for each row in a table.
The following sample creates a measure with the sales of the top 10 sold products.
= SUMX(TOPN(10, SUMMARIZE(Product, [ProductKey], "TotalSales", SUMX(RELATED(InternetSales_USD[SalesAmount_USD]), InternetSales_USD[SalesAmount_USD]) + SUMX(RELATED(ResellerSales_USD[SalesAmount_USD]), ResellerSales_USD[SalesAmount_USD])) Box 3: TOPN TOPN returns the top N rows of the specified table.
Box 4: [TransactionDate]
TOPN Syntax: TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]...]) The orderBy_expression: Any DAX expression where the result value is used to sort the table and it is evaluated for each row of table.
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
NEW QUESTION 23
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 tab order
- B. the X position
- C. the layer order
- D. the bookmark order
Answer: A
Explanation:
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools
NEW QUESTION 24
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Configure the dataset to use the existing On-premises data gateway.
- B. Deploy an On-premises data gateway in personal mode.
- C. Set the refresh frequency to Daily.
- D. Configure the dataset to use the personal gateway.
Answer: B,C
Explanation:
B: The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI.
On-premises data gateway (personal mode) allows one user to connect to sources, and can't be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you're the only person who creates reports, and you don't need to share any data sources with others.
C: For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
NEW QUESTION 25
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. Select Column quality.
- B. Open the Advanced Editor.
- C. Enable Column profiling based on entire dataset.
- D. Select Column profile.
- E. Select Column distribution.
Answer: D,E
Explanation:
Explanation
Explanation:
Data Profiling, Quality & Distribution in Power BI / Power Query features To enable these features, you need to go to the View tab a Data Preview Group a Check the following:
* Column quality
* Column profile
* Column distribution
* Column profile
Turn on the Column Profiling feature.
* Column distribution
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 26
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Using a workspace membership
Scenario:
The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Note: Workspace is a shared environment for a group of people. You can have multiple Power BI content in a workspace. One workspace can have hundreds of dashboards, reports, and datasets in it.
Box 2: A mail-enabled security group
Scenario: Security Requirements
The reports must be made available to the board from powerbi.com. A mail-enabled security group will be used to share information with the board.
NEW QUESTION 27
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. line chart
- B. ribbon chart
- C. key influences
- D. scatter chart
Answer: A
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 28
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],.40) - B. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40) - C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- D. Create a horizontal line that has a fixed value of 24,000.
Answer: B
NEW QUESTION 29
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)
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:
NEW QUESTION 30
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],.40) - B. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- C. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40) - D. Create a horizontal line that has a fixed value of 24,000.
Answer: B
Explanation:
Explanation
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart
Add percentile lines to monitor daily revenue
NEW QUESTION 31
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?
- A. donut chart
- B. waterfall chart
- C. line chart
- D. stacked area chart
Answer: C
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 32
Drag and Drop Question
You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.
You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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.
Answer:
Explanation:
NEW QUESTION 33
......
Realistic Prep4away DA-100 Dumps PDF - 100% Passing Guarantee: https://www.prep4away.com/Microsoft-certification/braindumps.DA-100.ete.file.html