Real DA-100 are Uploaded by itPass4sure provide 2022 Latest DA-100 Practice Tests Dumps.
All DA-100 Dumps and Analyzing Data with Microsoft Power BI Training Courses Help candidates to study and pass the Analyzing Data with Microsoft Power BI Exams hassle-free!
What is the cost of Exam DA-100: Analyzing Data with Microsoft Power BI
The cost of Exam DA-100: Analyzing Data with Microsoft Power BI is $165.
- Passing Score: 70%
- Number of Questions: 40
- Format: Multiple choices, multiple answers
- Length of Examination: 90 minutes
NEW QUESTION 23
ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.
The table has 12 million rows. All the columns are needed for analysis.
You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.
What should you do?
- A. Round the Longitude column two decimal places.
- B. Split the DateTime column into separate date and time columns.
- C. Disable the Power Query load.
- D. Change the data type of the TempCelsius column to Integer
Answer: C
Explanation:
Disable Power Query load.
Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query-query-load
NEW QUESTION 24
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A. Add a measure to the visual that uses the following DAX expression.
Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],6.40) - B. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- C. Add a measure to the visual that uses the following DAX expression.
Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40) - D. Create a horizontal line that has a fixed value of 24,000.
Answer: B
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart
Add percentile lines to monitor daily revenue
NEW QUESTION 25
You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.
Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter
NEW QUESTION 26
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 27
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
NEW QUESTION 28
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 29
Drag and Drop Question
You receive revenue data that must be included in Microsoft Power Bl reports. You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
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.
Answer:
Explanation:
NEW QUESTION 30
You need to create a solution to meet the notification requirements of the warehouse shipping department.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct select is worth one point:
Answer:
Explanation:
NEW QUESTION 31
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 32
You build a report about warehouse inventory dat
a. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.
Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.
You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.
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.
Answer:
Explanation:
1 - Add a column named ProductName that contains only the text between.....
2 - Create a product hierarchy of ProductCategory.Manafacturer,ProductName, and ProductSpecifications.
3 - Replale the use of ProductDescription in the report with the product hierarchy.
NEW QUESTION 33
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/endofquarter-function-dax
NEW QUESTION 34
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)
What occurred at 12:03:06 PM?
- A. A new transaction was added to the data source.
- B. A user added a comment to a tile.
- C. The dashboard tile cache refreshed.
- D. A user pressed F5
Answer: C
NEW QUESTION 35
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 group on the state column and set the Group type to List.
- B. Create a new aggregation that summarizes by employee.
- 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.
Answer: C
Explanation:
Explanation
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/
NEW QUESTION 36
You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?
- A. line chart
- B. key influences
- C. scatter chart
- D. ribbon chart
Answer: B
Explanation:
Explanation
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
NEW QUESTION 37
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. From the Analytics pane, add an Average line.
- B. Add a play axis.
- C. Add a slicer for the year.
- D. Create a DAX measure that calculates year-over-year growth.
Answer: B
NEW QUESTION 38
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 39
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. Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.
- B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
- C. 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.
Answer: C
NEW QUESTION 40
You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)
What occurred at 12:03:06 PM?
- A. A new transaction was added to the data source.
- B. A user added a comment to a tile.
- C. The dashboard tile cache refreshed.
- D. A user pressed F5
Answer: C
NEW QUESTION 41
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.
- A. Create a calculated measure that aggregates by using the COUNTROWS function.
- B. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
- C. Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRows function. - D. Create one-to-many relationships between the tables.
Answer: A,D
NEW QUESTION 42
You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What should you do?
- A. Add a salary to the tooltips.
- B. Add a salary to the visual filters.
- C. Add salary to the drillthrough fields.
Answer: A
Explanation:
When a visualization is created, the default tooltip displays the data point's value and category.
There are many instances when customizing the tooltip information is useful. Customizing tooltips provides additional context and information for users viewing the visual. Custom tooltips enable you to specify additional data points that display as part of the tooltip.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips
https://technovids.com/power-bi-filters/
NEW QUESTION 43
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.
Answer:
Explanation:
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)
NEW QUESTION 44
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.
From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.
You discover that the dataset refresh fails after the refresh runs out of resources.
What is a possible cause of the issue?
- A. A filter is missing on the report.
- B. Query folding is not occurring.
- C. The data type of the column used to partition the data changed.
- D. You selected Only refresh complete periods.
Answer: B
Explanation:
Explanation
Explanation:
The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called "query folding". It is not recommended that incremental refresh is used when the required query folding cannot take place.
Reference:
https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/
NEW QUESTION 45
......
Valid Way To Pass Microsoft's DA-100 Exam with : https://freetorrent.itpass4sure.com/DA-100-practice-exam.html
