DP-600 Practice Test
Tests readiness for Microsoft's DP-600 Fabric Analytics Engineer Associate exam — maintaining and securing Fabric workspaces, ingesting and transforming data with pipelines, dataflows and notebooks, working with lakehouses and warehouses, building semantic models in Direct Lake, and optimising and deploying solutions. Pass to earn DP-600 Exam Readiness SOA-DP60.
- Advanced difficulty.Assumes years in the role or deep specialist knowledge.
- 25 scenario questions
- 25 minutes, timed
- 70% to pass · 90% for distinction
- Free no sign-up needed
- LinkedIn-ready · add it to your profile in one clickSee how ↓
What is the DP-600 Practice Test?
The DP-600 Practice Test is a free advanced-level, 25-minute skill test from Science of Apps. It tests readiness for Microsoft's DP-600 Fabric Analytics Engineer Associate exam — maintaining and securing Fabric workspaces, ingesting and transforming data with pipelines, dataflows and notebooks, working with lakehouses and warehouses, building semantic models in Direct Lake, and optimising and deploying solutions. Score 70% or more on its 25 questions to earn a verifiable DP-600 Exam Readiness certificate (SOA-DP60). Every question is based on published standards and research — including What is a lakehouse in Microsoft Fabric? (Microsoft Learn), Data Factory in Microsoft Fabric (Microsoft Learn), Introduction to deployment pipelines (Microsoft Learn) — and each answer is explained with its source.
Built for your job title
Analytics engineer, BI developer, Power BI developer, Data engineer and Data analyst moving to Fabric — and anyone who wants quick, verifiable proof of DP-600 skills for a CV or LinkedIn.
- Analytics engineer
- BI developer
- Power BI developer
- Data engineer
- Data analyst moving to Fabric
What the test covers
Five skill areas with 5 questions each, drawn from a bank of 10 per area, so a retake brings questions you haven't seen.
- 01
Workspaces, Security and Governance
20%- Workspace roles
- Data security
- Governance
- 02
Getting and Transforming Data
20%- Pipelines
- Dataflows Gen2
- Notebooks and Spark
- 03
Lakehouse, Warehouse and SQL
20%- Lakehouse vs warehouse
- T-SQL
- Delta table maintenance
- 04
Semantic Models and DAX
20%- Direct Lake and storage modes
- Model design
- Calculation groups
- 05
Deployment and Lifecycle
20%- Deployment pipelines
- Git integration
- Optimisation in production
Independent practice test. Science of Apps is not affiliated with, endorsed by or sponsored by Microsoft. Product and exam names are trademarks of their owners. Passing earns a Science of Apps certificate, not the official exam credential.
Based on published standards
The questions are original scenarios, and each one names the public standard, official guide or research it draws on — shown under the question while you answer, and linked in your review. These are the sources behind this test:
- What is a lakehouse in Microsoft Fabric?Microsoft Learn4 questions
- Data Factory in Microsoft FabricMicrosoft Learn4 questions
- Introduction to deployment pipelinesMicrosoft Learn4 questions
- What is Microsoft Fabric?Microsoft Learn3 questions
- What is data warehousing in Microsoft Fabric?Microsoft Learn3 questions
- Row-level security (RLS) with Power BIMicrosoft Learn2 questions
- Endorsement overviewMicrosoft Learn2 questions
- Microsoft Fabric Capacity Metrics appMicrosoft Learn2 questions
- Power Query documentationMicrosoft2 questions
- Delta Lake table optimization and V-OrderMicrosoft Learn2 questions
- Delta Lake documentationLinux Foundation2 questions
- Understand star schema and its importance for Power BIMicrosoft Learn2 questions
- Direct Lake overviewMicrosoft Learn2 questions
- Power BI documentationMicrosoft Learn2 questions
- Introduction to Git integration in FabricMicrosoft Learn2 questions
- Roles in workspacesMicrosoft Learn1 question
- Security for data warehousing in Microsoft FabricMicrosoft Learn1 question
- Sensitivity labels in Power BIMicrosoft Learn1 question
- Dataflow Gen2 overviewMicrosoft Learn1 question
- Dimensional modeling techniquesKimball Group1 question
- Medallion architectureDatabricks1 question
- Calculation groupsMicrosoft Learn1 question
- Semantic model connectivity with the XMLA endpointMicrosoft Learn1 question
- DAX GuideSQLBI1 question
- Manage storage mode in Power BI DesktopMicrosoft Learn1 question
- Incremental refresh and real-time data for semantic modelsMicrosoft Learn1 question
- Use Performance Analyzer to examine report element performanceMicrosoft Learn1 question
Try a sample question
In Microsoft Fabric, a OneLake shortcut lets you
- compress tables to save capacity
- create a Power BI report automatically
- reference data stored elsewhere without copying it
- copy data into a new warehouse every night
Show the answer
C. reference data stored elsewhere without copying it — Shortcuts point to ADLS, S3 or other items. The real test has 25 questions like this.
How the test works
25 minutes, 25 questions
One question per screen, with a progress bar and a countdown. Your progress is saved on this device if you need to pause.
Graded on our server
Answers reach the page only after you submit, so the certificate can only be earned by passing.
Every answer explained
Pass or not, you see every question with the right answer, why, and the source behind it. Pass mark 70%, distinction 90%.
Your certificate
Founder-signed, with a QR code and credential ID. Download PDF or PNG, add to LinkedIn, and it's emailed to you.
What you earn

Pass, then add it to LinkedIn in one click
No typing. The Add to LinkedIn button opens your profile’s Licenses & certifications form already filled in: the certificate name, Science of Apps as the issuer, the issue date, your credential ID and a link recruiters can use to verify it.
- 1Take the 25-minute test
- 2Score 70% or more
- 3Click Add to LinkedIn

DP-600 Exam Readiness
Science of Apps
Show credential ↗Try another skill test
- ProfessionalSOA-PA
Product Analytics Certification
Certifies that you can turn product data into decisions — metrics and instrumentation, funnels and conversion, retention and cohorts, and A/B testing and statistics.
Difficulty: AdvancedEarn Certified Product Analyst → - 10 minSOA-DLIT
Data Literacy Certification
Tests the everyday ability to read, question and communicate with data — chart reading, averages and percentages, data sources, bias and drawing sound conclusions.
Difficulty: BeginnerTake the 10-minute test → - 10 minSOA-XLF
Microsoft Excel Fundamentals Certification
Tests core Excel skills — cell references, essential formulas, sorting and filtering, tables, basic charts, conditional formatting and PivotTables.
Difficulty: BeginnerTake the 10-minute test →
Frequently asked questions
What is the DP-600 Practice Test?
The DP-600 Practice Test is a free advanced-level, 25-minute skill test from Science of Apps. It tests readiness for Microsoft's DP-600 Fabric Analytics Engineer Associate exam — maintaining and securing Fabric workspaces, ingesting and transforming data with pipelines, dataflows and notebooks, working with lakehouses and warehouses, building semantic models in Direct Lake, and optimising and deploying solutions. Score 70% or more on its 25 questions to earn a verifiable DP-600 Exam Readiness certificate (SOA-DP60). Every question is based on published standards and research — including What is a lakehouse in Microsoft Fabric? (Microsoft Learn), Data Factory in Microsoft Fabric (Microsoft Learn), Introduction to deployment pipelines (Microsoft Learn) — and each answer is explained with its source.
How do I take the DP-600 Practice Test for free?
Read the five skill areas on this page, then take the 25-minute test online — no fee, course or sign-up. You see every answer explained when you finish. Score 70% or more and you get a DP-600 Exam Readiness certificate straight away, on screen, as a PDF and by email, with a credential ID anyone can verify.
Are the DP-600 Practice Test questions based on real standards?
Yes. The questions are original scenarios written by Science of Apps, and each one is based on a public source you can read: What is a lakehouse in Microsoft Fabric? (Microsoft Learn); Data Factory in Microsoft Fabric (Microsoft Learn); Introduction to deployment pipelines (Microsoft Learn); What is Microsoft Fabric? (Microsoft Learn); What is data warehousing in Microsoft Fabric? (Microsoft Learn); Row-level security (RLS) with Power BI (Microsoft Learn). The source is shown under each question and linked in the answer review. Science of Apps doesn't copy questions from other tests.
What does the DP-600 Practice Test cover?
Five skill areas with five questions each, drawn from a bank of 10 per area so a retake brings new questions: Workspaces, Security and Governance (Workspace roles, Data security and Governance); Getting and Transforming Data (Pipelines, Dataflows Gen2 and Notebooks and Spark); Lakehouse, Warehouse and SQL (Lakehouse vs warehouse, T-SQL and Delta table maintenance); Semantic Models and DAX (Direct Lake and storage modes, Model design and Calculation groups); Deployment and Lifecycle (Deployment pipelines, Git integration and Optimisation in production). Every question is an original scenario based on a published standard, official documentation or research, named under the question.
Who should take the DP-600 Practice Test?
Analytics engineer, BI developer, Power BI developer, Data engineer and Data analyst moving to Fabric. It suits anyone who wants a quick, verifiable way to show DP-600 skills, from students and career switchers to experienced professionals.
Can I use this for dp 600 exam questions, fabric analytics engineer practice test or dp-600 mock test?
Yes. The DP-600 Practice Test is free and covers all of these: 25 scenario questions in 25 minutes, each answer explained with the source it comes from, so it works as interview and exam practice. It isn't a full course, so use the areas you miss as your study list. Scoring 70% or more earns a verifiable certificate.
Is this the official DP-600 exam?
No. It is an independent practice test written to the publicly available DP-600 content outline, for checking your readiness before you book the real exam. Science of Apps is not affiliated with Microsoft, and passing earns a Science of Apps certificate rather than the official credential.
Can I take the DP-600 Practice Test from any country?
Yes. The test is online, in English and free everywhere — people take it from India, the US, the UK, Europe, Africa, Latin America and Asia-Pacific. Your certificate is dated with your own local date and can be verified from anywhere at scienceofapps.com/certification/verify/.
How long is the DP-600 Practice Test?
25 questions — 5 from each of 5 skill areas — with a 25-minute limit. You need 70% (18 of 25) to pass and 90% for distinction.
How hard is the DP-600 Practice Test?
We rate it Advanced: assumes years in the role or deep specialist knowledge. It has 25 scenario questions — 5 from each of 5 skill areas — and a 25-minute limit. You need 70% (18 of 25) to pass and 90% for distinction.
How much do Science of Apps certifications cost?
Nothing. There is no fee to take a test, to receive the certificate, to have it emailed or to verify it, and no sign-up.
How are the tests graded?
On our server, not in your browser. The answers never reach the page until you submit, so a certificate can only be earned by passing. Each certificate gets a unique credential ID stored by Science of Apps.
What happens if I don't pass?
You see your score for each area and every question with the correct answer and why, with the published source behind it. You can retake after 30 minutes, and the retake draws questions you haven't seen yet.
Do the certificates expire?
No. Every certificate is dated, so it always shows when you passed. Retake a test any time for a newer date or a higher score.
Can I add the certificate to LinkedIn?
Yes. After you pass, Add to LinkedIn opens the Licenses & certifications form with the certificate name, Science of Apps as the issuer, the issue date, your credential ID and the verification link filled in. You can also download it as a PDF or PNG, and it's emailed to you as a PDF.
How can an employer verify my certificate?
Every certificate has a credential ID and a QR code. Scanning it, or entering the ID at scienceofapps.com/certification/verify/, shows the holder's name, the certification, the score and the issue date from our records.
Are these accredited qualifications?
No. They are Science of Apps' own assessments of applied skill. They aren't issued by a university or standards body, and they work best alongside a portfolio that shows the skills in real work.
990 more certifications to collect
Data Analytics & Business Intelligence
- Product Analytics Certification30 min · Advanced
- Data Literacy Certification10 min · Beginner
- Microsoft Excel Fundamentals Certification10 min · Beginner
- Advanced Excel and Formulas Certification15 min · Intermediate
- Excel for Business Analysis Certification15 min · Intermediate
- SQL Fundamentals Certification10 min · Beginner
- Advanced SQL Assessment20 min · Advanced
- Data Cleaning and Preparation Certification15 min · Intermediate
- Data Visualization Fundamentals Certification10 min · Beginner
- Power BI Analyst Assessment15 min · Intermediate
- Tableau Data Visualization Certification15 min · Intermediate
- Google Sheets for Professionals Certification10 min · Beginner
- Python for Data Analysis Certification15 min · Intermediate
- Statistics for Data Analysts Certification15 min · Intermediate
- Business Intelligence Fundamentals Certification10 min · Beginner
- Business Analyst Certification15 min · Intermediate
- Data Storytelling and Presentation Certification10 min · Beginner
- Dashboard Design and KPI Selection Certification15 min · Intermediate
- A/B Testing and Experimentation Certification20 min · Advanced
- Customer and Marketing Analytics Certification15 min · Intermediate
- Data Quality and Governance Certification15 min · Intermediate
- Data Engineering Fundamentals Certification15 min · Intermediate
- Machine Learning Fundamentals Certification15 min · Intermediate
- AI and Machine Learning Model Evaluation Certification20 min · Advanced
- Statistical Reasoning Assessment15 min · Intermediate
- Data-Driven Decision-Making Test10 min · Beginner
- Operations Research Certification20 min · Advanced
- Decision Science & Optimization Certification15 min · Intermediate
- Business Analytics Certification20 min · Intermediate
- Power Query Test20 min · Intermediate
- Big Data Certification20 min · Intermediate
- Data Warehouse Certification20 min · Intermediate
- dbt Certification Test20 min · Intermediate
- PySpark & Apache Spark Test20 min · Intermediate
- Snowflake SnowPro Core Practice Test20 min · Intermediate
- Databricks Data Engineer Associate Practice Test20 min · Intermediate
- ETL & Data Pipeline Test20 min · Intermediate
- Data Modeling Certification20 min · Intermediate
- Predictive Analytics Certification20 min · Intermediate
- PL-300 Practice Test20 min · Intermediate
- Pandas Quiz20 min · Intermediate
- NumPy Quiz20 min · Intermediate
- scikit-learn Quiz20 min · Intermediate
- R Programming Test20 min · Intermediate
- DP-900 Practice Test15 min · Beginner
- DP-600 Practice TestYou're here
- DP-700 Practice Test25 min · Advanced
- CompTIA Data+ Practice Test20 min · Intermediate
- AWS Data Analytics Certification Test20 min · Intermediate
- Azure Data Analytics Certification Test20 min · Intermediate
- Google Cloud Data Analytics Certification Test20 min · Intermediate
- Matplotlib Quiz20 min · Intermediate
Foundation
AI & Generative AI
- AI UX Design Certification30 min · Advanced
- Prompt Engineering Certification30 min · Intermediate
- AI Product Manager Certification30 min · Advanced
Software Engineering & Web Development
- HTML and CSS Fundamentals Certification10 min · Beginner
- JavaScript Fundamentals Certification10 min · Beginner
- TypeScript Fundamentals Certification15 min · Intermediate
Digital Marketing, SEO, AEO & Growth
- Conversion Rate Optimization (CRO) Certification30 min · Advanced
- App Store Optimization (ASO) Certification30 min · Intermediate
- Growth Marketing Certification30 min · Intermediate
UX/UI, Design, Research & Creative
- UX Design Certification30 min · Intermediate
- UI Design Certification30 min · Intermediate
- Product Design Certification30 min · Intermediate
Product, Project Management & Business Analysis
- Product Manager Certification30 min · Intermediate
- Design Leadership Certification30 min · Advanced
- Agile Product Owner Certification30 min · Intermediate
Cybersecurity, IT, Cloud & DevOps
- Cybersecurity Fundamentals Certification10 min · Beginner
- Security Awareness and Phishing Detection Certification10 min · Beginner
- Network Security Fundamentals Certification15 min · Intermediate
Sales, Customer Success & Support
- Sales Fundamentals Certification10 min · Beginner
- Consultative Selling Certification15 min · Intermediate
- B2B Sales Development Representative Certification10 min · Beginner
Human Resources & People Management
- Human Resources Fundamentals Certification10 min · Beginner
- Talent Acquisition and Recruitment Certification10 min · Beginner
- Technical Recruitment Certification15 min · Intermediate
Finance, Accounting, Operations & Entrepreneurship
- Financial Literacy for Professionals Certification10 min · Beginner
- Accounting Fundamentals Certification10 min · Beginner
- Bookkeeping Fundamentals Certification10 min · Beginner
Communication, Leadership & Transferable Skills
- Critical Thinking Test10 min · Beginner
- Attention to Detail Test10 min · Beginner
- Cognitive Bias Test10 min · Beginner
Languages
- English Level Test30 min · Beginner
- American Sign Language (ASL) Foundations Test25 min · Intermediate
- App & Software Localization Test25 min · Intermediate
Healthcare, Education, Legal Operations & Sustainability
- Healthcare Administration Fundamentals Certification10 min · Beginner
- Medical Office Administration Certification10 min · Beginner
- Healthcare Data Privacy Awareness Certification10 min · Beginner
Test Prep, Academics & Aptitude
- SAT Math Practice Test20 min · Advanced
- SAT Reading and Writing Practice Test20 min · Advanced
- ACT Practice Test (English, Math, Reading & Science)20 min · Advanced
Language Exam Prep
- IELTS Academic Practice Test with Band Score20 min · Advanced
- IELTS General Training Practice Test20 min · Advanced
- TOEFL iBT Practice Test20 min · Advanced
Office & Productivity Software
- Microsoft Word Skills Certification15 min · Intermediate
- Microsoft PowerPoint Skills Certification15 min · Intermediate
- Microsoft Outlook Skills Certification10 min · Beginner
Engineering, Architecture, Construction & Safety
- Mechanical Engineering Practice Test (FE-Style)20 min · Advanced
- Electrical Engineering Practice Test (FE-Style)20 min · Advanced
- Civil Engineering Practice Test (FE-Style)20 min · Advanced
Hospitality, Travel & Retail
- Hospitality Management Certification10 min · Beginner
- Food Safety Certification10 min · Beginner
- Hotel Revenue Management Certification15 min · Intermediate
Cognitive Ability & Pre-Employment Tests
- IQ Test20 min · Intermediate
- Numerical Reasoning Test20 min · Intermediate
- Verbal Reasoning Test20 min · Intermediate
Read before you test
- Career guidesHow to get a Power BI developer job in 2027: data models, DAX and the report that wins the interviewHow to get a Power BI developer job in 2027: the data modelling and DAX skills employers test, PL-300, the interview loop, India pay and a 12-week plan.
- Career guidesAdvanced Excel test for jobs in 2027: XLOOKUP, dynamic arrays, Power Query and what analyst interviews really checkHow to pass an advanced Excel test for analyst jobs in 2027: XLOOKUP, dynamic arrays, LET, Power Query, data models, real test tasks with answers and a plan.
- Career guidesHow to get a data engineer job in 2027: pipelines, modelling and the system-design round that decides itHow to get a data engineer job in 2027: the SQL, Python and pipeline-design skills employers test, the interview loop, India and global pay, and a 12-week plan.
- Career guidesAdvanced SQL interview questions for data jobs in 2027: window functions, CTEs, performance and the patterns senior roles testAdvanced SQL interview questions for senior analyst, analytics engineer and data engineer jobs in 2027: window functions, CTEs, gaps and islands, performance.
- Career guidesHow to get a BI analyst job in 2027: warehouses, KPIs and the trust that makes reports get usedHow to get a BI analyst job in 2027: the warehouse, modelling and KPI skills employers test, the interview loop, pay in India and a 12-week plan.
- Career guidesC++ developer jobs in 2027: modern C++, memory, performance and the interviews in systems, games and tradingC++ developer jobs in 2027: the modern C++, memory, concurrency and performance skills employers test in systems, games and trading, with pay.
Get the ideas, not the noise.
Sign up with Google and we’ll send you short UX psychology tips by email — why people tap, stall and leave, and what to do about it. Unsubscribe anytime. Prefer something to keep? Get the free Laws of UX guide as a PDF.
Founder, Science of Apps




