Guaranteed Accomplishment with Newest Dec-2021 FREE Microsoft DA-100
Use Valid New Free DA-100 Exam Dumps & Answers
5. Deliverables Deployment and Maintenance (10-15%):
The topics for this part are the following:
- Workspaces creation and management: The test takers must have competence in assigning workspace roles, using deployment pipeline, updating and configuring workspace apps, and applying sensitivity labels for workspace content. It also requires their skills in importing, updating, and publishing assets in workspaces, as well as recommending the development lifecycle strategy.
- Datasets management: In the framework of this subtopic, the applicants will be evaluated based on their skills in configuring incremental refresh settings, dataset scheduled refresh, and group membership for row-level security. It will also measure their skills in providing access to the datasets and certifying or promoting Power BI content.
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 14
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. video
- D. web content
Answer: D
Explanation:
Reference:
https://docs.microsoft.com/en-us/stream/portal-embed-video
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content
NEW QUESTION 15
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 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
Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
- B. a ribbon chart that shows balances by quarter and accounts in the legend.
- C. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
- D. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
- E. a pie chart that shows balances by account category without filters.
Answer: B,D
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a
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 18
You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 19
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value 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:
Reference:
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax
NEW QUESTION 20
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 new percentile line that uses Total Sales as the measure and 40% as the percentile.
- B. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40) - 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: C
NEW QUESTION 21
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 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. Add the Weekly_Returns data to the Sales table by using related DAX functions.
- C. 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.
Answer: A
NEW QUESTION 22
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-one between Customer and Transaction
- B. one-to-many from Customer to Transaction
- C. one-to-many from Transaction to Customer
- D. many-to-many between Customer and Transaction
Answer: B
Explanation:
Each customer can have many transactions.
For each transaction there is exactly one customer.
NEW QUESTION 23
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform?
Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. Add the same slicer to each page and configure Sync slicers.
- B. Edit the interactions of the KPI visualization.
- C. Edit the interactions of the slicer that is on the same page as the KPI visualization.
- D. Configure a page-level filter.
- E. Configure a report-level filter.
Answer: A,C
Explanation:
Explanation
Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.
By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
NEW QUESTION 24
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.
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://finance-bi.com/power-bi-basket-analysis/
NEW QUESTION 25
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.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
- B. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
- C. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta
[Serialized.Text = true] in type {itemType}}}), "classes") - D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),
{"classes.1"})
Answer: A
NEW QUESTION 26
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
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 27
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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a WHERE clause to the SQL statement.
Does this meet the goal?
- A. No
- B. Yes
Answer: B
Explanation:
The WHERE clause has its effects before the data is imported.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
NEW QUESTION 28
You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? To answer, drag the appropriate values to the correct targets. Each value 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 29
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
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 30
You have a Microsoft Power BI 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 AppSource 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. Change any DAX measures to use iterator functions.
- B. Remove unused columns from tables in the data model.
- C. Change the imported dataset to DirectQuery.
- D. Replace the default visuals with AppSource visuals.
Answer: C
Explanation:
DirectQuery: No data is imported or copied into Power BI Desktop.
Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data.
Benefits of using DirectQuery
There are a few benefits to using DirectQuery:
DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation.
Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data.
The 1-GB dataset limitation doesn't apply to DirectQuery.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
NEW QUESTION 31
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 subscription.
- B. Share the dashboard to the user.
- C. Create a data alert.
- D. Tag the user in a comment.
Answer: C
NEW QUESTION 32
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 Dextop, publish the dataset to powerbi.com.
2 - From Power BI Dextop, create four roles.
3 - From Power BI Dextop, add a Table Filter DAX Expression to the roles.
4 - From powerbi.com. add role member to the roles.
Reference:
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 33
You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?
- A. Use the Test as role option to view data as the salesperson's user account.
- B. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.
- C. Use the Test as role option to view data as the Sales role.
- D. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.
Answer: C
NEW QUESTION 34
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 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. Add the Weekly_Returns data to the Sales table by using related DAX functions.
- C. 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.
Answer: A
Explanation:
Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.
NEW QUESTION 35
You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?
- A. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[2021], "#")
- B. FORMAT('Date' [date_id], "MMM YYYY")
- C. FORMAT('Date'[date], "MMM YYYY")
- D. FORMAT('Date' [date], "M YY")
Answer: C
NEW QUESTION 36
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 page-level filters.
- B. Create a bookmark for each slicer value.
- C. Replace the slicers with report-level filters.
- D. Sync the slicers across the pages.
- E. Replace the slicers with visual-level filters.
Answer: C,D
NEW QUESTION 37
......
What is the Microsoft DA-100 exam?
The Microsoft DA-100 exam is available in English, Japanese, Simplified Chinese, and Korean. The learners can expect 40-60 questions in the delivery of the test with the time allowance of 180 minutes. Depending on where they are taking the exam, it is available as a proctored option or at any Pearson VUE testing center. The candidates can register for this certification exam with Pearson VUE and pay the fee of $165 to schedule it. This price is established for the individuals from the United States. If you sit for the test in another country, you should check the actual price on the official website.
DA-100 Braindumps PDF, Microsoft DA-100 Exam Cram: https://www.fast2test.com/DA-100-premium-file.html