Don't Miss Your Chance! Limited Time Offer | Extra 25% Off - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location Virginia, US

Microsoft DA-100 Exam

Certification Provider: Microsoft
Exam Name: Analyzing Data with Microsoft Power BI
Duration: 180 Minutes
Number of questions in our database: 141
Exam Version: Sep. 16, 2021
DA-100 Exam Official Topics:
  • Topic 1: Define A Relationship's Cardinality And Cross-Filter Direction/ Select A Shared Dataset Or Create A Local Dataset
  • Topic 2: Identify Poorly Performing Measures, Relationships, And Visuals/ Apply User-Friendly Value Replacements
  • Topic 3: Resolve Inconsistencies, Unexpected Or Null Values, And Data Quality Issues
  • Topic 4: Create Hierarchies/ Create Calculated Columns/ Apply User-Friendly Naming Conventions To Columns And Queries
  • Topic 5: Apply Data Shape Transformations To Table Structures/ Configure Table And Column Properties
  • Topic 6: Leverage Advanced Editor To Modify Power Query M Code/ Identify And Create Appropriate Keys For Joins
  • Topic 7: Design The Data Model To Meet Performance Requirements/ Evaluate And Transform Column Data Types
  • Topic 8: Improve Cardinality Levels Through Summarization And By Changing Data Types
  • Topic 9: Define The Appropriate Level Of Data Granularity/ Identify And Connect To A Data Source
  • Topic 10: Use Basic Statistical Functions To Enhance Data/ Apply Cross-Filter Direction And Security Filtering
  • Topic 11: Implement Time Intelligence Using Dax/ Identify Query Performance Issues/ Create Semi-Additive Measures
  • Topic 12: Implement Row-Level Security Roles/ Flatten Out A Parent-Child Hierarchy
  • Topic 13: Resolve Many-To-Many Relationships/ Change Data Source Settings/ Examine Data Structures
  • Topic 14: Use Dax To Build Complex Measures/ Use Calculate To Manipulate Filter
  • Topic 15: Replace Numeric Columns With Measures/ Define Role-Playing Dimensions
  • Topic 16: Set Mobile View/ Manage Tiles On A Dashboard/ Use Drillthrough And Cross Filter
  • Topic 17: Design And Configure For Accessibility/ Choose An Appropriate Visualization Type
  • Topic 18: Edit And Configure Interactions Between Visuals/ Configure Conditional Formatting
  • Topic 19: Drilldown Into Data Using Interactive Visuals/ Pin A Live Report Page To A Dashboard Configure Navigation For A Report/ Format And Configure Visualizations/ Configure Data Classification

Free Microsoft DA-100 Exam Actual Questions

The questions for DA-100 were last updated On Sep. 16, 2021

Question #1

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&

Reveal Solution Hide Solution
Correct Answer: D

You can add synonyms to tables and columns.

Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.


https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices

Question #2

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report

You need to recommend a solution to improve the performance of the report.

What should you recommend?

Reveal Solution Hide Solution
Correct Answer: A

Question #3

You have four sales regions. Each region has multiple sales managers.

You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.

You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.

A sales manager changes to a different region.

You need to ensure that the sales manager can see the correct sales data.

What should you do?

Reveal Solution Hide Solution
Correct Answer: D

Using AD Security Groups, you no longer need to maintain a long list of users.

All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.

Note: Configure role mappings

Once published to Power BI, you must map members to dataset roles.

Members can be user accounts or security groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security group memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.


https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

Question #4

You have five sales regions. Each region is assigned a single salesperson.

You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.

Salespeople must see only the data from their region.

You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.

A salesperson reports that she believes she should see more data.

You need to verify what data the salesperson currently sees.

What should you do?

Reveal Solution Hide Solution
Correct Answer: B

Question #5

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

Reveal Solution Hide Solution
Correct Answer: B

Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.


https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls


Unlock all DA-100 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now
Disscuss Microsoft DA-100 Topics, Questions or Ask Anything Related

Save Cancel