Step2Study

Microsoft Azure Data Fundamentals practice questions

248 free questions with answers and explanations.

Practice test
  1. 51.A media company is developing a new video streaming platform. They need to store millions of video files, each potentially several gigabytes in size, and deliver them efficiently to users worldwide. The solution must support both live streaming and on-demand content. Which Azure non-relational data service is the most appropriate choice for storing these video files?Describe how to work with non-relational data on Azure
  2. 52.A development team is building a high-performance web application that requires storing millions of small key-value pairs. Each key-value pair represents a user setting and needs extremely low-latency read and write access. The data does not require complex queries or relationships. Which Azure non-relational data service is the most cost-effective and performant for this specific requirement?Describe how to work with non-relational data on Azure
  3. 53.A company is designing a new application that will store user profiles, including their preferences and activity logs. The data schema for user profiles is expected to evolve frequently, and the application needs to handle a large volume of concurrent read and write operations with low latency. Which type of Azure non-relational data service is best suited for this scenario?Describe how to work with non-relational data on Azure
  4. 54.A developer is creating a new table in an Azure SQL Database that will store product information. Each product must have a unique identifier that is automatically generated and incremented by 1 each time a new product is added. The identifier should start at 1000. Which SQL Server property should be used for this column?Describe how to work with relational data on Azure
  5. 55.An IoT solution collects telemetry data from thousands of devices. Each device sends a small message (e.g., sensor reading, device status) every few seconds. The data needs to be stored for a short period (e.g., 24 hours) for immediate processing and then transferred to cold storage. Which Azure non-relational storage service is most appropriate for ingesting and temporarily storing these high-volume, small messages for short-term access?Describe how to work with non-relational data on Azure
  6. 56.A company is migrating its on-premises application that uses Apache Cassandra to Azure. The application requires high availability, linear scalability, and multi-region replication with low latency. The development team wants to minimize code changes and leverage their existing Cassandra skills and tools. Which Azure non-relational data service is the most appropriate for this migration?Describe how to work with non-relational data on Azure
  7. 57.A company is migrating its existing on-premises application that heavily relies on Apache Cassandra to Azure. The application requires high availability, linear scalability, and a familiar Cassandra Query Language (CQL) interface. Which Azure Cosmos DB API is the most appropriate for this migration?Describe how to work with non-relational data on Azure
  8. 58.A manufacturing company uses legacy applications that rely heavily on Apache Cassandra for their operational data. The company wants to migrate these applications to Azure without rewriting their data access layer. Which Azure Cosmos DB API should they use to minimize code changes?Describe how to work with non-relational data on Azure
  9. 59.A software development team is building a new application that requires storing large amounts of unstructured text data, such as customer reviews and social media posts. This data will be infrequently accessed after initial ingestion but needs to be retained for compliance and future analytics. Which Azure non-relational storage service and access tier combination is the most cost-effective for this scenario?Describe how to work with non-relational data on Azure
  10. 60.A global e-commerce company uses Azure Database for MySQL to power its storefront. Due to rapid growth, the database is experiencing high read traffic from multiple regions, leading to performance bottlenecks. Write operations are centralized, but read operations need to scale out globally with low latency. Which Azure Database for MySQL feature should be implemented to address this challenge?Describe how to work with relational data on Azure
  11. 61.A global e-commerce platform uses Azure Cosmos DB to store product catalog information. To ensure maximum data availability and minimal downtime, the platform needs to withstand regional outages with no data loss and maintain a strong consistency guarantee for critical operations, while still providing low-latency reads globally. Which consistency level, combined with global distribution, best meets these requirements?Describe how to work with non-relational data on Azure
  12. 62.A developer needs to quickly provision a NoSQL database for a new prototype application. The application requires a flexible schema and the ability to store JSON documents. The developer wants to use a service that is easy to set up and manage, without worrying about infrastructure. Which Azure non-relational database service is the most suitable for this prototyping phase?Describe how to work with non-relational data on Azure
  13. 63.A company is storing millions of sensor readings from IoT devices in Azure Blob Storage. Each reading includes a timestamp, device ID, and several numerical values. The company needs to analyze this data periodically for trends and anomalies using big data analytics tools like Azure Databricks. Which access tier is most cost-effective for storing this data, assuming it is accessed infrequently after initial ingestion but needs to be readily available for analytical jobs?Describe how to work with non-relational data on Azure
  14. 64.A financial institution is migrating its on-premises document database to Azure. The database stores customer transaction records in JSON format and requires high throughput for both reads and writes, along with flexible schema capabilities. Which Azure Cosmos DB API is the most natural fit for this migration?Describe how to work with non-relational data on Azure
  15. 65.A data architect is designing a relational database in Azure. They need to ensure that when a row in a parent table is deleted, all corresponding rows in a child table are also automatically deleted to maintain data integrity. Which referential integrity action should be configured on the foreign key constraint?Describe how to work with relational data on Azure
  16. 66.A global gaming company needs to store player profiles, game statistics, and leaderboards. Player profiles are frequently updated, game statistics are written frequently but read less often, and leaderboards require very low latency reads and writes for real-time updates. The data model is mostly document-oriented with some nested structures. Which Azure non-relational data service provides the necessary flexibility, performance, and global distribution for all these requirements?Describe how to work with non-relational data on Azure
  17. 67.A data engineer is designing a data ingestion pipeline for real-time telemetry data from thousands of IoT devices. Each telemetry event is a small JSON document. The solution requires high throughput, low latency reads and writes, and flexible schema support for evolving data models. Which Azure Cosmos DB API is the most appropriate choice?Describe how to work with non-relational data on Azure
  18. 68.A data engineer is working with an Azure SQL Database. The database stores sensor readings, and the `ReadingValue` column needs to store precise numerical data, such as temperature or pressure, which can have varying numbers of digits before and after the decimal point. The maximum value expected is 999.99999, and the minimum is -99.99. Which data type should be chosen to ensure accuracy and minimize storage waste?Describe how to work with relational data on Azure
  19. 69.A company uses Azure SQL Database for its transactional workloads. The database administrator wants to improve the performance of frequently executed queries that involve filtering and sorting on specific columns. Which database object should the administrator create to achieve this goal?Describe how to work with relational data on Azure
  20. 70.A company is developing a new IoT solution that will collect telemetry data from thousands of devices. Each device sends a small message (around 1 KB) every minute. These messages need to be temporarily stored before being processed by a backend service. The processing order is not critical, but messages should generally be processed in the order they were received. Which Azure storage service is most suitable for this scenario?Describe how to work with non-relational data on Azure
  21. 71.A development team is building a new application that processes a large volume of small, independent tasks. Each task generates a message that needs to be temporarily stored and then picked up by an available worker process. The system needs to ensure that each message is processed at least once, even if a worker fails. Which Azure non-relational data service is most suitable for managing these tasks?Describe how to work with non-relational data on Azure
  22. 72.A global online gaming platform uses Azure Cosmos DB to store player profiles, game statistics, and leaderboards. To ensure players worldwide experience low-latency access and high availability, the platform architect wants to configure Cosmos DB to allow writes to any of its globally distributed regions. Which feature of Azure Cosmos DB allows this configuration?Describe how to work with non-relational data on Azure
  23. 73.A company is migrating an existing on-premises SQL Server database to Azure. The database has complex stored procedures, functions, and triggers that rely heavily on SQL Server-specific features. The company requires full compatibility with their existing SQL Server code and minimal application refactoring. Which Azure relational data service is the most suitable choice?Describe how to work with relational data on Azure
  24. 74.A global e-commerce platform uses Azure Cosmos DB to store product catalog information. To ensure that users around the world experience the fastest possible response times, the platform needs to distribute its data across multiple Azure regions and allow writes to be performed in any of these regions. Which Cosmos DB feature enables this capability?Describe how to work with non-relational data on Azure
  25. 75.A data analyst needs to query data from two tables, 'Sales' and 'Products', in an Azure SQL Database. The analyst wants to retrieve all sales records along with matching product information where available, but also wants to see sales records even if there is no corresponding product information. Which type of JOIN operation should the analyst use?Describe how to work with relational data on Azure
  26. 76.A company is building an application that needs to store IoT device telemetry data. This data consists of simple, structured records (e.g., device ID, timestamp, temperature, humidity) that are frequently written and occasionally queried by device ID or timestamp range. The company requires a highly scalable, low-cost solution for storing billions of these entities, where global distribution and advanced querying capabilities (like joins or aggregations) are not a primary concern. Which Azure non-relational data service is the most appropriate?Describe how to work with non-relational data on Azure
  27. 77.A company is migrating its on-premises application that uses Apache Cassandra to Azure. The application requires high availability, global distribution, and needs to minimize code changes during migration. Which Azure non-relational data service should they choose to host their Cassandra database?Describe how to work with non-relational data on Azure
  28. 78.A development team is building a new application that processes a large volume of small, independent messages. These messages need to be stored temporarily, processed asynchronously by backend workers, and automatically deleted after successful processing. Which Azure non-relational data service is most appropriate for this scenario?Describe how to work with non-relational data on Azure
  29. 79.A financial institution is implementing a new system to store audit logs for regulatory compliance. These logs must be immutable, retained for 7 years, and infrequently accessed after initial writing. Which Azure non-relational data service and access tier combination is most cost-effective for this scenario?Describe how to work with non-relational data on Azure
  30. 80.A company is migrating an existing on-premises application that heavily uses Apache Cassandra to Azure. The application requires a database service that is fully compatible with Cassandra's query language (CQL) and drivers, offers high availability, and can scale globally with minimal code changes. Which Azure non-relational data service should the company choose?Describe how to work with non-relational data on Azure
  31. 81.A company is developing a new social media application that needs to store highly interconnected user data, including friendships, likes, and comments. The application frequently performs complex traversals to find relationships between users, such as 'friends of friends' or 'users who liked a specific post and are also friends with another user'. Which Azure Cosmos DB API is most appropriate for this scenario?Describe how to work with non-relational data on Azure
  32. 82.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 to minimize costs by only paying for compute resources when the database is actively used. Which Azure Database for PostgreSQL deployment option best meets these requirements?Describe how to work with relational data on Azure
  33. 83.A manufacturing company is migrating its existing on-premises application that heavily relies on Apache Cassandra to Azure. The application requires a database service that is compatible with existing Cassandra drivers and tools, and can scale horizontally to handle large volumes of time-series data from IoT sensors. Which Azure Cosmos DB API should the company choose?Describe how to work with non-relational data on Azure
  34. 84.A small startup is developing a mobile game that needs to store player high scores and basic player profiles (username, ID). The data volume is expected to be low to medium, and the primary access pattern is simple key-value lookups. Cost-effectiveness is a major concern. Which Azure non-relational data service is the most appropriate choice?Describe how to work with non-relational data on Azure
  35. 85.A company is redesigning its online product catalog. The catalog contains millions of items, each with varying attributes (e.g., color, size, material for clothing; RAM, CPU for electronics). The application needs to query products quickly based on these flexible attributes and support frequent updates. Which Azure Cosmos DB API is most appropriate for this scenario?Describe how to work with non-relational data on Azure
  36. 86.A social networking application needs to store user connections, friendships, and shared content relationships. The application frequently performs queries like 'find all friends of User A' or 'find users who liked the same post as User B'. Which Azure Cosmos DB API is specifically designed to efficiently handle these types of highly interconnected data relationships?Describe how to work with non-relational data on Azure
  37. 87.A developer is creating a new table in an Azure SQL Database to store product details. One of the columns, 'ProductName', needs to store variable-length string data that can include Unicode characters and can be up to 255 characters long. Which data type should be used for this column?Describe how to work with relational data on Azure
  38. 88.A small startup is developing a mobile game that needs to store player high scores and basic player profiles. The data volume is expected to be low initially but could scale significantly. The team needs a cost-effective, serverless solution that provides fast read/write access to simple key-value pairs. Which Azure non-relational data service is the most appropriate choice?Describe how to work with non-relational data on Azure
  39. 89.A startup is developing a new mobile application that requires a flexible relational database with very low latency and high throughput for small-scale, burstable workloads. They also want to minimize costs by paying only for the resources they consume. Which Azure relational database service is best suited for this scenario?Describe how to work with relational data on Azure
  40. 90.A data engineer is designing a database schema for an Azure SQL Database. The database will store product descriptions that can vary significantly in length, from short phrases to long paragraphs, and may include Unicode characters. The engineer wants to optimize storage and performance while accommodating these variable-length strings. Which data type should the engineer use for the product description column?Describe how to work with relational data on Azure
  41. 91.A small startup is developing a mobile game that needs to store player high scores and basic player profiles. The data volume is expected to be low initially but could scale significantly. The team needs a cost-effective, serverless non-relational database solution that can be easily integrated with Azure Functions. Which Azure service is the MOST appropriate choice?Describe how to work with non-relational data on Azure
  42. 92.A healthcare provider is building an application to manage patient records. These records are complex JSON documents that include nested arrays and varying attributes. The application requires strong consistency for critical medical data and needs to be globally distributed for high availability across multiple regions. Which Azure Cosmos DB consistency level provides the strongest guarantee, ensuring that reads always return the most recent committed version of a record?Describe how to work with non-relational data on Azure
  43. 93.A global gaming company needs to store player profiles, game statistics, and leaderboards. This data must be highly available, globally distributed, and support multiple data models, including document and key-value. Which Azure non-relational data service is best suited for these requirements?Describe how to work with non-relational data on Azure
  44. 94.A data engineering team needs to store petabytes of raw sensor data from IoT devices for long-term analysis. The data is unstructured, arrives in various formats, and will be accessed infrequently for batch processing. The solution must support hierarchical namespaces for efficient organization and access control, and be optimized for big data analytics workloads. Which Azure storage service is the most appropriate choice?Describe how to work with non-relational data on Azure
  45. 95.A company uses Azure Database for MySQL to store customer data. They need to create a new database user account for a reporting application. This application should only be able to read data from the `customer_orders` table and nothing else. Which SQL command sequence should the database administrator use to achieve this?Describe how to work with relational data on Azure
  46. 96.A financial institution needs to store audit logs for regulatory compliance. These logs are rarely accessed after creation, but must be retained for seven years and retrieved quickly if an audit occurs. The institution wants to minimize storage costs while ensuring data availability for rare access. Which Azure Blob Storage access tier is most appropriate for this scenario?Describe how to work with non-relational data on Azure
  47. 97.A global e-commerce platform needs to store customer order history, which includes variable schema data like product details, shipping information, and payment methods. The platform requires extremely low-latency access globally and the ability to scale throughput and storage independently. Which Azure non-relational data service is the most appropriate choice?Describe how to work with non-relational data on Azure
  48. 98.A data engineer is designing a database schema for an Azure SQL Database. The database will store customer information, including addresses. The `PostalCode` column needs to store alphanumeric values, including letters, numbers, and sometimes hyphens, up to a maximum of 10 characters. Which data type is most appropriate for the `PostalCode` column?Describe how to work with relational data on Azure
  49. 99.A retail company uses Azure Blob Storage to store millions of customer receipts as PDF files. These receipts are frequently accessed for the first 30 days for customer service inquiries, then accessed only rarely for auditing purposes for the next 5 years. After 5 years, they are no longer needed. To optimize storage costs, which Azure Blob Storage access tier strategy should be implemented?Describe how to work with non-relational data on Azure
  50. 100.A financial company uses Azure Database for PostgreSQL to store customer transaction data. Due to increasing read workloads from reporting and analytics applications, the primary database is experiencing performance bottlenecks. The company needs to offload these read-heavy queries to maintain optimal performance for write operations on the primary database. Which Azure Database for PostgreSQL feature should they implement?Describe how to work with relational data on Azure