Question 132 — Domain 1-Describe cloud concepts | AZ-900 Practice Exam |170 Questions
Your company is developing an e-commerce platform and needs to choose between a SQL and a NoSQL database for different components of the application. Which database solution should be used for each scenario?
Select two answers.
Use Azure SQL Database for storing customer transactions.
Use Azure Cosmos DB for storing dynamic product catalogs.
Use Azure Synapse Analytics for real-time transaction processing.
Use Azure Data Lake for handling relational customer records.
Correct answers
Use Azure SQL Database for storing customer transactions.
Use Azure Cosmos DB for storing dynamic product catalogs.
Explanations
Correct:
Use Azure SQL Database for storing customer transactions. SQL databases are best suited for structured data with transactional consistency, making them ideal for financial transactions.
Use Azure Cosmos DB for storing dynamic product catalogs. NoSQL databases like Cosmos DB provide flexible, schema-free storage for rapidly changing data structures, making them suitable for product catalogs.
Wrong:
Use Azure Synapse Analytics for real-time transaction processing. Synapse Analytics is designed for querying large datasets and is not optimized for real-time transactional workloads.
Use Azure Data Lake for handling relational customer records. Data Lake is used for unstructured big data storage, not for relational customer records requiring strict consistency.