Step2Study

Microsoft Certified: Azure Solutions Architect Expert practice questions

230 free questions with answers and explanations.

Practice test
  1. 201.A logistics company needs to track millions of packages in real-time. Each package generates telemetry data (location, temperature, status) every few seconds. This data needs to be ingested, processed, and analyzed to detect anomalies and provide real-time dashboards. The data will also be used for historical reporting over several months. Which Azure data integration solution is best suited to collect and process this continuous stream of data for real-time analytics?Design data storage solutions
  2. 202.A global online gaming company is developing a new massively multiplayer online role-playing game (MMORPG). The game requires a database to store player profiles, inventory, character statistics, and game state. This data needs to be highly available globally, with low-latency reads and writes from any region, and must scale elastically to accommodate millions of concurrent players. The data model is document-oriented and subject to frequent schema changes as new game features are introduced. Which Azure data storage solution is most suitable for these requirements?Design data storage solutions
  3. 203.A financial institution needs to store audit logs from various applications. These logs are generated continuously, often in unstructured or semi-structured formats (JSON, plain text). The primary use case is for security analysis, compliance audits, and troubleshooting, which involves querying historical data over long periods (years) using complex text searches and aggregations. The solution must be highly scalable to accommodate petabytes of data and offer fast analytical query performance. Which Azure data storage solution should be chosen?Design data storage solutions
  4. 204.A small startup is developing a new mobile application that aggregates user-generated content, including short text posts, images, and user profiles. The application needs a flexible database schema to accommodate evolving data models and support high-volume reads and writes with low latency. Data consistency can be eventual, but high availability is critical. Which Azure data storage solution should the startup choose?Design data storage solutions
  5. 205.A national retail chain operates hundreds of physical stores. Each store generates daily sales reports, inventory updates, and employee time clock data. This data needs to be collected efficiently from each store, transformed, and then loaded into a central data warehouse in Azure for business intelligence and reporting. The solution must handle a large number of concurrent data transfers from geographically dispersed locations. Which data integration solution would be most effective for collecting data from the on-premises stores to Azure?Design data storage solutions
  6. 206.A multinational enterprise wants to migrate its on-premises data warehouse, containing several terabytes of structured data, to Azure. The new solution must support complex analytical queries, integrate with existing business intelligence (BI) tools, and offer elastic scalability to handle fluctuating query workloads from thousands of users. Which Azure data storage solution is most suitable for this scenario?Design data storage solutions
  7. 207.A global energy company is developing a new application to manage its supply chain. The application requires a database that can handle highly variable transaction volumes, scale elastically to millions of requests per second, and maintain strong consistency across multiple regions for critical inventory data. The data model is document-based. Which Azure data storage solution is most appropriate?Design data storage solutions
  8. 208.A logistics company needs to track the real-time location and status of its fleet of delivery trucks. Each truck sends telemetry data (GPS coordinates, speed, fuel level) every few seconds. This data stream needs to be ingested, processed, and then stored for both real-time monitoring on a dashboard and historical analysis. The ingestion and processing layer must handle millions of events per second with low latency. Which Azure service is crucial for ingesting this high-volume, real-time telemetry data?Design data storage solutions
  9. 209.A global manufacturing company needs to store sensor data from millions of IoT devices deployed worldwide. Each device sends small telemetry messages (JSON format) every few seconds. The data needs to be stored for up to 5 years for compliance and historical analysis. Critical requirements include extreme cost-effectiveness for storage, high write throughput, and the ability to perform simple queries (e.g., retrieve all data for a specific device within a time range) without complex joins. Which Azure data storage solution is the most appropriate?Design data storage solutions
  10. 210.A research institution is collecting sensor data from various environmental monitoring stations. This data consists of time-series readings (temperature, humidity, pressure) generated every minute. The institution needs to store this data efficiently for long-term retention (decades) and perform aggregate queries over specific time ranges (e.g., average temperature for a month, maximum pressure for a week). The data is append-only, and individual record updates are rare. Which Azure non-relational data storage solution is most appropriate?Design data storage solutions
  11. 211.A media company is developing a new video streaming platform. They need to store millions of video files, ranging from small clips to full-length movies. These files must be accessible globally with high availability and durability. The company expects varying access patterns, with some popular content frequently accessed and older content rarely viewed. Which Azure storage solution should be used?Design data storage solutions
  12. 212.A global pharmaceutical company is conducting a large-scale genomics research project. The project involves storing petabytes of raw genomic sequencing data, which are typically very large files (hundreds of GBs to TBs each). This data needs to be accessible for complex analytics workloads using Apache Spark and Hadoop ecosystems. The solution must provide hierarchical namespace capabilities and strong consistency. Which Azure storage solution should be recommended?Design data storage solutions
  13. 213.A telecommunications company has petabytes of call detail records (CDRs) stored in an on-premises Hadoop Distributed File System (HDFS). They need to migrate this data to Azure and perform complex analytical queries using Spark and other big data tools. The solution must support a hierarchical file system, be highly scalable, and cost-effective for long-term storage and analytics. Which Azure data storage solution is best suited for this migration?Design data storage solutions
  14. 214.A logistics company processes millions of GPS coordinates from its fleet of vehicles every minute. This real-time stream of data needs to be ingested, stored, and made available for short-term analysis (up to 7 days) to track vehicle locations and identify potential delays. Long-term historical analysis is not required for this specific data stream. Which Azure data integration solution should be used to ingest this data?Design data storage solutions
  15. 215.An online gaming company stores player profile data, including usernames, scores, and game preferences. This data needs to be highly available with low-latency access for millions of concurrent players globally. The data model is relatively simple (key-value pairs) and does not require complex relational queries. Occasional eventual consistency for some non-critical fields is acceptable, but high throughput is essential. Which Azure data storage solution is most appropriate?Design data storage solutions
  16. 216.A financial institution needs to store immutable audit logs for regulatory compliance. These logs must be write-once, read-many (WORM) and tamper-proof for seven years. After seven years, they can be deleted. The solution must be highly durable and cost-effective for long-term storage. Which Azure data storage solution should be recommended?Design data storage solutions
  17. 217.A global IoT solution collects sensor data from millions of devices worldwide. This data needs to be stored for a maximum of 30 days, primarily for real-time dashboards and alerting. The solution must be highly available, low-cost, and capable of handling high write throughput without requiring complex indexing or querying beyond simple lookups based on device ID and timestamp. Which Azure non-relational data storage solution is most suitable?Design data storage solutions
  18. 218.A small business needs to migrate a legacy line-of-business application to Azure. The application stores its data on a shared network drive using the Server Message Block (SMB) protocol and requires low-latency access to files. The business wants to avoid refactoring the application. Which Azure storage solution should be used to minimize changes to the application?Design data storage solutions
  19. 219.A global pharmaceutical company is conducting a large-scale genomics research project. The project involves storing petabytes of raw genomic sequencing data, which consists of very large files (up to several terabytes each). This data is accessed infrequently after initial ingestion but needs to be available for intermittent analysis. Cost optimization for storage is a primary concern. Which Azure storage solution is most cost-effective for these requirements?Design data storage solutions
  20. 220.An analytics team needs to ingest data from various on-premises relational databases (SQL Server, Oracle) and transform it before loading it into an Azure Synapse Analytics Dedicated SQL Pool for reporting. The data integration process involves scheduling daily full loads and hourly incremental loads, complex data transformations, and robust error handling. Which Azure service is best suited to orchestrate this data integration pipeline?Design data storage solutions
  21. 221.A startup is building a new mobile application that aggregates news articles from various sources. Each article will have a title, content, publication date, and a list of tags. The application needs to display articles quickly to users, support keyword searches across article content, and allow for flexible querying based on tags and publication dates. The data volume is expected to grow rapidly, and the solution must be cost-effective. Which Azure data storage solution should be chosen for storing and querying these articles?Design data storage solutions
  22. 222.A manufacturing company uses several legacy on-premises systems that generate proprietary formatted data. They need to migrate this data to Azure for modernization and analytics. The data migration process involves extracting data from various sources, transforming it into a standardized format, and loading it into an Azure data lake. This process needs to be orchestrated, monitored, and scheduled regularly. Which Azure service is best suited to manage and orchestrate this ETL/ELT pipeline?Design data storage solutions
  23. 223.A manufacturing company uses several legacy on-premises systems that generate proprietary data in various formats (CSV, XML, fixed-width files) daily. This data needs to be extracted, transformed, and loaded (ETL) into an Azure Synapse Analytics Dedicated SQL pool for business intelligence reporting. The process needs to be orchestrated, monitored, and scheduled to run nightly. Which Azure service is best suited for building this data integration solution?Design data storage solutions
  24. 224.An e-commerce company needs to store product images and videos. These files are frequently accessed when customers browse products, but older versions of the files are rarely accessed after a few months. The company requires a cost-effective solution with high availability. Which Azure storage solution should be chosen?Design data storage solutions
  25. 225.A research institution is collecting sensor data from various environmental monitoring stations across the globe. This data streams continuously, with each data point being small (kilobytes) but arriving at extremely high velocity (millions of events per second). The institution needs to ingest this data for near real-time processing and subsequent long-term archival. Which Azure service is best suited for ingesting this high-volume, high-velocity data stream?Design data storage solutions
  26. 226.A startup is developing a new social media application. User profiles will contain basic information (username, email, registration date) along with a dynamic list of interests and connections. The application anticipates rapid user growth and requires a database that can handle high read/write throughput, scale globally, and adapt to evolving data structures without complex schema migrations. Consistency can be eventual for some data. Cost-effectiveness for a startup is also a consideration. Which Azure data storage solution should be selected?Design data storage solutions
  27. 227.A global pharmaceutical company is conducting a large-scale genomics research project. The project involves storing petabytes of raw genomic sequencing data (FASTQ, BAM files) along with associated metadata. This data is typically accessed by multiple data scientists and analytical tools (e.g., Apache Spark, Hadoop) for complex queries and machine learning model training. The company requires a storage solution that supports a hierarchical file system, fine-grained access control, and is optimized for big data analytics workloads. Which Azure storage solution is most suitable?Design data storage solutions
  28. 228.A financial services company needs to store transaction records that must be immutable and retained for seven years for regulatory compliance. These records are written once and rarely read, primarily for auditing purposes. The company wants to minimize storage costs while meeting compliance requirements. Which Azure storage solution and configuration should be used?Design data storage solutions
  29. 229.A global pharmaceutical company is designing a new research data analytics platform in Azure. The platform will process extremely large datasets (petabytes) of genomic and molecular data, requiring high-throughput, low-latency access for complex analytical queries. Data scientists need to perform interactive analysis directly on this data. The solution must also support hierarchical namespaces for organizing research projects and strict access control. Which Azure storage solution is most appropriate for this scenario?Design infrastructure solutions
  30. 230.A global financial institution is deploying a new trading platform to Azure. The platform will interact with various Azure services, including Azure Key Vault for secrets management and Azure SQL Database for transactional data. The security team mandates that all interactions between the platform's services and other Azure resources must be authenticated using a robust, automatically managed identity without storing credentials in code. Which authentication solution should you recommend to meet these requirements?Design identity, governance, and monitoring solutions