Microsoft DA-100 Analyzing Data with Microsoft Power BI Online Training
Microsoft DA-100 Online Training
The questions for DA-100 were last updated at Dec 19,2024.
- Exam Code: DA-100
- Exam Name: Analyzing Data with Microsoft Power BI
- Certification Provider: Microsoft
- Latest update: Dec 19,2024
What is the minimum number of datasets and storage modes required to support the reports?
- A . two imported datasets
- B . a single DirectQuery dataset
- C . two DirectQuery datasets
- D . a single imported dataset
HOTSPOT
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.
DRAG DROP
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.
HOTSPOT
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
You need to grant access to the business unit analysts.
What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Which DAX expression should you use to get the ending balances in the balance sheet reports?
- A . CALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
DATESQTD( ‘Date'[Date] )
) - B . CALCULATE (
SUM( BalanceSheet [BalanceAmount] ),
LASTDATE( ‘Date'[Date] )
) - C . FIRSTNONBLANK ( ‘Date’ [Date]
SUM( BalanceSheet[BalanceAmount] )
) - D . CALCULATE (
MAX( BalanceSheet[BalanceAmount] ),
LASTDATE( ‘Date’ [Date] )
)
You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?
- A . Create a shared dataset for each standardized entity.
- B . Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
- C . For every report, create and use a single shared dataset that contains the standardized data.
- D . For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.
Topic 3, Misc. Questions
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order .
What should you configure in Microsoft Power Bl Desktop?
- A . the bookmark order
- B . the layer order
- C . the tab order
- D . the X position
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 . Yes
- B . No
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 modify the source step of the queries to use DataSourceExcel as the file path.
Does this meet the goal?
- A . Yes
- B . No
Latest DA-100 Dumps Valid Version with 114 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
