Microsoft DA-100 Premium Exam Engine pdf - Download Free Updated 150 Questions
Verified DA-100 Bundle Real Exam Dumps PDF
5. Deliverables Deployment and Maintenance (10-15%):
The topics for this part are the following:
- 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.
- 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.
Exam Topics for Exam DA-100: Analyzing Data with Microsoft Power BI
The following will be discussed in MICROSOFT DA-100 practice exams and MICROSOFT DA-100 practice test:
- Prepare the data
- Visualize the data
- Analyze the data
- Model the data
- Deploy and maintain deliverables
NEW QUESTION 34
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:
Explanation:
Box 1: Table.RemoveColumns
When you do "Remove Columns" Power Query uses the Table.RemoveColumns function Box 2: List.Select Get a list of columns.
Box 3: Text.Contains
Example code to remove columns with a slash (/):
let
Source = Excel.Workbook(File.Contents("C: Source"), null, true),
#"1_Sheet" = Source{[Item="1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"1_Sheet", [PromoteAllScalars=true]),
// get columns which contains any slash among values
ColumnsToRemove =
List.Select(
// get a list of all columns
Table.ColumnNames(#"Promoted Headers"),
(columnName) =>
let
// get all values of a columns
ColumnValues = Table.Column(#"Promoted Headers", columnName),
// go through values and stop when you find the first occurence of a text containing a slash
// if there is a value with a slash, return true else false
ContainsSlash = List.AnyTrue(List.Transform(ColumnValues, each Text.Contains(_, "/"))) in ContainsSlash ),
// remove columns
Result = Table.RemoveColumns(#"Promoted Headers", ColumnsToRemove)
in
Result
Reference:
https://community.powerbi.com/t5/Power-Query/Remove-columns-containing-a-certain-value/td-p/759657
NEW QUESTION 35
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/
NEW QUESTION 36
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?
- A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
- B. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
- C. Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
- D. Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
Answer: C
Explanation:
Example:
My SharePoint site root url is https://powerbipanama.sharepoint.com/, but all of my files are actually in another site that starts with https://powerbipanama.sharepoint.com/sites/externalsales/ URL.
In order to use the correct URL, we need to be in the folder of the data that we're trying to get and check the url that our browser shows. If it has the if it starts with the format of Error! Hyperlink reference not valid. address>/sites/<sitename>/ then we need to use that url, otherwise we use the much simpler Error! Hyperlink reference not valid. address> In my own case, I'll be using the https://powerbipanama.sharepoint.com/sites/externalsales url in order to connect to my site.
Reference:
https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
NEW QUESTION 37
You need to design the data model to meet the report requirements.
What should you do in Power BI Desktop?
- A. From Power Bl Desktop, use the Auto date/time option when creating the reports.
- B. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.
- C. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.
- D. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
Answer: D
Explanation:
Use Power Query to calculate calendar quarter and calendar month.
Scenario:
A single dataset must support all three reports:
- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.
- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category.
The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.
NEW QUESTION 38
You build a report to help the sales team understand its performance and the drivers of sales.
The team needs to have a single visualization to identify which factors affect success.
Which type of visualization should you use?
- A. Line and clustered column chart
- B. Funnel chart
- C. Key influences
- D. Q&A
Answer: C
NEW QUESTION 39
You have the visual shown in the exhibit. (Click the Exhibit tab.)
You need to show the relationship between Total Cost and Total Sales over time.
What should you do?
- A. From the Analytics pane, add an Average line.
- B. Add a play axis.
- C. Create a DAX measure that calculates year-over-year growth.
- D. Add a slicer for the year.
Answer: B
NEW QUESTION 40
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
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
Step 1: Expand the records.
First Open Power BI desktop and navigate to Power Query, import the JSON file, then load the data, click on the record to expand it and to see the record and list.
Step 2: Add columns that use data type conversions.
Step 3: Convert the list to a table
NEW QUESTION 41
ion have a Power B1 dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
- A. Split the DateTime column into separate date and time columns.
- B. Disable the Power Query toad.
- C. Change the data type of the TempCelsius column to Integer
- D. Round the Longitude column two decimal places.
Answer: A
NEW QUESTION 42
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:
Explanation
User 1 = Member
User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
NEW QUESTION 43
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 44
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 are modifying the model to report on the number of orders.
You need to calculate the number of orders.
What should you do?
- A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.
- B. Create a calculated measure that uses the SUM(Order_ID) DAX formula.
- C. Create a calculated column that uses the COUNTA(Order_ID) DAX formula.
- D. Create a calculated column that uses the SUM(Order_ID) DAX formula.
Answer: A
NEW QUESTION 45
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],"MMM YYYY")
- B. FORMAT(,Date,[date_id],"WM YYYY")
- C. FORMAT('Date'[date_id]-''MM") & " " & FORMAT ('Date' [2022], "#")
- D. FORMAT('Date'[date],"M YY")
Answer: C
NEW QUESTION 46
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:
NEW QUESTION 47
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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
Solution: You create a new query that references DataSourceExcel.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
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 48
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 49
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. Change the Microsoft Power Bl license type of the sales manager.
- B. Request that the sales manager be added to the correct Azure Active Directory group.
- C. Manage the permissions of the underlying dataset
- D. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
Answer: B
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 50
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:
Explanation
Box 1: Background color
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
NEW QUESTION 51
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
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
Step 1: Expand the records.
First Open Power BI desktop and navigate to Power Query, import the JSON file, then load the data, click on the record to expand it and to see the record and list.
Step 2: Add columns that use data type conversions.
Step 3: Convert the list to a table
NEW QUESTION 52
......
Exam DA-100 Topics Covered
Test DA-100 measures the entrant's skills in 5 different domains:
- 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.
- 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.
- 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.
- 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.
- 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.
Pass Your Microsoft Exam with DA-100 Exam Dumps: https://www.examcost.com/DA-100-practice-exam.html
DA-100 Dumps PDF New [2022] Ultimate Study Guide: https://drive.google.com/open?id=1efP-ZxWNAiJgJJg0caFMj4nvKsZHHcaC
