DP-200 Exam QuestionsBrowse all questions from this exam
Go to Exam

DP-200 Exam - Question 189

DRAG DROP -

A company builds an application to allow developers to share and compare code. The conversations, code snippets, and links shared by people in the application are stored in a Microsoft Azure SQL Database instance. The application allows for searches of historical conversations and code snippets.

When users share code snippets, the code snippet is compared against previously share code snippets by using a combination of Transact-SQL functions including SUBSTRING, FIRST_VALUE, and SQRT. If a match is found, a link to the match is added to the conversation.

Customers report the following issues:

✑ Delays occur during live conversations

✑ A delay occurs before matching links appear after code snippets are added to conversations

You need to resolve the performance issues.

Which technologies should you use? To answer, drag the appropriate technologies to the correct issues. Each technology may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

Exam DP-200 Question 189
Show Answer
Correct Answer:
Exam DP-200 Question 189

Box 1: memory-optimized table -

In-Memory OLTP can provide great performance benefits for transaction processing, data ingestion, and transient data scenarios.

Box 2: materialized view -

To support efficient querying, a common solution is to generate, in advance, a view that materializes the data in a format suited to the required results set. The

Materialized View pattern describes generating prepopulated views of data in environments where the source data isn't in a suitable format for querying, where generating a suitable query is difficult, or where query performance is poor due to the nature of the data or the data store.

These materialized views, which only contain data required by a query, allow applications to quickly obtain the information they need. In addition to joining tables or combining data entities, materialized views can include the current values of calculated columns or data items, the results of combining values or executing transformations on the data items, and values specified as part of the query. A materialized view can even be optimized for just a single query.

References:

https://docs.microsoft.com/en-us/azure/architecture/patterns/materialized-view

Discussion

1 comment
Sign in to comment
hello_there_
Jun 25, 2021

I really don't see how a materialized view is going to help with comparing text with substrings. What would even be in the materialized view? I'd just use memory-optimized table twice.

lgtiza
Jun 29, 2021

I think it should be memory-optimized table for conversations (because this optimizes transactions and insertions in general), and columnstore index (clustered columnstore index in particular) which improves analytics and reporting in general. Matching links qualifies as analytics.