Lead2Passed DA-100 Dumps PDF - 100% Passing Guarantee
DA-100 Braindumps Real Exam Updated on Jan 21, 2022 with 142 Questions
What career bonuses will you get after passing the Microsoft DA-100 exam?
The certifications from a renowned vendor such as Microsoft enhance the chances of the professionals to land a decent job. The individuals with the Microsoft Certified: Data Analyst Associate certificate are also at an advantage because this option validates their skills and competence in a specific technical domain. Some of the job titles that the certified specialists can pursue include a Data Analyst, a Business Analyst, a Mobile Test Analyst, a Revenue Analyst, and a Quantity Assurance Analyst. The average salary for these experts is $105,000 per annum.
Certification Opportunities
Upon completion of this single exam and obtaining the certification, the path doesn’t end. The candidates can pursue other Microsoft certificates to expand their competence area. These include the options such as Microsoft Certified: Azure Data Engineer Associate and Microsoft Certified: Azure Data Scientist Associate, to name a few.
Exam DA-100 Topics Covered
Test DA-100 measures the entrant's skills in 5 different domains:
- Preparation of data (20-25%)
The first domain for DA-100 exam consists of questions that will test the candidate's understanding of data retrieval from various sources. Thus, applicants should be able to identify the data source and connect to it, modify the source settings, select and create various data sets, pick a storage mode, etc. In addition, the examinee should be familiar with the concept of data profiling and have to be able to identify anomalies, study data structures, and examine column properties as well as data statistics. This section also includes cleaning, transforming, and loading data. This means that the entrant must know how to resolve inconsistencies, transform column data types, combine queries, solve data import errors, and more. This topic will also include Microsoft Dataverse, the usage & creation of a PBIDS file, and data flow after the changes are incorporated.
- Analyzing the data (10-15%)
In the fourth tested area, the candidate will be asked to enhance reports for exposing insights. This means complying with the need to be well-informed about conditional formatting, slicers, filters, Analytics pane along with a few other concepts. Besides, candidates must be able to add Quick Insights results to reports and use Q&A visuals. Likewise, the exam-taker should be able to know how to execute the advanced analysis. This involves the understanding of outliers, Timer Series analysis, groupings, binning, dimensional variances, decompositions tree visuals, and AI Insights. The exam also requires an understanding of the Play Axis feature and the personalization of visuals.
- Modeling the data (25-30%)
This part of the final exam includes designing a data model. Here, the candidate should be able to define and configure tables along with having an idea about various dimensions and relationships. They are also required to be familiar with the concept of cardinality and cross-filter direction. After designing a data model, the applicant should be aware of how to develop it. Therefore, understanding of security filtering, calculated tables, hierarchies, and the implementation of row-level security roles will be beneficial. Furthermore, the entrants' expertise in working with DAX will be tested in this sector. They are required to be capable of using DAX for building complex measures, taking advantage of CALCULATE for manipulating filters using DAX with Time Intelligence, and more. In addition, this portion of DA-100 also involves the optimization of model performance by removing rows and columns, changing data types, managing aggregations, etc. Finally, the entrant should also know how to create semi-additive measures.
- Deployment and maintenance deliverables (10-15%)
The fifth and final section of DA-100 exam includes managing datasets. The candidate must be able to configure dataset scheduled refresh and row-level security. They are also expected to have an idea about giving access to data sets, incremental refresh settings, and certifying datasets. Moreover, the entrant is required to be well-informed about creating and managing workspaces. They should be able to create and configure workspaces, assign roles in the workspace, and manage the workspace app. Knowing how to import, export, update, and publish workspace assets will be essential. Finally, the candidate needs to know about applying sensitivity labels in workspace contents. The entrant also needs to be capable of identifying downstream data set dependencies and using deployment pipelines.
- Visualizing the data (20-25%)
The third domain will test the applicant's know-how of creating reports, dashboards, and enriching reports for usability. This will require the candidate's expertise in adding visualization to reports, choosing a proper visualization style, formatting visualizations, slicing and filtering applications, configuring a report page, building automatic page refresh, etc. The knowledge of R and Python visuals will also be beneficial. Furthermore, it is also essential for the entrant to know how to set dashboard to mobile view, manage tiles, configure data alerts, arrange aspects of the dashboard, and pin live reports. Finally, the applicant needs to enrich the reports by configuring bookmarks, creating custom tooltips, sorting & configuring various Sync Slicers, designing reports for mobile devices, etc.
NEW QUESTION 55
You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.
Which report setting should you configure?
- A. Allow users to add comments to this report.
- B. Choose the type of data you allow your end users to export.
- C. Enable the updated filter pane, and show filters in the visual header for this report.
- D. Change default visual interaction from cross highlighting to cross filtering.
- E. Don't allow end user to save filters on this report.
Answer: B
Explanation:
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/
NEW QUESTION 56
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 Power Apps visual that contains a drop-down list. The drop-down list will contain the business
- B. Create a button for each business question and set the action type to Bookmark.
- C. Create a text box for each business question and insert a link.
Answer: B
Explanation:
questions.
When you create a bookmark, the following elements are saved with the bookmark: - The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state - Visual selection state (such as cross-highlight filters) - Sort order - Drill location - Visibility of an object (by using the Selection pane) - The focus or Spotlight modes of any visible object
NEW QUESTION 57
You have the data lineage shown in the following exhibit.
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:
Explanation
Text, table Description automatically generated with medium confidence
Box 1: CONTOSO BIKES report
Box 2: three datasets
Images, tweets and the Contoso datasets.
NEW QUESTION 58
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
Answer:
Explanation:
NEW QUESTION 59
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. Merge tables by using Power Query.
- C. Split the model into multiple models.
- D. Transpose.
Answer: B
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 60
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:
NEW QUESTION 61
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. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
- B. Remove the Subject and Body columns during the import.
- C. From Model view, set the Subject and Body columns to Hidden.
Answer: B
NEW QUESTION 62
You have the visual shown in the Original exhibit. (Click the Original tab.)
You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)
What should you add to the visual?
- A. a forecast
- B. a measure
- C. a trendline
- D. an Average line
Answer: A
NEW QUESTION 63
You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.
You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
- A. Request that the sales manager be added to the correct Azure Active Directory group.
- B. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
- C. Manage the permissions of the underlying dataset
- D. Change the Microsoft Power Bl license type of the sales manager.
Answer: A
Explanation:
Explanation
Using AD Security Groups, you no longer need to maintain a long list of users.
All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.
Note: Configure role mappings
Once published to Power BI, you must map members to dataset roles.
Members can be user accounts or security groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security group memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.
Reference:
https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
NEW QUESTION 64
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 65
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 66
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the Store_ID column.
What should you do before you create the relationship?
- A. In the Store table query, use the Table.TrasformRows function.
- B. In the Order table query, use the Table.TrasformColumnTypes function.
- C. In the Order table query, use the Table.TrasformRows function.
- D. In the Store table query, use the Table.TrasformColumnTypes function.
Answer: D
NEW QUESTION 67
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 68
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 69
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
Which four 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 - Transpose the table
2 - Unpivot all the columns other than Measure
3 - Rename the Measure column as year
4 - Change the data type of the year column to Date
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
NEW QUESTION 70
You have the line chart shown in the exhibit. (Click the
You need to modify the chart to meet the following requirements:
* Identify months that have order counts above the mean.
* Display the mean monthly order count.
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
1. Select the line chart
2. Add the average line
3. Turn on Data Label
NEW QUESTION 71
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 72
What is the minimum number of Power BI datasets needed 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 73
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 group on the state column and set the Group type to Bin.
- B. Create a new aggregation that summarizes by employee.
- C. Create a new aggregation that summarizes by state.
- D. Create a new group on the state column and set the Group type to List.
Answer: A
Explanation:
With grouping you are normally working with dimensional attributes.
Here we add three new groups (East, West, and North) and add each state to the appropriate group.
Reference:
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/
NEW QUESTION 74
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 75
You have the Power BI data model shown in the following exhibit.
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 76
You build a report to analyze customer transactions from a database that contains the tables shown in the following table.
You import the tables.
Which relationship should you use to link the tables?
- A. one-to-many from Transaction to Customer
- B. many-to-many between Customer and Transaction
- C. one-to-one between Customer and Transaction
- D. one-to-many from Customer to Transaction
Answer: C
NEW QUESTION 77
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?
- A. In the Monthly_returns table, create a new calculated column named Date_ID that uses the ddmmyyyy format.
- B. In the Date table, create a new calculated column named Month_ID that uses the yyyydd format.
- C. To the Date table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
- D. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
Answer: A
Explanation:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
NEW QUESTION 78
......
DA-100 Dumps With 100% Verified Q&As - Pass Guarantee or Full Refund: https://certblaster.lead2passed.com/Microsoft/DA-100-practice-exam-dumps.html
