Free Analyzing Data with Microsoft Power BI Exam DA-100 Exam Practice Test

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?

• Create a shared dataset for each standardized entity.
• Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
• For every report, create and use a single shared dataset that contains the standardized data.
• 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.

You need to create the On-Time Shipping report.The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?

• scarterplot
• bar chart
• piechart

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 add a Power Apps custom visual to the report.Does this meet the goal?

• Yes
• No

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.What should you recommend?

• Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
• Create one workspace for development. From the new workspace, publish an app for production.
• Create a workspace for development and a workspace for production. From the production workspace, publish an app.
• In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

What should you create to meet the reporting requirements of the sales department?

• a measure that uses a formula of SUM (Sales [sales_id])
• a calculated column that use a formula of COUNTA(sales [sales_id])
• a measure that uses a formula of COUNTROWS (Sales)
• a calculated column that uses a formula of SUM (Sales [sales_id])

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?

• area chart
• donut chart
• scatter plot
• pie chart

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have several reports and dashboards in a workspace.You need to grant all organizational users read access to a dashboard and several reports.Solution: You enable included in app for all assets.Does this meet the goal?

• Yes
• 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 create a new query that references DataSourceExcel.Does this meet the goal?

• Yes
• No

Which DAX expression should you use to get the ending balances in the balance sheet reports?

• CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )
• CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )
• FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )
• CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) )

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?

• Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
• 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.
• 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.
• Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.