ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 1 question 5 discussion

Actual exam question from Microsoft's DP-700
Question #: 5
Topic #: 1
[All DP-700 Questions]

You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?

  • A. Change the MD5 hash to SHA256.
  • B. Increase the capacity.
  • C. Enable V-Order.
  • D. Modify the surrogate keys to use a different data type.
  • E. Create views.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by IshtarSQL at Dec. 6, 2024, 8:45 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Tuki93
Highly Voted 4 months, 2 weeks ago
Selected Answer: C
Enable V-Order: This should be your first step as it directly targets performance improvements with minimal cost. Consider the following before deciding to disable V-Order: Microsoft Fabric Direct Lake mode depends on V-Order. https://learn.microsoft.com/en-us/fabric/data-warehouse/v-order#performance-considerations
upvoted 13 times
Adriel_1996
1 month ago
What about the limit on the rows limitation (https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview) ?
upvoted 3 times
...
GHill1982
4 months ago
Would V-Order not already be enabled by default?
upvoted 3 times
h2o_molecule
2 months, 2 weeks ago
is V-order automatically enabled on warehouse? No, V-Order is not automatically enabled on a warehouse. You would need to enable it manually to take advantage of its benefits for improved query performance and data compression.
upvoted 2 times
dazero
1 month, 4 weeks ago
V-order is enabled by default.
upvoted 3 times
...
...
Raibeth
2 months, 3 weeks ago
I still have the same doubt.
upvoted 2 times
...
...
...
dazero
Highly Voted 1 month, 4 weeks ago
Selected Answer: B
500 million rows is over the F32 table limit.
upvoted 11 times
el_massakre
1 week, 4 days ago
He's right. When its over the limit the query performance gets reduces by the fallback. https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview#fallback
upvoted 3 times
...
...
CloudKaKida
Most Recent 5 days, 19 hours ago
Selected Answer: B
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-using-event-processor-editor?pivots=enhanced-capabilities Fabric SKU Parquet files per table Row groups per table Rows per table (millions) Max model size on disk/OneLake (GB) Max memory (GB) 1 F2 1,000 1,000 300 10 3 F4 1,000 1,000 300 10 3 F8 1,000 1,000 300 10 3 F16 1,000 1,000 300 20 5 F32 1,000 1,000 300 40 10 F64/FT1/P1 5,000 5,000 1,500 Unlimited 25 F128/P2 5,000 5,000 3,000 Unlimited 50 F256/P3 5,000 5,000 6,000 Unlimited 100 F512/P4 10,000 10,000 12,000 Unlimited 200 F1024/P5 10,000 10,000 24,000 Unlimited 400 F2048 10,000 10,000 24,000 Unlimited 400
upvoted 1 times
...
el_massakre
1 week, 4 days ago
Selected Answer: B
Raise the capacity so Fabric can use DireqtQuery without fallback. https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview#fallback
upvoted 3 times
...
abdulbasit170
2 weeks, 3 days ago
Selected Answer: C
V-order reordering only optimize the queries based on one or two colunns, and Fabric choose those columns under the hood. Unlike Z-order of data bricks. So it does not optimize the queries on all columns, but mostly does the job. Still the best answer by keeping the cost low.
upvoted 1 times
...
yourock43mfamily
2 weeks, 5 days ago
Selected Answer: C
V-order improves read performance
upvoted 1 times
...
SameerL
3 weeks, 1 day ago
Selected Answer: C
The best option is: C. Enable V-Order. Explanation: Best Query Performance: V-Order is an optimization feature in Fabric that improves query performance by organizing Parquet files more efficiently. It enhances compression, speeds up scan performance, and reduces I/O, making it ideal for large datasets like your 500 million-row fact table. Minimize Operational Costs: Enabling V-Order does not require scaling up capacity, unlike option B (Increasing the capacity), which adds costs. It optimizes storage and query performance without additional compute resources.
upvoted 1 times
...
kumarzzz
3 weeks, 6 days ago
Selected Answer: D
My suggestion to be both things To minimize operational costs, you can modify surrogate keys by using a smaller integer data type (e.g., INT instead of BIGINT) and enabling V-order (Virtual Order) for faster data retrieval, if applicable.
upvoted 1 times
...
MultiCloudIronMan
1 month, 2 weeks ago
Selected Answer: C
Changing the surrogate key data type would likely involve significant re-engineering efforts without guaranteeing a performance improvement.
upvoted 2 times
zxc01
4 weeks, 1 day ago
V-Order in fabric warehouse is enabled by default, and you cannot disable it.
upvoted 1 times
...
...
Sher_Lock_Alexa
1 month, 3 weeks ago
Selected Answer: C
V-Order is a highly optimized columnar storage format in Microsoft Fabric that compresses and accelerates queries
upvoted 2 times
...
hebertorosillo
1 month, 4 weeks ago
Selected Answer: D
B. Minimize operational costs is false. A. Distraction. C. Warehouse is not possible in this sentence. V-Order is configured in a notebook because it is incorrect. D. It is true because https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order?tabs=sparksqlit reduces and increments performance by utilizing minimal operational costs.
upvoted 2 times
...
ChenFu
2 months ago
Selected Answer: C
V-Order is a storage optimization format used in Microsoft Fabric for Delta tables. It organizes data in a highly compressed and sorted format, improving query performance while reducing storage costs. Since your reports are based on Direct Lake, enabling V-Order will directly enhance read performance without increasing operational costs. Increasing capacity (B) would add cost, while changing hash keys (A) or modifying data types (D) are more complex and don't guarantee significant performance gains. Creating views (E) does not optimize the underlying storage and, therefore, won't address the root cause effectively.
upvoted 2 times
...
henryphchan
2 months, 1 week ago
Selected Answer: D
V-Ordering is enabled by default in Fabric Datawarehouse. I have created a new datawarehouse and verify the default v-order status: SELECT [name], [is_vorder_enabled] FROM sys.databases; Disabling V-Order is irreversible: once disabled, it cannot be enabled again. So C is not a valid option. https://learn.microsoft.com/en-us/fabric/data-warehouse/v-order
upvoted 2 times
...
clux
2 months, 2 weeks ago
Selected Answer: C
V-Order improves read performance by applying special optimizations such as sorting, row group distribution, dictionary encoding, and compression on Parquet files. This enhances query performance significantly, especially for large datasets. Additionally, V-Order is cost-effective as it reduces the amount of resources needed for reading data, leading to improved performance without increasing operational costs.
upvoted 1 times
...
prabhjot
2 months, 2 weeks ago
Selected Answer: C
i think the answer should be V-order since it will sort data before writing and hence give you better read performance without increasing the capacity which also optimizes on operational costs!
upvoted 1 times
...
h2o_molecule
2 months, 2 weeks ago
Selected Answer: C
V-Order is a columnar storage format that optimizes data storage and retrieval. It can significantly improve query performance and reduce storage costs by compressing data and minimizing the amount of data read during queries. This makes it a suitable choice for large fact tables and scenarios where you need to improve performance without increasing operational costs.
upvoted 1 times
...
robertlavigne
3 months ago
Selected Answer: B
B. Although B is expensive I think it is the only viable option. https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview See the table on Directlake limitations in the above link. For F32 it is 300 million rows before direct query fallback occurs. For F64 it is 1500 million rows. V Order or Key modification don't minimize the row count and won't avoid these limitations. Views aren't supported in DirectLake and will always fallback to direct query so thats not helpful.
upvoted 7 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago