[Oct-2022] The Best Microsoft Certified: Data Analyst Associate Study Guide for the DA-100 Exam
DA-100 certification guide Q&A from Training Expert ActualPDF
Useful Training Courses to Pass DA-100
To help candidates prepare fully and achieve the best possible result in DA-100, Microsoft provides an official four-day instructor-led training named ‘Course DA-100T00-A: Analyzing Data with Power BI’. It has 13 modules, each focusing on a different area that will be assessed in the exam. Along with each section, there are lab exercises that give candidates the opportunity to apply what they learnt during the sessions. After completing this training, the applicants will be able to analyze technical reports, use Power BI to make paginated reports, handle & distribute report assets, and draw up reports for data analysis. Also, they will be able to effectively enhance, polish, transform, and structure data in a way that facilitates the performance of the business.
However, not everyone can participate in this program as there are certain prerequisites. For instance, learners must be acquainted with the concepts of working with data in the cloud, know how to interact with non-relational and relational data in the cloud, be familiar with the virtualization basics, and finally, understand how to carry out data analysis. If a candidate is missing these necessary requirements, then they can obtain them by first going through the ‘Microsoft Azure Data Fundamentals’ training course and then enrolling in this one.
Moreover, note that the vendor also provides six learning paths for self-study. They are completely free and can be a good first step in your revision for the exam. These modules cover different data analysis areas, such as the use of Power BI, visualization, workspaces’ management, and many more.
NEW QUESTION 26
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.
- B. Create a new aggregation that summarizes by state.
- C. Create a new group on the state column and set the Group type to List.
- D. Create a new group on the state column and set the Group type to Bin.
Answer: D
Explanation:
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 27
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. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
- B. Publish the reports to a different workspace other than the one hosting the datasets.
- C. Publish the reports in an app and grant the HR managers access permission.
- D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
Answer: D
NEW QUESTION 28
You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 custom visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report You need to recommend a solution to improve the performance of the report.
What should you recommend?
- A. Replace the default visuals with custom visuals.
- B. Implement row-level security (RLS).
- C. Split the visuals onto multiple pages.
- D. Increase the number of times that the dataset is refreshed.
Answer: C
Explanation:
Topic 1, Contoso Ltd,
Existing Environment
Contoso, Ltd. is a manufacturing company that produces outdoor equipment Contoso has quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including profit and loss statements for each of the company's four business units, a company balance sheet, and net income projections for the next quarter.
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 to 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.
Net Income Projection Data
Net income projection data is stored in a SharePoint Online list named Projections in the format shown in the following table.
Revenue projections are set at the monthly level and summed to show projections for the quarter.
Balance Sheet Data
The balance sheet data is imported with final balances for each account per month in the format shown in the following table.
There is always a row for each account for each month in the balance sheet data.
Dynamics 365 Business Central Data
Business Central contains a product catalog that shows how products roll up to product categories, which roll up to business units. Revenue data is provided at the date and product level. Expense data is provided at the date and department level.
Business Issues
Historically, it has taken two analysts a week to prepare the reports for the quarterly board meetings. Also, there is usually at least one issue each quarter where a value in a report is wrong because of a bad cell reference in an Excel formula. On occasion, there are conflicting results in the reports because the products and departments that roll up to each business unit are not defined consistently.
Planned Changes
Contoso plans to automate and standardize the quarterly reporting process by using Microsoft Power Bl. The company wants to how long it takes to populate reports to less than two days. The company wants to create common logic for business units, products, and departments to be used across all reports, including, but not limited, to the quarterly reporting for the board.
Technical Requirements
Contoso wants the reports and datasets refreshed with minimal manual effort The company wants to provide a single package of reports to the board that contains custom navigation and links to supplementary information.
Maintenance, including manually updating data and access, must be minimized as much as possible.
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.
The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Report Requirements
You plan to relate the balance sheet to a standard date table in Power Bl in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
Projections must contain a column named RevenueProjection that contains the revenue projection amounts. A relationship must be created from Projections to a table named Date that contains the columns shown in the following table.
The relationships between products and departments to business units must be consistent across all reports.
The board must be able to get the following information from the quarterly reports:
* Revenue trends over time
* Ending balances for each account
* A comparison of expenses versus projections by quarter
* Changes in long-term liabilities from the previous quarter
* A comparison of quarterly revenue versus the same quarter during the prior year
NEW QUESTION 29
You have a CSV file that contains user complaints. The file contains a column named Logged.
Logged contains the date and time each compliant occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?
- A. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- B. Change the data type of the Logged column to Date.
- C. Apply a transform to extract the first 11 characters of the Logged column.
- D. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
Answer: D
Explanation:
Option A: Wrong. There is an '' at '' which makes it impossible.
Option B: Wrong. The LAST 11 cannot get the date info.
Option D: Wrong. You can get the right date, but without '' set it as date '', you will not get built-in date Hierarchy which is required.
NEW QUESTION 30
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:
NEW QUESTION 31
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 32
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
- A. Select Column distribution.
- B. Select Column profile, and then select the sales_amount column.
- C. Transform the sales_amount column to replace negative values with 0.
- D. Select the sales_amount column and apply a number filter.
Answer: B
NEW QUESTION 33
You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table.
A sample of the data in Orders is shown in the following table.
You need to create the following new table.
You must use Customer as the first table.
Which join kind should you use?
- A. Inner
- B. Right Anti
- C. Right Outer
- D. Left Anti
- E. Left Outer
Answer: E
NEW QUESTION 34
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 35
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 36
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:
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
NEW QUESTION 37
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. Create a bookmark for each slicer value.
- B. Replace the slicers with report-level filters.
- C. Replace the slicers with visual-level filters.
- D. Sync the slicers across the pages.
- E. Replace the slicers with page-level filters.
Answer: A,E
NEW QUESTION 38
You have a Power BI report that is configured to use row-level security (RLS).
You have the following roles:
- A manager role that limits managers to see only the sales data from
the stores they manage
- A region role that limits users to see only the data from their
respective region
You plan to use Power BI Embedded to embed the report into an application. The application will authenticate the users.
You need to ensure that RLS is enforced when accessing the embedded report.
What should you do?
- A. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.
- B. In the access token for the application, include the user name and the role name.
- C. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
- D. In the access token for the application, include the report URL and the Microsoft Azure Active Directory domain name.
Answer: B
NEW QUESTION 39
You create a report by using Microsoft Power BI Desktop.
The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?
- A. an OData feed
- B. a subscription
- C. a scheduled refresh of the dataset
- D. an On-premises data gateway
Answer: D
Explanation:
Explanation
When you've created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator.
NEW QUESTION 40
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 41
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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 constant line and set the value to .5.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Explanation
Instead create a percentile line by using the Salary measure and set the percentile to 50%.
Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_percentile.php
NEW QUESTION 42
Hotspot Question
You have a report page that contains the visuals 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 43
......
The Best Microsoft DA-100 Study Guides and Dumps of 2022: https://www.actualpdf.com/DA-100_exam-dumps.html
