Use DA-100 Exam Dumps (2022 PDF Dumps) To Have Reliable DA-100 Test Engine
DA-100 PDF Recently Updated Questions Dumps to Improve Exam Score
Exam Topics
Microsoft expects that the successful candidates get the passing score of 720 points on a scale of 100-1000. This mark is achievable if you put your mind to it. To succeed, you must understand the Microsoft DA-100 exam topics that are as follows:
1. Data Preparation (20-25%):
This part includes the following areas:
- Cleaning, loading, & transforming data: This subject area requires that the students understand how to combine queries, utilize user-friendly value substitutions, solve data import errors, transform and measure column data types, and configure the data loading. It also covers their skills in applying data shape transformations for table structures and user-friendly conventional naming for queries and columns. The individuals should also have the expertise in leveraging Advanced Editor or modifying Power Query M-code.
- Data profile: The test takers should have competence in interrogating data statistics and column properties as well as identifying data anomalies and evaluating data structures.
- Collecting data from various data sources: The candidates must be able to connect and identify data sources, alternate data source settings, and choose storage mode and shared datasets, or build local datasets. They also need the capacity to select the relevant query type, utilize parameters, Microsoft Dataverse, create or use PBIDS files, and data flow.
NEW QUESTION 74
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 uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
- C. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the
- D. Configure the Sales Profit measure to use the RANKX function.
Answer: A
Explanation:
calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
D18912E1457D5D1DDCBD40AB3BF70D5D
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 75
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. Select Column distribution.
- C. Open the Advanced Editor.
- D. Enable Column profiling based on entire dataset.
- E. Select Column profile.
Answer: D,E
Explanation:
The dataset have 1500 rows, if you don't enable the column profiling for the entire dataset, the column profiling will be only based on top 1000 rows.
So first enable for entire dataset and after that run column profiling for the entire dataset.
NEW QUESTION 76
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart 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 77
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. Hide unused columns in the model.
- B. Split the model into multiple models.
- C. Merge tables by using Power Query.
- D. Transpose.
Answer: C
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 RELATEDTABLE function 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 78
What is the minimum number of datasets and storage modes required to support the reports?
- A. two imported datasets
- B. two DirectQuery datasets
- C. a single imported dataset
- D. a single DirectQuery dataset
Answer: A
Explanation:
Scenario: Data and Sources
Data for the reports comes from three sources. Detailed revenue, cost, and expense data comes from an Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central.
The balance sheet data is not related to the profit and loss results, other than they both relate dates.
Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list.
Quarterly projections relate to the profit and loss results by using the following shared dimensions: date, business unit, department, and product category.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand Prepare the Data Question Set 3
NEW QUESTION 79
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers.
What should you do?
- A. In the Weekly_Returns table, create a new calculated column named date_id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.
- B. Create a new table based on the Date table where date_id is unique, and then create a many-to-many relationship to Weekly_Return.
- C. Add the Weekly_Returns data to the Sales table by using RELATED DAX functions.
Answer: A
Explanation:
Scenario: Regional managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.
NEW QUESTION 80
You have two Azure SQL databases that contain the same tables and columns.
For each database, you create a query that retrieves data from a table named Customers.
You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 81
Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
- A. custom streaming data
- B. text box
- C. web content
- D. video
Answer: A
Explanation:
Explanation
The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data source.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
NEW QUESTION 82
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. Create a data alert.
- B. Create a subscription.
- C. Share the dashboard to the user.
- 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 83
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:
Explanation:
Box 1: Total Sales
We select the field Total Sales
Box 2: Date
Select a date field.
Box 3: Month
Monthly periods.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures
NEW QUESTION 84
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 personal gateway.
- B. Set the refresh frequency to Daily.
- C. Configure the dataset to use the existing On-premises data gateway.
- D. Deploy an On-premises data gateway in personal mode.
Answer: B,C
NEW QUESTION 85
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.
Hotspot Question
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend.
Box 4: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
NEW QUESTION 86
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 87
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 data. 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:
Explanation
NEW QUESTION 88
You have a query that returns the data shown in the following exhibit.
You need to configure the query to display the data as shown in the following exhibit.
Which step should you use in the query?
- A. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta
[Serialized.Text = true] in type {itemType}}}), "classes") - B. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),
{"classes.1"}) - C. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
- D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
Answer: C
Explanation:
Explanation
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
Chart Description automatically generated
Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot
NEW QUESTION 89
Hotspot Question
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:
NEW QUESTION 90
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?
- A. stacked area chart
- B. donut chart
- C. waterfall chart
- D. line chart
Answer: D
Explanation:
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:
Reference:
https://www.data-to-viz.com/graph/line.html
NEW QUESTION 91
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? 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 - From Power BI Desktop, publish the dataset to powerbi.com.
2 - From Power BI Desktop, create four roles.
3 - From Power BI Desktop, add a Table Filter DAX Expression to the role.
4 - From powerbi.com, add a role members to the roles.
Explanation:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions
NEW QUESTION 92
You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Column distribution
- B. Monospace
- C. Column quality
- D. Show whitespace
- E. Column profile
Answer: A,E
Explanation:
Explanation
B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.
By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).
A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.
Reference:
https://docs.microsoft.com/en-us/power-query/data-profiling-tools
NEW QUESTION 93
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:
Reference:
https://tessellationtech.io/optimizing-power-bi-reports/
NEW QUESTION 94
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:
NEW QUESTION 95
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? 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-relationships-understand
NEW QUESTION 96
You need to create a visual as shown in the following exhibit.
The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 97
......
DA-100 Dumps Full Questions with Free PDF Questions to Pass: https://certblaster.lead2passed.com/Microsoft/DA-100-practice-exam-dumps.html
