Authentic DA-100 Dumps - Free PDF Questions to Pass
Guaranteed Accomplishment with Newest Jan-2022 FREE DA-100
NEW QUESTION 13
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 14
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 15
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:
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
NEW QUESTION 16
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.SplitTextByDelimiterf",", QuoteStyle.None),
{"classes.1"}) - B. =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta
[Serialized.Text = true] in type {itemType}}}), "classes") - C. = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
- D. = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
Answer: C
Explanation:
Explanation
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
Chart Description automatically generated
Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot
NEW QUESTION 17
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.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.SplitTextByPositions({10}), {"classes.1"})
Answer: D
NEW QUESTION 18
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:
NEW QUESTION 19
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. scatter plot
- C. area chart
- D. pie chart
Answer: B
NEW QUESTION 20
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? 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 21
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. SUM(sales[sales_amount]) - CALCULATE(SUM(sales[sales_amount]),
SAMEPERIODLASTYEAR('Date'[DatelD]) - B. CALCULATE(SUM(sales[sales_amount]), DATESYTD('Date'[DatelD]))
- C. CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR('Date'[DatelD])
- D. (SUN(sales[sales_araount]) - CALCULATE(SUM(sales[sales_amount]),
SAHEPERIOOLASTYEAR('Date'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR ('Date'[DateID])
Answer: C
NEW QUESTION 22
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Set the refresh frequency to Daily.
- B. Configure the dataset to use the personal gateway.
- C. Configure the dataset to use the existing On-premises data gateway.
- D. Deploy an On-premises data gateway in personal mode.
Answer: A,D
Explanation:
Explanation
B: The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI.
On-premises data gateway (personal mode) allows one user to connect to sources, and can't be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you're the only person who creates reports, and you don't need to share any data sources with others.
C: For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
NEW QUESTION 23
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. web content
- B. text box
- C. custom streaming data
- D. video
Answer: A
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 24
You have the following three versions of an Azure SQL database:
* Test
* Production
* Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
- A. Create a parameter and update the queries to use the parameter.
- B. Create a JSON file that contains the database server names. Import the JSON file to the dataset.
- C. Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
- D. Create a query for each database server and hide the development tables.
Answer: C
Explanation:
Explanation
With privacy level settings, you can specify an isolation level that defines the degree that one data source must be isolated from other data sources.
An Organizational data source limits the visibility of a data source to a trusted group of people. An Organizational data source is isolated from all Public data sources, but is visible to other Organizational data sources.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/desktop-privacy-levels
NEW QUESTION 25
You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
- A. 21318 Lasalle Street
- B. 0
- C. 1
- D. 21319 Lasalle Street
Answer: D
Explanation:
Explanation
Example:
Replace the text "ur" with the text "or" in the table.
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
NEW QUESTION 26
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)
You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)
What should you do?
- A. Edit the details of each tile.
- B. Change the dashboard theme.
- C. Change the report theme.
- D. Create a custom CSS file.
Answer: B
Explanation:
Explanation
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes#how-dashboard-themes-wor
NEW QUESTION 27
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 area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 28
You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.
In powerbi.com, when users load the visual, they only see some of the customers.
What is the cause of the issue?
- A. The visual was built by using a different version of R.
- B. The data comes from a Microsoft SQL Server source.
- C. The data is deduplicated.
- D. Too many records were sent to the visual.
Answer: D
Explanation:
R visuals in the Power BI service have a few limitations including:
* Data size limitations - data used by the R visual for plotting is limited to 150,000 rows. If more than
150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals
NEW QUESTION 29
You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?
- A. Column distribution
- B. Column quality
- C. Column profile
- D. Show whitespace
Answer: B
Explanation:
Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.
Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:
* Column quality
* Column distribution
* Column profile
Reference:
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555
NEW QUESTION 30
You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders.
The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.
City[State Province] = "Kentucky"
Role2 contains the following filter.
Date[Calendar Year] = 2020
If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
- A. The user will receive an error and will not be able to see the data in the report.
- B. The user will see data for which the State Province value is Kentucky and the Calendar Year is
2020. - C. The user will see only data for which the State Province value is Kentucky.
- D. The user will see data for which the State Province value is Kentucky or the Calendar Year is
2020.
Answer: D
Explanation:
When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
NEW QUESTION 31
You have the line chart shown in the exhibit. (Click the Exhibit tab.)
You need to modify the chart to meet the following requirements:
* Identify months that have order counts above the mean.
* Display the mean monthly order count.
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: Create a 12-month...
You can use calculated measure to get the expected result.
1. Create a calculated column for the date.
2. Create a measure for 12 months moving average.
3. Drag the Line Chart into your canvas as below. (step 2 below)
Step 2: Select the line chart
Step 3: From the Analytics pane, add a Median line
Reference:
https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041
NEW QUESTION 32
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 33
You build a report about warehouse inventory data. The dataset has more than 10 million product records from
200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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
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 address the data concerns before creating the data model.
What should you do in Power Query Editor?
- A. Transform the sales_amount column to replace negative values with 0.
- B. Select Column distribution.
- C. Select Column profile, and then select the sales_amount column.
- D. Select the sales_amount column and apply a number filter.
Answer: B
NEW QUESTION 35
You have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. AJI 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. Round the Longitude column two decimal places.
- B. Change the data type of the TempCelsius column to Integer.
- C. Split the Longitude column into two columns at the decimal point.
- D. Disable the Power Query load.
Answer: D
NEW QUESTION 36
......
DA-100 Braindumps PDF, Microsoft DA-100 Exam Cram: https://pass4sure.practicedump.com/DA-100-exam-questions.html