The latest Microsoft DA-100 dumps by Lead4Pass helps you pass the DA-100 exam for the first time! Lead4Pass Latest Update Microsoft DA-100 VCE Dump and DA-100 PDF Dumps, Lead4Pass DA-100 Exam Questions Updated, Answers corrected! Get the latest LeadPass DA-100 dumps with Vce and PDF: https://www.leads4pass.com/da-100.html (Q&As: 104 dumps)
[Free DA-100 PDF] Microsoft DA-100 Dumps PDF can be collected on Google Drive shared by Lead4Pass:
https://drive.google.com/file/d/1eOZjNEltGpUTfWUFi76ANbrFrxdNz94t/
[Lead4pass DA-100 Youtube] Microsoft DA-100 Dumps can be viewed on Youtube shared by Lead4Pass
Microsoft DA-100 Online Exam Practice Questions
QUESTION 1
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 add a Power Apps custom visual to the report.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
QUESTION 2
HOTSPOT
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.
Hot Area:
Correct Answer:
QUESTION 3
HOTSPOT
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.
Hot Area:
Correct Answer:
QUESTION 4
You are modeling data by using Microsoft Power Bl. 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 write a DAX expression that uses the FILTER function.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
QUESTION 5
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com. they can see which
dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact
on the
dashboard design.
What should you use?
A. Active Directory groups
B. tiles
C. data classifications
D. comments
Correct Answer: A
QUESTION 6
You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table.
Date lD 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. (SUN(sales[sales_araount]) – CALCULATE(SUM(sales[sales_amount]),
SAHEPERIOOLASTYEAR(\\’Date\\'[DatelD]))/ CALCULATE(SUM(sales[sales_amount]), SAMEPERIOOLASTYEAR
(\\’Date\\'[DateID])
D. CALCULATE(SUH(sales[sales_araount]), SAMEPERIODLASTYEAR(\\’Date\\'[DatelD])
Correct Answer: D
QUESTION 7
DRAG DROP
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are
named appropriately for the data that they contain.
Select and Place:
QUESTION 8
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-many from Customer to Transaction
B. one-to-one between Customer and Transaction
C. one-to-many from Transaction to Customer
D. many-to-many between Customer and Transaction
Correct Answer: A
QUESTION 9
What should you create to meet the reporting requirements of the sales department?
A. a calculated column that uses a formula of couMTA(Sales[sales_id]>
B. a calculated measure that uses a formula of couNTROws(Sales)
C. a calculated column that uses a formula of suM(Sales[sales_id])
D. a measure that uses a formula of SW-i(Sales[sales_id])
Correct Answer: B
QUESTION 10
DRAG DROP
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.
Select and Place:
Correct Answer:
QUESTION 11
HOTSPOT
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: “Hi. I\\’ve put 24 files of monthly transaction data onto the shared drive. File
Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files
Transactions201801.csv
to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50
transactions.”
You get data from the folder and select Combine and Load. The Combine Files dialog box is shown in the exhibit. (Click
the Exhibit 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.
Hot Area:
QUESTION 12
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to
the related and related table functions. You need to recommend a solution to minimize the use of related and related table functions. What should you recommend?
A. Merge tables by using Power Query. )
B. Hide unused columns in the model. )
C. Split the model into multiple models.
D. Transpose.
Correct Answer: A
QUESTION 13
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. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
B. Change the Microsoft Power Bl license type of sales manager.
C. Manage the permissions of the underlying dataset
D. Request that the sales manager be added to the correct Azure Active Directory group.
Correct Answer: A
latest updated Microsoft DA-100 exam questions from the Lead4Pass DA-100 dumps! 100% pass the DA-100 exam! Download Lead4Pass DA-100 VCE and PDF dumps: https://www.leads4pass.com/da-100.html (Q&As: 104 dumps)
Get free Microsoft DA-100 dumps PDF online: https://drive.google.com/file/d/1eOZjNEltGpUTfWUFi76ANbrFrxdNz94t/
