Free Microsoft Certified: Azure Data Fundamentals Practice Test

A retail company stores customer information in a system where each customer record has a unique identifier and contains fields such as name, email, and phone number. The data is organized in tables with predefined columns. What type of data does this describe?

Your organization needs to process large volumes of streaming data from IoT sensors in real-time and perform aggregations over time windows. Which Azure service is specifically designed for this purpose?

A database administrator needs to ensure that a series of bank transactions either all complete successfully or all fail together, maintaining data consistency. Which database property guarantees this behavior?

You are designing a solution to store product catalog data where each product can have a variable number of attributes depending on the product category. Some products have colors and sizes, while others have technical specifications. What type of Azure database service would be most appropriate?

What is the primary purpose of normalization in relational database design?

A company wants to analyze historical sales data spanning five years to identify trends and create executive dashboards. The data is currently stored in multiple operational databases. Which type of system should they implement?

You need to store JSON documents in Azure Cosmos DB and query them using SQL-like syntax. Which API should you use?

A financial institution requires a database solution that guarantees strong consistency across multiple regions with automatic failover capabilities. Which Azure Cosmos DB consistency level provides the strongest consistency guarantee?

What is the purpose of an index in a relational database?

Your company needs to migrate an on-premises SQL Server database to Azure with minimal code changes and wants to retain features like SQL Server Agent jobs and cross-database queries. Which Azure service should you choose?

A data engineer needs to extract data from multiple sources, transform it by cleaning and aggregating, then load it into a data warehouse. What is this process commonly called?

You need to store large binary files such as videos and images that will be accessed by a web application. The solution should be cost-effective and scalable. Which Azure storage service is most appropriate?

A company is implementing a data warehouse using Azure Synapse Analytics. They need to load large volumes of data efficiently. Which method provides the fastest data loading performance?

What is a primary key in a relational database table?

Your organization needs to create interactive reports and dashboards from data stored in Azure SQL Database and Azure Data Lake. Which Azure service is specifically designed for business intelligence visualization?

A social media application needs to store user profiles, posts, and the relationships between users (who follows whom). The application needs to efficiently query connection patterns like 'friends of friends.' Which type of database is most suitable?

You are designing a data pipeline that needs to orchestrate multiple data movement and transformation activities across different Azure services, with scheduling and monitoring capabilities. Which Azure service should you use?

A global e-commerce company needs a database solution that can provide single-digit millisecond latency for reads and writes anywhere in the world, with multi-region write capabilities. The application stores product catalogs and shopping cart data. Which Azure service best meets these requirements?

What is the difference between vertical scaling and horizontal scaling for database systems?

A data analyst needs to perform complex analytical queries on large datasets stored in Azure Synapse Analytics, joining multiple fact tables with dimension tables and aggregating results. Which component of Azure Synapse Analytics is specifically optimized for this workload?