Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 3 question 10 discussion

Actual exam question from Microsoft's DP-420
Question #: 10
Topic #: 3
[All DP-420 Questions]

You have a database named db1 in an Azure Cosmos DB Core (SQL) API account named account1.
You need to write JSON data to db1 by using Azure Stream Analytics. The solution must minimize costs.
Which should you do before you can use db1 as an output of Stream Analytics?

  • A. In account1, add a private endpoint
  • B. In db1, create containers that have a custom indexing policy and analytical store disabled
  • C. In db1, create containers that have an automatic indexing policy and analytical store enabled
  • D. In account1, enable a dedicated gateway
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
IDATA
Highly Voted 2 years, 2 months ago
Answer is B Stream Analytics doesn't create containers in your database. Instead, it requires you to create them up front. You can then control the billing costs of Azure Cosmos DB containers, and u dont need to use Analytical Store becosue we dont have ColumnStore
upvoted 7 times
XiangRongChang
1 year, 4 months ago
But a Document databases can use analytical store.
upvoted 1 times
...
...
Blubb1860
Most Recent 10 months, 3 weeks ago
Strange and most likely incomplete or wrong question
upvoted 1 times
...
Garyn
1 year, 1 month ago
To use an Azure Cosmos DB Core (SQL) API database (db1) as an output for Azure Stream Analytics while minimizing costs, you should follow these steps: B. In db1, create containers that have a custom indexing policy and analytical store disabled. Here's why this is the correct option: Custom Indexing Policy: Creating containers with a custom indexing policy allows you to optimize the indexing behavior based on your specific requirements. You can choose to exclude specific properties from indexing if they are not needed for querying. This can help reduce indexing costs. Analytical Store Disabled: The analytical store is used for historical data analysis, and enabling it can add extra cost. If you're primarily using Stream Analytics for real-time data ingestion and processing, you may not need the analytical store. Disabling it can help minimize costs.
upvoted 1 times
...
basiltomato
1 year, 8 months ago
Selected Answer: B
"Stream Analytics doesn't create containers in your database. Instead, it requires you to create them beforehand. You can then control the billing costs of Azure Cosmos DB containers. You can also tune the performance, consistency, and capacity of your containers directly by using the Azure Cosmos DB APIs." https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-documentdb-output#basics-of-azure-cosmos-db-as-an-output-target
upvoted 4 times
...
susejzepol
2 years, 1 month ago
Selected Answer: B
I Think that B is the correct answer because you don't need the Analytical Store.
upvoted 2 times
...
TimSss
2 years, 1 month ago
Selected Answer: B
sure it's not A, but usure about B
upvoted 2 times
...
essdeecee
2 years, 2 months ago
Selected Answer: B
Definitely not A
upvoted 2 times
...
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
Loading ...