DA-100 Analyzing Data with Microsoft Power BI Exam is qualifying for Microsoft Certified: Data Analyst Associate certification. PassQuestion new released DA-100 Real Questions which give you enough confidence to pass your Microsoft DA-100 exam successfully in your first time. We guarantee that using our DA-100 questions and answers will adequately prepare you for your Microsoft DA-100 exam.

DA-100 Exam Overview - Analyzing Data with Microsoft Power BI

Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As a subject matter expert, Data Analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. Data Analysts also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements. 

Exam Objectives Domain

Prepare the data (20-25%)
Model the data (25-30%)
Visualize the data (20-25%)
Analyze the data (10-15%)
Deploy and maintain deliverables (10-15%)

View Online Analyzing Data with Microsoft Power BI DA-100 Free Questions

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")
Answer: D

2.What is the minimum number of datasets and storage modes required to support the reports?
A. two imported datasets
B. a single DirectQuery dataset
C. two DirectQuery datasets
D. a single imported dataset
Answer: A

3.You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?
A. Round the hour of the Date column to startOfHour.
B. Change the data type of the Date column to Text.
C. Trim the Date column.
D. Split the Date column into two columns, one that contains only the time and another that contains only the date.
Answer: D

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.
Answer: B

5.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
Answer: B

6.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
Answer: D