BenchMark Quizzes by MDFT Pro

Choose The Best Service To Maintain Relational And NoSQL Data

You work as a data architect for MDFT Pro, a well-known training agency that provides Microsoft certification courses. The company collects various types of data from their learning management system, including structured student records in relational format and unstructured course feedback in JSON format. Mark, the IT director, has asked you to recommend a solution that can store both types of data cost-effectively.

Claire, the database administrator, needs to understand which Azure service would be most suitable for maintaining both relational and NoSQL data in a centralized data store that can handle large volumes and support future analytics workloads.

Which Azure service should you recommend?

Choose the correct answer from the options below.

Explanations for each answer:

Azure Data Factory is incorrect. Azure Data Factory is primarily an integration service for creating data-driven workflows to move and transform data. While it can work with various data sources, it's not designed as a storage solution for maintaining data long-term.
Azure Data Lake Storage is correct. Azure Data Lake Storage Gen2 is designed specifically to handle both relational and NoSQL data formats in a single repository. It supports structured, semi-structured, and unstructured data, making it ideal for organizations that need to store diverse data types cost-effectively while supporting analytics workloads.
Azure Synapse Analytics is incorrect. Azure Synapse Analytics is an analytics service that combines data integration, data warehousing, and analytics. While it can analyze various data types, it's not primarily designed as a storage solution for maintaining raw data.
Azure Cosmos DB is incorrect. Azure Cosmos DB is excellent for NoSQL data but is specifically designed for NoSQL workloads and doesn't maintain relational data in its traditional structure. It's also more expensive for simple data storage scenarios.

Learn more about Azure Data Lake Storage:

Azure Data Lake Storage

Exam Preparation Quiz

Choose The Best Service To Maintain Relational And NoSQL Data