// microsoft · da-100

// analyzing data with microsoft power bi

DA-100

Prepare for Analyzing Data with Microsoft Power BI (DA-100) with curated, exam-aligned practice questions, explanations, and a study plan focused on real-exam outcomes.

questions

—

in exam

—

duration

Choose your mode

at a glance

What you get

PDF US$10.00Sub US$10/mo

Free practice questions are available without payment; anyone can start practicing at no cost.

access options

PDF bank or platform subscription?

Two separate purchases: a one-time PDF for DA-100, or a monthly subscription for online practice and simulators across the platform. A subscription does not include the PDF download.

option / 01 · pdf file

Full question bank PDF

US$10.00· one-time

Full question bank as a print-ready PDF
Lifetime access to this exam only
Domain-tagged questions with explanations
Separate from online practice — buy once

option / 02 · subscription

All exams · practice & simulator

US$10.00· per month

Practice & exam simulator on every bank
All current and future exams included
Personal analytics and retention tools
Cancel anytime — no per-exam upsells

Subscribe for platform access

sample · 1 of 66Shuffle

See what's in the bank.

4 votes · last validated recently

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.

Duplicate the Date query in Power Query and use active relationships between both Date tables.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

100%

Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

04 · coverage

Exam domains

Prepare the data25%

0 q

Model the data30%

0 q

Visualize the data20%

0 q

Analyze the data15%

0 q

Deploy and maintain deliverables10%

0 q

Uncategorized100%

66 q

community questionsview all →

Questions from the community

Top-voted approved contributions for this exam, reviewed before landing in the bank.

// top community questionsview all →

0.0 · 0 reviews

What candidates say

no reviews yet

Analyzing Data with Microsoft Power BI DA.

Prepare for Analyzing Data with Microsoft Power BI (DA-100) with curated, exam-aligned practice questions, explanations, and a study plan focused on real-exam outcomes.

// OFFICIAL EXAM LOGISTICS

source · microsoft

// PASSING SCORE

750 / 1000· scaled

minimum to pass

75%of scale

// questions

94in bank

// pass rate

92%self-reported

// last update

7h agoago

// add cadence · 12w

// downloadable pdf bank

Get the whole bank as a PDF

Every question tagged by domain, with a detailed explanation. Preview the first pages free — buy once for lifetime access to the full PDF.

94 questions

// what's inside

94 exam-style questions with verified answers
Every question tagged by domain (5 domains covered)
A detailed explanation / rationale for every question

// sample · 1 of 66

See what's in the bank.

Shuffle

#029b9c73-c034-4947-b3aa-48a82b3f545bD1 · Hybridhard

↑ +47· 9 comments· seen 1,284×

Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.

Duplicate the Date query in Power Query and use active relationships between both Date tables.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

100%

Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Community converges on C. Official key confirms.

4 votes · last validated recently

// explanation

BFD with a 300 ms interval × multiplier 3 = 900 ms detection, well under one second. Combined with a redundant Direct Connect at a different DX location, BGP withdrawal handles the cutover cleanly. Tightening BGP timers alone causes flap during normal jitter; switching VIF types is not a failover mechanism.

contributed by

@netdiver· revised by @cloud_chris

← previous

// coverage · 6 domains

What this bank tests.

microsoft exam blueprint

Prepare the data0 q

25%

Model the data0 q

30%

Visualize the data0 q

20%

Analyze the data0 q

15%

Deploy and maintain deliverables0 q

10%

—

Uncategorized66 q

100%

// composition

By format & difficulty.

66 total

// by format

92%

single · 61multi · 5

// contributors · 0 engineers

Built by people who took the exam.

Every question is contributed by someone who recently sat DA-100, then reviewed by an SME before landing in the bank. These are the most prolific contributors.

view leaderboard →

No contributors for this exam yet. Be the first to contribute a question.

// own this exam?Contribute a question, earn +10 points per approval, climb the leaderboard.

// community questions

Questions from the community

Top-voted approved contributions for this exam, reviewed before landing in the bank.

// top community questionsview all →

// compare

One bank, or the whole platform?

this bank

$10.00· one-time

platform · subscribed

$10.00· per month

This bank

All other banks · 23+ exams

Lifetime access

All future updates included

Personal analytics + retention

Cancel anytime

—

// 0 reviews

0.0/ 5

No reviews yet. Be the first to share your experience with this question bank.

// faq

Things buyers ask before they buy.

open help center →

Can I practice for free?

Free practice questions are available without payment; anyone can start practicing at no cost.

What do subscribers get?

Subscribers unlock the full practice question bank for each certification exam.

How much can I see without a subscription?

Approximately 1/2 of the question bank is accessible without a subscription.

// related

DA-100

What you get

PDF bank or platform subscription?

Full question bank PDF

All exams · practice & simulator

See what's in the bank.

Exam domains

Questions from the community

What candidates say

You may also like

Analyzing Data with Microsoft Power BI DA.

Get the whole bank as a PDF

See what's in the bank.

What this bank tests.

By format & difficulty.

Built by people who took the exam.

Questions from the community

One bank, or the whole platform?

Things buyers ask before they buy.

You may also like