You are designing a data storage solution for a database that is expected to grow to 50 TB. The usage pattern is singleton inserts, singleton updates, and reporting.Which storage solution should you use?
HOTSPOT -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.Hot Area:
DRAG DROP -You have data on the 75,000 employees of your company. The data contains the properties shown in the following table.You need to store the employee data in an Azure Cosmos DB container. Most queries on the data will filter by the Current Department and the EmployeeSurname properties.Which partition key and item ID should you use for the container? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Select and Place:
DRAG DROP -You need to design a data architecture to bring together all your data at any scale and provide insights into all your users through the use of analytical dashboards, operational reports, and advanced analytics.How should you complete the architecture? To answer, drag the appropriate Azure services to the correct locations in the architecture. Each service 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:
HOTSPOT -You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytic in a star schema.You plan to have a fact table for website visits. The table will be approximately 5 GB.You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance.What should you recommend? To answer, select the appropriate options in the answer areaNOTE: Each correct selection is worth one point.Hot Area:
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 HDInsight/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage.The solution requires POSIX permissions and enables diagnostics logging for auditing.You need to recommend solutions that optimize storage.Proposed Solution: Ensure that files stored are larger than 250MB.Does the solution meet the goal?
