DP-800: Developing AI-Enabled Database Solutions

By Microsoft · Question Mode

QuestionQ93

VerifiedDesign and develop database solutions

You have an Azure SQL Managed Instance that supports a gaming leaderboard API and contains a table named dbo.Leaderboard.

You plan to reduce write latency during peak events for dbo.Leaderboard.

You need dbo.Leaderboard to support point lookups. The leaderboard data does not need to persist after a restart.

Which table and index types should you configure?

Select
Table type:
Index type:
Explanation

SCHEMA_ONLY memory-optimized tables retain only their schema after a restart and eliminate data logging, which reduces write latency for transient leaderboard data. A HASH index is designed for equality predicates, making it appropriate for point lookups.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!