Official Microsoft Practice Assessment Q&A Breakdown (DP-700)
Official Microsoft Practice Assessment Q&A Breakdown (DP-700)
Source
- Provider: Microsoft Learn Official Practice Assessment
- Content type: Curated Official Practice Questions & Verified Explanations
- Target Exam: Exam DP-700
- Date captured: 2026-08-15
- Last reviewed: 2026-08-15
Item 1
Question: You need to optimize read performance for Power BI Direct Lake mode on large Delta tables in a Microsoft Fabric Lakehouse. What setting is applied by default when writing Delta tables via Microsoft Fabric engines?
- A) Parquet Snappy Compression only
- B) Microsoft VertiPaq V-Order sorting
- C) Gzip Compression
- D) CSV indexing
Correct Answer: B
Explanation: V-Order is a write-time optimization algorithm applied by default in Microsoft Fabric that reorders in-memory data before writing parquet files, achieving VertiPaq-level read speeds for Power BI Direct Lake and SQL queries.
Item 2
Question: You need to implement Row-Level Security (RLS) on a table in a Fabric Lakehouse for business analysts who query data using the SQL analytics endpoint. What is the minimum workspace permission you should grant to these analysts?
- A) Contributor
- B) Member
- C) Viewer
- D) Admin
Correct Answer: C
Explanation: Users with Viewer role access data strictly through the read-only SQL Analytics Endpoint where Row-Level Security (RLS) predicates are evaluated. Users with Contributor, Member, or Admin permissions have write/admin rights that bypass RLS unless specifically restricted.
Item 3
Question: Which KQL operator allows you to dynamically parse a JSON string column into strongly typed variables during query execution?
- A)
parse_json() - B)
to_json() - C)
json_extract() - D)
cast_json()
Correct Answer: A
Explanation: In KQL, parse_json() interprets a string expression as a dynamic JSON object or array, enabling property path navigation (e.g. Parsed.property.subproperty).