Download Analyzing Data with Microsoft Power BI.dump4pass.DA-100.2021-03-16.5e.84q.vcex

File Info

Exam	Analyzing Data with Microsoft Power BI
Number	DA-100
File Name	Analyzing Data with Microsoft Power BI.dump4pass.DA-100.2021-03-16.5e.84q.vcex
Size	6.47 Mb
Posted	March 16, 2021
Downloads	103

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

Question 1

You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?

A: FORMAT('Date'[date], "MMM YYYY")
B: FORMAT('Date' [date], "M YY")
C: FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
D: FORMAT('Date' [date_id], "MMM YYYY")

Correct Answer: D

Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able to see the month in reports as shown in the following example: Feb 2020.

Question 2

You need to review the data for which there are concerns before creating the data model.
What should you do in Power Query Editor?

A: Transform the sales_amount column to replace negative values with 0.
B: Select Column distribution.
C: Select the sales_amount column and apply a number filter.
D: Select Column profile, and then select the sales_amount column.

Correct Answer: A

Scenario: Data Concerns
You are concerned with the quality and completeness of the sales data. You plan to verify the sales data for negative sales amounts.
How to convert negative numbers into positive numb, editor and right click, select transform, and choose absolute value. That would give the positive number outcome you're looking for.
Reference:
https://www.xspdf.com/resolution/50510644.html

Question 3

What is the minimum number of Power BI datasets needed to support the reports?

A: two imported datasets
B: a single DirectQuery dataset
C: two DirectQuery datasets
D: a single imported dataset

Correct Answer: A

Scenario: Data and Sources
Data for the reports comes from three sources. Detailed revenue, cost, and expense data comes from an Azure SQL database. Summary balance sheet data comes from Microsoft Dynamics 365 Business Central.
The balance sheet data is not related to the profit and loss results, other than they both relate dates.
Monthly revenue and expense projections for the next quarter come from a Microsoft SharePoint Online list.
Quarterly projections relate to the profit and loss results by using the following shared dimensions: date, business unit, department, and product category.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand

Question 4

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

A: Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
B: Remove the Subject and Body columns during the import.
C: From Model view, set the Subject and Body columns to Hidden.

Correct Answer: B

Incorrect Answers:
A, C: Does not reduce the size of the model.

Question 5

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: Group the impressions by Ad_id, Site_name, and Impression_date.
Aggregate by using the CountRows function.
B: Create one-to-many relationships between the tables.
C: Create a calculated measure that aggregates by using the COUNTROWS function.
D: Create a calculated table that contains Ad_id, Site_name, and Impression_date.

Correct Answer: AB

Question 6

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

Correct Answer: D

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 7

You open a query in Power Query Editor.
You need to identify the percentage of empty values in each column as quickly as possible.
Which Data Preview option should you select?

A: Show whitespace
B: Column profile
C: Column distribution
D: Column quality

Correct Answer: D

Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.
Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:
Column quality
Column distribution
Column profile
Reference:
https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555

Question 8

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
First name
Last name
Email address
State/Region
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A: Open the Advanced Editor.
B: Select Column quality.
C: Enable Column profiling based on entire dataset.
D: Select Column distribution.
E: Select Column profile.

Correct Answer: CE

Data Profiling, Quality & Distribution in Power BI / Power Query features
To enable these features, you need to go to the View tab à Data Preview Group à Check the following:
Column quality
Column profile
Column distribution

Column profile
Turn on the Column Profiling feature.

Column distribution
Can use it to visually realize that your query is missing some data because of distinct and uniqueness counts.

Reference:
https://www.poweredsolutions.co/2019/08/13/data-profiling-quality-distribution-in-power-bi-power-query/
https://www.altentertraining.com/microsoft/power-bi/column-profiling-is-good/

Question 9

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: Exam simulator is required

Box 1: Table.RemoveColumns
When you do “Remove Columns” Power Query uses the Table.RemoveColumns function
Box 2: List.Select
Get a list of columns.
Box 3: Text.Contains
Example code to remove columns with a slash (/):
let
    Source = Excel.Workbook(File.Contents("C: Source"), null, true),
    #"1_Sheet" = Source{[Item="1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"1_Sheet", [PromoteAllScalars=true]),
// get columns which contains any slash among values
    ColumnsToRemove =
        List.Select(
            // get a list of all columns
            Table.ColumnNames(#"Promoted Headers"),
            (columnName) =>
                let
                    // get all values of a columns
                    ColumnValues = Table.Column(#"Promoted Headers", columnName),
                    // go through values and stop when you find the first occurence of a text containing a slash
                    // if there is a value with a slash, return true else false
                    ContainsSlash = List.AnyTrue(List.Transform(ColumnValues, each Text.Contains(_, "/")))
                in
                    ContainsSlash
        ),
    // remove columns
    Result = Table.RemoveColumns(#"Promoted Headers", ColumnsToRemove)
in
    Result
Reference:
https://community.powerbi.com/t5/Power-Query/Remove-columns-containing-a-certain-value/td-p/759657

Question 10

You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
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.

Correct Answer: Exam simulator is required

Step 1: Expand the records.
First Open Power BI desktop and navigate to Power Query, import the JSON file, then load the data, click on the record to expand it and to see the record and list.
Step 2: Add columns that use data type conversions.
Step 3: Convert the list to a table

CONNECT US

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset