Step2Study

Microsoft Azure Data Fundamentals practice questions

248 free questions with answers and explanations.

Practice test
  1. 1.A data architect is designing a new relational database in Azure. The database will store customer information, including names, addresses, and phone numbers. The architect needs to ensure that each customer record has a unique identifier that is automatically generated and incremented with each new record. Which SQL Server feature should the architect use for the customer ID column?Describe how to work with relational data on Azure
  2. 2.A retail company uses Azure Blob Storage to store millions of customer receipts as PDF files. They need to implement a solution that provides specific permissions to different departments, ensuring that the marketing department can only read receipts, while the finance department can read and delete receipts. Access should be managed using Azure Active Directory identities. Which Azure management task is most appropriate for this scenario?Describe how to work with non-relational data on Azure
  3. 3.A company is redesigning its online product catalog. The catalog contains millions of items, each with various attributes such as name, description, price, and multiple images. The data is semi-structured, and the schema can evolve over time as new product attributes are introduced. Queries need to be fast and support filtering by various attributes. Which Azure non-relational data service is the most suitable for this scenario?Describe how to work with non-relational data on Azure
  4. 4.A large enterprise stores sensitive customer data in Azure Blob Storage. They need to implement a robust access control mechanism that integrates with their existing Azure Active Directory (AAD) identity system. Access should be granted based on job roles and responsibilities, rather than managing shared access signatures (SAS) or account keys for individual users. Which Azure security feature should be used to achieve this?Describe how to work with non-relational data on Azure
  5. 5.A research institution needs to store petabytes of raw scientific data, including high-resolution images, video streams, and experimental results. This data will be infrequently accessed for long-term archival purposes, but when accessed, retrieval speed is not a critical concern. Cost-effectiveness for storage is paramount. Which Azure Blob Storage access tier is the MOST suitable for this scenario?Describe how to work with non-relational data on Azure
  6. 6.A financial institution is designing a new relational database in Azure to store customer account information. Due to regulatory compliance, all data at rest must be encrypted. Which Azure SQL Database feature should be implemented to meet this requirement without requiring application changes?Describe how to work with relational data on Azure
  7. 7.A company is designing a data warehouse solution using Azure Synapse Analytics. They need to store historical sales data in a relational format that is optimized for analytical queries across petabytes of data. Which type of table distribution should they choose for their fact tables in Azure Synapse Analytics dedicated SQL pool?Describe how to work with relational data on Azure
  8. 8.A global e-commerce platform uses Azure Cosmos DB to store product catalog information. To ensure high availability and low-latency reads for users worldwide, the platform needs to distribute its data across multiple Azure regions and allow any region to accept write operations. Which Cosmos DB feature should be enabled?Describe how to work with non-relational data on Azure
  9. 9.A data analytics team needs to store petabytes of raw sensor data from IoT devices for long-term analysis. The data will be ingested in real-time, often consisting of small, individual files. The team requires a cost-effective storage solution that supports a hierarchical namespace for organization and is optimized for analytical workloads, including integration with Spark and Hadoop. Which Azure service is the most appropriate choice?Describe how to work with non-relational data on Azure
  10. 10.A retail company uses Azure Blob Storage to store millions of customer receipts as PDF files. Due to compliance regulations, these receipts must be retained for a minimum of seven years. However, after the first year, they are rarely accessed. To optimize storage costs while ensuring compliance, which Azure Blob Storage access tier should be used for receipts older than one year?Describe how to work with non-relational data on Azure
  11. 11.A media company needs to store millions of video and audio files, each potentially gigabytes in size. These files will be accessed frequently by users worldwide for streaming. The company requires a highly scalable and durable storage solution that can handle large unstructured data. Which Azure service is the most appropriate choice?Describe how to work with non-relational data on Azure
  12. 12.A data engineer needs to ingest a continuous stream of JSON log data from various applications into Azure for real-time analytics. The data schema is semi-structured and can vary slightly over time. The solution needs to support high-volume ingestion and allow for flexible querying of the JSON data. Which Azure non-relational data service is the most appropriate for storing this data?Describe how to work with non-relational data on Azure
  13. 13.A financial services company stores transactional data in Azure Cosmos DB. The company requires a strong consistency guarantee for critical transactions to ensure that all users see the most up-to-date data immediately after a write operation. Which consistency level should be configured for the Cosmos DB account?Describe how to work with non-relational data on Azure
  14. 14.A database administrator is tasked with ensuring data integrity and consistency across multiple tables in an Azure SQL Database. Specifically, when a row in the 'Customers' table is deleted, all corresponding orders in the 'Orders' table must also be deleted. Which relational database concept should the administrator implement?Describe how to work with relational data on Azure
  15. 15.A company is considering migrating its on-premises PostgreSQL database to Azure. The database experiences highly fluctuating workloads, with periods of intense activity followed by long periods of inactivity. The company wants a cost-effective solution that automatically scales compute resources up and down based on demand, and pauses billing during inactive periods. Which Azure Database for PostgreSQL deployment option should they choose?Describe how to work with relational data on Azure
  16. 16.A global software company maintains customer data across multiple regions using Azure Database for MySQL. They need to create a new database user account that can only view data from a specific table named 'Customers' in the 'Sales' database. The user should not be able to modify, insert, or delete any data. Which SQL command should be used to grant these specific permissions?Describe how to work with relational data on Azure
  17. 17.A financial company uses Azure Database for PostgreSQL to store customer transaction data. Due to increasing demand during peak hours, the database is experiencing performance bottlenecks, specifically with read-heavy analytical queries. The company needs to offload these read workloads from the primary database to improve overall responsiveness. Which Azure Database for PostgreSQL feature should be utilized?Describe how to work with relational data on Azure
  18. 18.A research institution is collecting massive amounts of scientific data, including high-resolution images, video streams, and experimental results, totaling hundreds of terabytes. This data needs to be stored cost-effectively for long-term retention (over 10 years) and accessed very rarely, typically only for specific historical research projects. When accessed, retrieval time can be several hours. Which Azure storage solution is the most appropriate for this scenario?Describe how to work with non-relational data on Azure
  19. 19.A data architect is designing a relational database for an e-commerce platform in Azure. The database includes a 'Categories' table and a 'Products' table, where each product belongs to a category. When a category is deleted, all associated products should also be automatically deleted to maintain data consistency. Which referential integrity action should be configured on the foreign key constraint?Describe how to work with relational data on Azure
  20. 20.A media company is developing a new video streaming platform. They need to store millions of video and audio files, each potentially gigabytes in size. These files will be frequently accessed by users worldwide, requiring high availability and low-latency streaming. Which Azure Storage service is the most appropriate for this requirement?Describe how to work with non-relational data on Azure
  21. 21.A financial institution needs to store audit logs for regulatory compliance. These logs are generated continuously and need to be retained for seven years. While the logs are rarely accessed after initial ingestion, they must be highly durable and accessible when needed. Cost-effectiveness for long-term storage is a primary concern. Which Azure Blob Storage access tier is the most appropriate for these audit logs?Describe how to work with non-relational data on Azure
  22. 22.A global online gaming platform uses Azure Cosmos DB to store player profiles, game statistics, and leaderboards. They need to ensure that regardless of where a player connects from, they experience very low latency when accessing their data. The platform also requires high availability, even in the event of a regional outage. Which Azure Cosmos DB feature should be implemented to meet these requirements?Describe how to work with non-relational data on Azure
  23. 23.A data architect is designing a relational database for an e-commerce platform in Azure. They need to enforce a rule that if a category is deleted from the `Categories` table, all products belonging to that category in the `Products` table must also be automatically deleted. This ensures data consistency and prevents orphaned records. Which referential integrity action should be configured on the foreign key constraint between `Products` and `Categories`?Describe how to work with relational data on Azure
  24. 24.A company is designing a new application that requires a highly scalable relational database service in Azure. The application needs to support automatic patching, backups, and high availability with minimal administrative overhead. Which Azure relational data service should the company choose?Describe how to work with relational data on Azure
  25. 25.A data engineer is working with an Azure SQL Database. They need to retrieve all customers who have placed an order but also want to include customers who have not placed any orders. The result should show customer details and any associated order details where they exist. Which type of JOIN operation should be used?Describe how to work with relational data on Azure
  26. 26.A data analyst is querying an Azure SQL Database that contains sales data. They need to retrieve all orders placed in the 'North' region where the 'OrderTotal' is greater than $500. Which SQL clause should the analyst use to filter the results based on these conditions?Describe how to work with relational data on Azure
  27. 27.A company is developing a new mobile application that needs to store semi-structured data for user preferences and application settings. The data must be highly available globally and support low-latency reads and writes. Which Azure non-relational data service is the most appropriate choice?Describe how to work with non-relational data on Azure
  28. 28.A logistics company uses Azure Queue Storage to manage delivery orders. Each order is a message that needs to be processed by a fleet management system. The company needs to ensure that if a message fails to process due to a temporary issue, it is not lost and is re-queued for another attempt. Which message property or queue mechanism facilitates this requirement?Describe how to work with non-relational data on Azure
  29. 29.A data analytics team needs to store petabytes of raw sensor data from IoT devices for long-term analysis. The data is ingested continuously, and analysts require a file system-like interface with hierarchical directories for organizing the data. They also need strong consistency for file operations to ensure data integrity during complex analytical workloads. Which Azure non-relational data service is the most suitable?Describe how to work with non-relational data on Azure
  30. 30.A company is developing a new social media application that needs to store highly interconnected data, such as user friendships, likes, and comments. This data requires efficient traversal of relationships. Which Azure Cosmos DB API should they choose?Describe how to work with non-relational data on Azure
  31. 31.A data analyst is querying a large table in Azure SQL Database that stores historical sales data. Queries frequently filter by a `SaleDate` column, but performance is slow. The `SaleDate` column is currently not indexed. Which basic management task should the analyst recommend to improve query performance on this column?Describe how to work with relational data on Azure
  32. 32.A data engineer is working with an Azure SQL Database. The database stores sensor readings where each reading has a unique identifier that needs to be automatically generated and incremented for every new record. Which property should be assigned to the SensorID column to achieve this?Describe how to work with relational data on Azure
  33. 33.A manufacturing company uses legacy applications that rely heavily on Apache Cassandra for their operational data store. They want to migrate these applications to Azure without significant code changes. Which Azure Cosmos DB API would provide the most straightforward migration path?Describe how to work with non-relational data on Azure
  34. 34.A global manufacturing company needs to store machine telemetry data from thousands of devices. This data needs to be queried quickly for real-time dashboards and predictive maintenance. The data structure is dynamic and can change frequently as new sensors are added. Which Azure non-relational data service is the MOST appropriate for this scenario?Describe how to work with non-relational data on Azure
  35. 35.A web application generates a high volume of small, transient messages that need to be processed asynchronously by backend workers. The messages should be ordered, and the system needs to guarantee at-least-once delivery. Which Azure non-relational data service is best suited for this messaging pattern?Describe how to work with non-relational data on Azure
  36. 36.A research institution stores petabytes of raw scientific data, including high-resolution images, video files, and experimental results. This data is rarely accessed after initial ingestion but must be retained for regulatory compliance and potential future analysis for decades. Which Azure Blob Storage access tier is the most cost-effective for this scenario?Describe how to work with non-relational data on Azure
  37. 37.A data engineer is working with an Azure SQL Database. They need to create a table that will store employee records, and each employee must have a unique employee ID. This ID should be automatically generated by the database when a new employee record is inserted. Which column property should be used for the Employee ID column?Describe how to work with relational data on Azure
  38. 38.A company is migrating an on-premises SQL Server database to Azure. The database contains several features, including SQL Server Agent jobs, cross-database queries, and Distributed Transaction Coordinator (DTC). The company needs a fully managed service that minimizes refactoring efforts while providing nearly 100% compatibility with their existing SQL Server environment. Which Azure relational data service should they choose?Describe how to work with relational data on Azure
  39. 39.A manufacturing company uses legacy applications that rely heavily on Apache Cassandra for their wide-column data model. The company plans to migrate these applications to Azure without rewriting their data access layer. They need a fully managed, scalable NoSQL database service that is compatible with existing Cassandra drivers and tools. Which Azure Cosmos DB API should they choose?Describe how to work with non-relational data on Azure
  40. 40.A small startup is developing a mobile game that needs to store player high scores and basic player profiles (e.g., player ID, username, last login). The data model is simple, primarily key-value pairs, and the startup needs a highly scalable, low-cost solution without complex indexing or advanced querying capabilities. Which Azure non-relational data service is the most suitable?Describe how to work with non-relational data on Azure
  41. 41.A global online streaming service needs to store user watch history, recommendations, and preferences. This data needs to be available with single-digit millisecond latency worldwide and support multiple data models (document, graph). The service anticipates massive, unpredictable spikes in traffic. Which Azure service is designed to meet these requirements?Describe how to work with non-relational data on Azure
  42. 42.A media company needs to store millions of video and audio files, each potentially gigabytes in size. These files will be ingested, processed, and then served to users via a streaming application. The storage solution must be highly durable, scalable to petabytes, and accessible via HTTP/HTTPS. Which Azure non-relational data service is best suited for storing these large media files?Describe how to work with non-relational data on Azure
  43. 43.A company is migrating an on-premises SQL Server database to Azure. The database contains sensitive customer information and requires high availability with automated failover capabilities. The company needs to minimize management overhead for patching and backups while retaining full SQL Server engine compatibility. Which Azure relational data service should they choose?Describe how to work with relational data on Azure
  44. 44.A data analyst is querying an Azure SQL Database that contains customer order data. They need to retrieve all orders placed in the last 30 days. Which SQL clause is most appropriate for filtering the results based on the order date?Describe how to work with relational data on Azure
  45. 45.A data engineering team needs to store petabytes of raw sensor data from IoT devices for long-term analysis. The data will be ingested continuously and processed using big data analytics frameworks like Apache Spark. A hierarchical namespace is required for efficient organization and access control. Which Azure non-relational data service is most suitable?Describe how to work with non-relational data on Azure
  46. 46.A company is migrating its legacy on-premises SQL Server databases to Azure. The databases contain complex stored procedures, triggers, and SQL Agent jobs that are critical for business operations. The company needs full SQL Server engine compatibility and administrative control. Which Azure relational data service is the most suitable choice?Describe how to work with relational data on Azure
  47. 47.A data engineer is designing a solution to store millions of small files (averaging 10 KB each) generated by IoT devices. These files need to be accessed infrequently for archival purposes and occasional batch processing. Cost optimization is a primary concern. Which Azure Blob Storage access tier is most suitable for this scenario?Describe how to work with non-relational data on Azure
  48. 48.A data architect is designing a new database for a global application that stores customer contact information. Due to compliance requirements, all sensitive customer data, including names and email addresses, must be encrypted at rest within the Azure SQL Database. The architect needs to ensure that the encryption is managed by the service and does not require application-level changes or extensive key management by the customer. Which encryption feature should be used?Describe how to work with relational data on Azure
  49. 49.A developer is creating an application that requires a simple key-value store to maintain user preferences and application settings. The data is structured but does not require complex queries or relationships, and cost-effectiveness is a primary concern. The solution needs to handle a moderate volume of reads and writes. Which Azure non-relational service is the most appropriate?Describe how to work with non-relational data on Azure
  50. 50.A security auditor needs to ensure that access to sensitive documents stored in Azure Blob Storage is managed using fine-grained permissions based on user roles within Azure Active Directory. Which Azure management task is most appropriate for implementing this requirement?Describe how to work with non-relational data on Azure