Question 26
You are designing an Azure Synapse solution that will provide a query interface for the data stored in an Azure Storage account. The storage account is only accessible from a virtual network.
You need to recommend an authentication mechanism to ensure that the solution can access the source data.
What should you recommend?
You need to recommend an authentication mechanism to ensure that the solution can access the source data.
What should you recommend?
Question 27
You are designing a storage solution to store CSV files.
You need to grant a data scientist access to read all the files in a single container of an Azure Storage account. The solution must use the principle of least privilege and provide the highest level of security.
What are two possible ways to achieve the goal? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to grant a data scientist access to read all the files in a single container of an Azure Storage account. The solution must use the principle of least privilege and provide the highest level of security.
What are two possible ways to achieve the goal? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Question 28
You are designing a product catalog for a customer. The product data will be stored in Azure Cosmos DB. The product properties will be different for each product and additional properties will be added to products as needed.
Which Cosmos DB API should you use to provision the database?
Which Cosmos DB API should you use to provision the database?
Question 29
You are designing a solution that will use Azure Table storage. The solution will log records in the following entity.
You are evaluating which partition key to use based on the following two scenarios:
* Scenario1: Minimize hotspots under heavy write workloads.
* Scenario2: Ensure that date lookups are as efficient as possible for read workloads.
Which partition key should you use for each scenario? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You are evaluating which partition key to use based on the following two scenarios:
* Scenario1: Minimize hotspots under heavy write workloads.
* Scenario2: Ensure that date lookups are as efficient as possible for read workloads.
Which partition key should you use for each scenario? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 30
Your company is an online retailer that can have more than 100 million orders during a 24-hour period, 95 percent of which are placed between 16:30 and 17:00. All the orders are in US dollars. The current product line contains the following three item categories:
* Games with 15,123 items
* Books with 35,312 items
* Pens with 6,234 items
You are designing an Azure Cosmos DB data solution for a collection named Orders Collection. The following documents is a typical order in Orders Collection.
Order Collection is expected to have a balanced read/write-intensive workload.
Which partition key provides the most efficient throughput?
* Games with 15,123 items
* Books with 35,312 items
* Pens with 6,234 items
You are designing an Azure Cosmos DB data solution for a collection named Orders Collection. The following documents is a typical order in Orders Collection.
Order Collection is expected to have a balanced read/write-intensive workload.
Which partition key provides the most efficient throughput?