Free Microsoft DA-100 Exam Dumps Questions & Answers

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?

• A.  No
• B.  Yes

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.  data classifications
• B.  tiles
• C.  Active Directory groups
• D.  comments

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

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

You have an API that returns more than 100 columns. The following is a sample of column names.
client_notified_timestamp
client_notified_source
client_notified_sourceid
client_notified_value
client_responded_timestamp
client_responded_source
client_responded_sourceid
client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.
Does this meet the goal?

• A.  No
• B.  Yes