DA-100 試験問題を無料オンラインアクセス

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 a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create an average line by using the Salary measure.
Does this meet the goal?

• A.Yes
• B.No

You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:
A line chart that shows the number of defective products manufactured by day.
A KPI visual that shows the current daily percentage of defective products manufactured.
You need to be notified when the daily percentage of defective products manufactured exceeds 3%.
What should you create?

• A.an alert
• B.a smart narrative visual
• C.a Q&A visual
• D.a subscription

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

• A.CALCULATE (
  MAX( BalanceSheet[BalanceAmount] ),
  LASTDATE( 'Date' [Date] )
  )
• B.CALCULATE (
  SUM( BalanceSheet [BalanceAmount] ),
  DATESQTD( 'Date'[Date] )
  )
• C.CALCULATE (
  SUM( BalanceSheet [BalanceAmount] ),
  LASTDATE( 'Date'[Date] )
  )
• D.FIRSTNONBLANK ( 'Date' [Date]
  SUM( BalanceSheet[BalanceAmount] )
  )

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.Change the dashboard theme.
• B.Create a custom CSS file.
• C.Change the report theme.
• D.Edit the details of each tile.

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: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?

• A.Yes
• B.No