[Jan-2022] DA-100 Dumps are Available for Instant Access using PassTestking
DA-100 Dumps 2022 - New Microsoft DA-100 Exam Questions
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 53
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.Unpivot(Source, {"classes"}, "Attribute", "Value")
- C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),
{"classes.1"}) - D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
Answer: D
NEW QUESTION 54
You have the tables shown in the following table.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
* Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
* Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Create one-to-many relationships between the tables.
- B. Create a calculated measure that aggregates by using the COUNTROWS function.
- C. Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRowsfunction. - D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
Answer: A,C
NEW QUESTION 55
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 layer order
- B. the X position
- C. the bookmark order
- D. the tab order
Answer: A
Explanation:
Topic 2, Litware, Inc. Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
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.
NEW QUESTION 56
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 first 11 characters of the Logged column.
- B. Change the data type of the Logged column to Date.
- C. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
- 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 57
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:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
NEW QUESTION 58
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 59
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
Topic 2, Contoso Ltd, Case Study
Overview
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
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 60
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
NEW QUESTION 61
Drag and Drop Question
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:
NEW QUESTION 62
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 63
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:
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:
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 64
You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?
- A. Trim the Date column.
- B. Round the hour of the Date column to startOfHour.
- C. Split the Date column into two columns, one that contains only the time and another that contains only the date.
- D. Change the data type of the Date column to
Answer: C
Explanation:
Explanation: We have to separate date & time tables. Also, we don't need to put the time into the date table, because the time is repeated every day.
Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.
Reference:
https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi
NEW QUESTION 65
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:
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions
NEW QUESTION 66
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 67
You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)
The related dimension tables are imported into the model.
Sales contains the data shown in the following table.
Answer:
Explanation:
NEW QUESTION 68
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?
- A. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
- B. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
- C. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
- D. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
Answer: A
Explanation:
Reference:
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
NEW QUESTION 69
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:
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 70
......
Ideal Audience and Required Skills
DA-100 is intended for data analysts who use MS Power BI to enhance the value of the data their organization holds. These professionals are responsible for polishing and transforming data, creating expandable data models, and performing data visualizations that can be interpreted and analyzed to withdraw critical information. Data analysts also work alongside other stakeholders of the business to provide relevant data according to their company’s requirements. Thus, a strong prior understanding of both cloud & on-premises data processing and data repositories is also required by those specialists who are going to take test DA-100.
Microsoft DA-100 Exam Practice Test Questions: https://www.passtestking.com/Microsoft/DA-100-practice-exam-dumps.html
Free DA-100 Braindumps Download Updated: https://drive.google.com/open?id=1kKFpbjnXjH1eMnZmgLaYIZUG5y3EpYG_