Practice Test GeeksAZ-301 - Microsoft Azure Solutions Architect Expert Practice Test
← All AZ-301 Flashcard Decks

Data & Storage Architecture Flashcards

6 cards from real AZ-301 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Data & Storage Architecture flashcards as text

  1. A company needs to implement a database solution that automatically scales compute independently from storage and can pause during inactivity to minimize costs for a dev/test workload. Which Azure service provides this?

    Answer: Azure SQL Database Serverless

    Azure SQL Database Serverless automatically scales compute based on workload demand and can auto-pause during inactivity, billing only for storage when paused.

  2. An architect needs to design a solution for running complex analytics queries across terabytes of data in Azure SQL Database without impacting OLTP workload performance. Which Azure SQL feature enables read scale-out for this purpose?

    Answer: Azure SQL Database Hyperscale with named replicas

    Azure SQL Database Hyperscale named replicas provide independent compute replicas for read scale-out that are isolated from the primary and can run analytics without impacting OLTP.

  3. A company needs to implement object-level immutability for compliance, ensuring that Azure Blob Storage objects cannot be deleted or modified for a defined retention period. Which feature should be configured?

    Answer: Azure Blob Storage immutability policies (WORM)

    Azure Blob Storage immutability policies implement WORM (Write Once Read Many) storage ensuring blobs cannot be deleted or modified for the policy retention period.

  4. When designing a data warehouse solution on Azure Synapse Analytics, an architect needs to optimize query performance for a fact table with billions of rows. Which distribution strategy should be applied?

    Answer: Hash distribution on a high-cardinality join key

    Hash distribution on a high-cardinality join key minimizes data movement during queries by co-locating related rows from fact and dimension tables on the same node.

  5. A company requires that Azure Storage accounts enforce HTTPS-only access and have public blob access disabled by default as an organization-wide policy. Which approach ensures this compliance at scale?

    Answer: Azure Policy with Deny effect for non-HTTPS and public access

    Azure Policy with Deny effect prevents creation of storage accounts that allow HTTP access or public blob access, enforcing compliance at the organization level.

  6. An architect needs to design a solution for managing database schemas across multiple Azure SQL databases that are part of an elastic pool, ensuring all databases run the same schema version. Which Azure service helps orchestrate this?

    Answer: Azure SQL Elastic Jobs

    Azure SQL Elastic Jobs is a database job service that runs T-SQL scripts across multiple databases in an elastic pool or custom groups for schema management.