Shop Categories

 [email protected]
Search
View Cart
Checkout

The following DA-100 questions are part of our Microsoft DA-100 real exam questions full version. There are 131 in our DA-100 full version. All of our DA-100 real exam questions can guarantee you success in the first attempt. If you fail DA-100 exam with our Microsoft DA-100 real exam questions, you will get full payment fee refund. Want to practice and study full verion of DA-100 real exam questions? Go now!

 Get DA-100 Full Version

Microsoft DA-100 Exam Actual Questions

The questions for DA-100 were last updated on Sep 07,2021 .

Viewing page 1 out of 4 pages.

Viewing questions 1 out of 20 questions

Question#1

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

Explanation:
Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Reference: https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

Question#2

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

Explanation:
The WHERE clause has its effects before the data is imported.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

Question#3

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

Explanation:
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

Question#4

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.

Question#5

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] ) )

Explanation:
Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.
Reference: https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

Exam Code: DA-100Q & A: 131 Q&AsUpdated:  Sep 07,2021

 Get DA-100 Full Version
 About DA-100 Questions

TOP Exams