Microsoft Data Analyst Associate exam “DA-100”. Is it really difficult to pass the Microsoft DA-100 exam?
I think that through exam practice and DA-100 exam dumps, 100% of the exam is guaranteed!
You can search for DA-100 in Lead4pass, or directly visit: https://www.leads4pass.com/da-100.html Go directly to the dumps page to get the complete DA-100 exam questions and answers! Ensure that all questions are the latest update and true and effective!
Of course, I recommend that any student first understand some basic information about the test before the test: such as test time, how much money, test focus, practice test, learning path, etc. The official information of Microsoft DA-100 basically gives some answers!
Here, I share a part of Microsoft DA-100 practice questions
All exercise answers will be announced at the end of the article
QUESTION 1
Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a
Microsoft Power BI dashboard. Which type of tile should you add?
A. video
B. custom streaming data
C. text box
D. web content
The only way to visualize a streaming dataset is to add a tile and use the streaming dataset as a custom streaming data
source. Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
QUESTION 2
DRAG-DROP
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role
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.
Select and Place:
Correct Answer:
User 1 = Member User 2 = Contributor https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-newworkspaces
QUESTION 3
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
A. Create a new aggregation that summarizes by the employee.
B. Create a new group on the state column and set the Group type to List.
C. Create a new group on the state column and set the Group type to Bin.
D. Create a new aggregation that summarizes by state.
With grouping, you are normally working with dimensional attributes. Here we add three new groups (East, West, and
North) and add each state to the appropriate group.
Reference: https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/
QUESTION 4
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?
A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine and Load.
B. 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.
C. 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.
D. Get data from a SharePoint Online list, enter the site URL and then select Combine and Load.
Example:
My SharePoint site root URL is https://powerbipanama.sharepoint.com/, but all of my files are actually in another site that
starts with https://powerbipanama.sharepoint.com/sites/externalsales/ URL.
In order to use the correct URL, we need to be in the folder of the data that we\’re trying to get and check the URL that
our browser shows. If it has if it starts with the format of https:///sites/ / then we need to use
that URL, otherwise, we use the much simpler HTTPS://
In my own case, I\’ll be using the https://powerbipanama.sharepoint.com/sites/externalsales URL in order to connect to
my site.
Reference:
https://powerbi.microsoft.com/sv-se/blog/combining-excel-files-hosted-on-a-sharepoint- folder/
QUESTION 5
HOTSPOT
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: 9
9 distinct CSV files.
Box 2: 10
10 distinct dates.
QUESTION 6
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. Edit the details of each tile.
B. Change the report theme.
C. Change the dashboard theme.
D. Create a custom CSS file.
With Power BI Desktop report themes, you can apply design changes to your entire report, such as using corporate
colors, changing icon sets, or applying new default visual formatting. When you apply a report theme, all visuals in your
report use the colors and formatting from your selected theme as their defaults.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes
QUESTION 7
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?
A. Yes
B. No
Instead, modify the source step of the queries to use DataSourceExcel as the file path.
Note: 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 8
You have the visual shown in the exhibit. (Click the Exhibit tab.)
You need to show the relationship between Total Cost and Total Sales over time. What should you do?
A. Add a play axis.
B. Add a slicer for the year.
C. From the Analytics pane, add an Average line.
D. Create a DAX measure that calculates year-over-year growth.
QUESTION 9
You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is
answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?
A. Create a text box for each business question and insert a link.
B. Create a button for each business question and set the action type to Bookmark.
C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.
Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps
that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app, which
updates in real-time as you make changes to your report. Now, your app users can derive business insights and take
actions from right within their Power BI reports and dashboards.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual
QUESTION 10
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
The order 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
The filter is applied after the data is imported. Instead, add a WHERE clause to the SQL statement.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
QUESTION 11
You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting
requirements of the regional managers. What should you do?
A. In the Weekly. Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the
calculated column to create a relationship to the Date table.
B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
C. Create a new table based on the Date table where date-id is unique and then create many to many relationships to
Weekly_Return.
Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a
common column
QUESTION 12
DRAG DROP
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following
exhibit.
You need to prepare the data to support the following:
Visualizations that include all measures in the data over time Year-over-year calculations for all the measures Which
four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the
answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
QUESTION 13
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to
the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
A. Merge tables by using Power Query.
B. Hide unused columns in the model.
C. Split the model into multiple models.
D. Transpose.
Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into
a user query. When you have one or more columns that you\’d like to add to another query, you merge the queries.
Note: The RELATEDTABLE function is a shortcut for the CALCULATETABLE function with no logical expression.
CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-dat
QUESTION 14
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five
minutes of an update.
How should you configure the data connection?
A. Add a SQL statement.
B. Set Data Connectivity mode to DirectQuery.
C. Set the Command timeout in a minutes setting.
D. Set Data Connectivity mode to Import.
With Power BI Desktop, when you connect to your data source, it\’s always possible to import a copy of the data into
the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source
using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and
columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and
measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop
queries the underlying data source, so you\’re always viewing current data.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
QUESTION 15
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged
contains the date and time each complaint occurred. The data in Logged is in the following format: 2018- 12-31 at
08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you
do?
A. Change the data type of the Logged column to Date.
B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to
Date.
C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
D. Apply a transform to extract the first 11 characters of the Logged column.
With Power Query, you can Split Date and Time into Separate Columns by using a transform.
Reference:
https://www.exceljetconsult.com.ng/home/blog/power-query-split-date-and-time-into- separate-columns/
Publish the answer:
| Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | Q14 | Q15 |
| B | image | C | C | image | B | B | A | C | B | A | image | A | B | D |
Microsoft DA-100 exam PDF free sharing
To facilitate the study habits of every student, share the Microsoft DA-100 exam PDF
It is fortunate for all of us to see this article. My sharing is meant to help you successfully pass the exam! Your visit also encourages me to make more contributions! If you like it, you can share it with more good friends! The above is just a part of the lead4Pass DA-100 exam dumps.
Microsoft Data Analyst Associate now only includes the DA-100 exam.
Get the Microsoft Data Analyst Associate exam dumps https://www.leads4pass.com/da-100.html. It’s that simple to pass the exam!