Valid DP-201 Dumps shared by ExamDiscuss.com for Helping Passing DP-201 Exam! ExamDiscuss.com now offer the newest DP-201 exam dumps, the ExamDiscuss.com DP-201 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-201 dumps with Test Engine here:
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You are designing an Azure SQL Database that will use elastic pools. You plan to store data about customers in a table. Each record uses a value for CustomerID. You need to recommend a strategy to partition data based on values in CustomerID. Proposed Solution: Separate data into customer regions by using horizontal partitioning. Does the solution meet the goal?
Correct Answer: B
Explanation/Reference: Explanation: We should use Horizontal Partitioning through Sharding, not divide through regions. Note: Horizontal Partitioning - Sharding: Data is partitioned horizontally to distribute rows across a scaled out data tier. With this approach, the schema is identical on all participating databases. This approach is also called "sharding". Sharding can be performed and managed using (1) the elastic database tools libraries or (2) self-sharding. An elastic query is used to query or compile reports across many shards. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-overview