DA-100 Free Practice Test

- (Exam Topic 4)
You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
Which three 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.

Solution:
1) Duplicate Customer query
2) Group by CustId by Max ModifiedDate (only 2 columns to keep)
3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

1. A. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
2. B. From Power Bi Desktop, use the Auto date/time option when creating the reports.
3. C. From Power Query, add a date tabl
4. D. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.
5. E. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter ofthe ShippedDate column, and the calendar month of the ShippedDate column

Correct Answer: D

- (Exam Topic 4)
You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

1. A. Group the impressions by Ad_id, Site_name, and Impression_date.Aggregate by using the CountRows function.
2. B. Create one-to-many relationships between the tables.
3. C. Create a calculated measure that aggregates by using the COUNTROWS function.
4. D. Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Correct Answer: BC

- (Exam Topic 1)
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target]
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 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?

1. A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
2. B. Get data from a SharePoint Online list and enter the site UR
3. C. Edit the query and filter by the path to the manufacturing reports library.
4. D. Get data from a SharePoint Online folder and enter the site UR
5. E. Edit the query and filter by the path to the manufacturing reports library.
6. F. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Correct Answer: C
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 the 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/