Valid DA-100 Exam Q&A PDF DA-100 Dump is Ready (Updated 142 Questions)
Exam Questions and Answers for DA-100 Study Guide
NEW QUESTION 82
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:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
NEW QUESTION 83
You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure 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-influencers
NEW QUESTION 84
You have the dataset shown in the following exhibit.
You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?
- A. Add a Top N filter to the visual.
- B. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the
- C. Configure the Sales Profit measure to use the RANKX function.
- D. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
Answer: A
Explanation:
calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
D18912E1457D5D1DDCBD40AB3BF70D5D
Explanation:
Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.
Note:
Select the Column you want to display the Top Sales Profit
Then change the Filter Type of that Column to Top N
Fill in Top / Bottom number field
And lastly drag to the By Value filed your Sales Profit
Reference:
https://www.tutorialgateway.org/power-bi-top-10-filters/
NEW QUESTION 85
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. Publish the reports to a different workspace other than the one hosting the datasets.
- B. Publish the reports in an app and grant the HR managers access permission.
- C. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
- D. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
Answer: C
NEW QUESTION 86
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:
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 87
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. Publish the reports to a different workspace other than the one hosting the datasets.
- B. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
- C. Publish the reports in an app and grant the HR managers access permission.
- D. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
Answer: A
Explanation:
Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
NEW QUESTION 88
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
CustomerID
Customer City
Customer State
Customer Name
Customer Address 1
Customer Address 2
Customer Postal Code
The Invoice table contains the following fields:
Order ID
Invoice ID
Invoice Date
Customer ID
Total Amount
Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
The number of customers invoiced in each state last month
The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? 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 89
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax
NEW QUESTION 90
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.Unpivot(Source, {"classes"}, "Attribute", "Value")
- B. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),
{"classes.1"}) - C. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
- D. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta
[Serialized.Text = true] in type {itemType}}}), "classes")
Answer: C
NEW QUESTION 91
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 quarter filtered to account categories that are long-term liabilities.
- B. a ribbon chart that shows balances by quarter and accounts in the legend.
- C. a pie chart that shows balances by account category without filters.
- D. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
- E. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
Answer: A,E
Explanation:
Explanation/Reference:
Visualize the Data
Question Set 2
NEW QUESTION 92
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. In the access token for the application, include the report URL and the Microsoft Azure Active Directory domain name.
- D. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
Answer: B
NEW QUESTION 93
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. Create a horizontal line that has a fixed value of 24,000.
- B. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40) - C. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],0.40) - D. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
Answer: D
Explanation:
Explanation
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart
Add percentile lines to monitor daily revenue
NEW QUESTION 94
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. Publish the reports to a different workspace other than the one hosting the datasets.
- B. Publish the reports in an app and grant the HR managers access permission.
- C. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.
- D. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
Answer: C
NEW QUESTION 95
You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?
- A. donut chart
- B. pie chart
- C. scatter plot
- D. area chart
Answer: C
NEW QUESTION 96
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. Sync the slicers across the pages.
- B. Replace the slicers with report-level filters.
- C. Replace the slicers with visual-level filters.
- D. Create a bookmark for each slicer value.
- E. Replace the slicers with page-level filters.
Answer: D,E
NEW QUESTION 97
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 98
You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?
- A. CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR('Date'[DatelD])
- B. (SUN(sales[sales_araount]) - CALCULATE(SUM(sales[sales_amount]),
SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID]) - C. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))
- D. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DatelD])
Answer: A
NEW QUESTION 99
Hotspot Question
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.
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 100
......
Certification dumps - Microsoft Certified: Data Analyst Associate DA-100 guides - 100% valid: https://www.actualtestsit.com/Microsoft/DA-100-exam-prep-dumps.html