50 Free DP-900 Practice Questions and Answers
50 questions for the DP-900 exam, each answer explained. Watch it here, try the questions yourself, or read the transcript.
Questions in this video
Tap an answer to see why it is right or wrong. Tap it again to reset.
Question 1 Play from 00:00
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
SSIS packages are SQL Server Integration Services components and are not part of the Azure Data Factory architecture.
Right, B is the answer.
Why B is right
An integration runtime is the compute infrastructure in Azure Data Factory that provides the execution environment for activities. It handles data movement, activity dispatch, and execution across on-premises and cloud environments. Integration runtimes are essential for running pipelines and activities.
Not this one. Try another answer.
Why C is wrong
A control flow is a logical structure within a pipeline for orchestrating activities, not a compute environment.
Not this one. Try another answer.
Why D is wrong
A pipeline is a container for activities and doesn't provide compute; it relies on integration runtimes for execution.
Question 2 Play from 01:36
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
SELECT is a DML (Data Manipulation Language) statement used to retrieve data, not define schema.
Not this one. Try another answer.
Why B is wrong
JOIN is a clause used within DML queries to combine rows from multiple tables, not a DDL statement.
Not this one. Try another answer.
Why C is wrong
UPDATE is a DML statement used to modify existing data, not define or alter database structure.
Right, D is the answer.
Why D is right
CREATE is a DDL (Data Definition Language) statement that defines database schema objects such as tables, indexes, and views. DDL statements modify the structure of the database itself rather than the data within it.
Question 3 Play from 03:08
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Azure Cosmos DB is a separate service and not required for Azure Table storage.
Right, B is the answer.
Why B is right
A storage account is the foundational Azure resource that must be created first. Azure Table storage is a service within a storage account, so the storage account must exist before you can create tables or use any table storage functionality.
Not this one. Try another answer.
Why C is wrong
Blob containers are for blob storage, a different service, and not needed for Table storage.
Not this one. Try another answer.
Why D is wrong
A table cannot be created without first having a storage account to contain it.
Question 4 Play from 04:28
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
SET is used in UPDATE statements to modify column values.
Not this one. Try another answer.
Why B is wrong
VALUES is used in INSERT statements to specify the data being inserted.
Not this one. Try another answer.
Why C is wrong
KEY is used to define constraints or indexes, not to combine rows from tables.
Right, D is the answer.
Why D is right
The JOIN clause is used in SELECT statements to combine rows from two or more tables based on related columns. SET is used in UPDATE statements, VALUES is used in INSERT statements, and KEY is used for constraint definitions, not for combining table rows.
Question 5 Play from 06:03
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
While a lakehouse can expose data as tables through metadata layers, the underlying storage is file-based.
Not this one. Try another answer.
Why B is wrong
Queues are used for message streaming, not for storing raw data in a lakehouse.
Right, C is the answer.
Why C is right
Raw data in a data lakehouse is stored as files, typically in open formats like Parquet, CSV, or JSON. This file-based approach provides flexibility, scalability, and compatibility with various processing engines while maintaining the schema-on-read capability that distinguishes lakehouses from traditional data warehouses.
Not this one. Try another answer.
Why D is wrong
Disks refer to physical storage infrastructure, not the logical format in which data is organized.
Question 6 Play from 07:29
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
The Cool access tier in Azure Blob Storage is designed for infrequently accessed data but still provides relatively fast read latency measured in milliseconds. While Cool tier has higher retrieval costs than Hot tier, it maintains quick access times suitable for occasional reads. Archive tier would have latencies measured in hours.
Not this one. Try another answer.
Why B is wrong
Cool tier provides sub-second latency, not several seconds.
Not this one. Try another answer.
Why C is wrong
Cool tier access latency is measured in milliseconds, not minutes.
Not this one. Try another answer.
Why D is wrong
Archive tier has latencies in the hours range; Cool tier is much faster.
Question 7 Play from 08:55
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
GRANT is DCL, not DML; it controls access permissions.
Right, B is the answer.
Why B is right
INSERT is a Data Manipulation Language (DML) statement used to add new rows of data into a table. DML statements modify data within tables. GRANT and REVOKE are Data Control Language (DCL) statements that manage permissions, while DROP is a Data Definition Language (DDL) statement that removes database objects.
Not this one. Try another answer.
Why C is wrong
REVOKE is DCL, not DML; it removes access permissions.
Not this one. Try another answer.
Why D is wrong
DROP is DDL, not DML; it removes database objects.
Question 8 Play from 10:23
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Azure Cosmos DB for Table is designed for key-value storage, not graph databases.
Not this one. Try another answer.
Why B is wrong
Azure Cosmos DB for Apache Cassandra is designed for wide-column stores, not graph databases.
Not this one. Try another answer.
Why C is wrong
Azure Cosmos DB for NoSQL is a document database API, not optimized for graph structures.
Right, D is the answer.
Why D is right
Azure Cosmos DB for Apache Gremlin is the API designed for graph databases, supporting graph data models with vertices, edges, and properties. Gremlin is a graph traversal language that allows querying and manipulating graph structures, making it the appropriate choice for graph database workloads.
Question 9 Play from 12:04
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Azure Files provides SMB protocol support that allows Windows applications to mount network shares as mapped drives. This is the only Azure service listed that supports the standard Windows file-sharing protocols required for mapped drive functionality.
Not this one. Try another answer.
Why B is wrong
Azure Blob Storage is object storage without mapped drive support.
Not this one. Try another answer.
Why C is wrong
Azure Cosmos DB is a NoSQL database, not a file storage service.
Not this one. Try another answer.
Why D is wrong
Azure Table Storage is for structured key-value data, not file-based mapped drives.
Question 10 Play from 13:28
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Azure Database for PostgreSQL is a Platform as a Service (PaaS) offering, meaning Microsoft manages the infrastructure, operating system, and database software, while customers focus only on data and application configuration. This eliminates the need for manual patching, backups, and maintenance tasks.
Not this one. Try another answer.
Why B is wrong
Infrastructure as a Service involves managing VMs and infrastructure yourself, which is not the case with Azure Database for PostgreSQL.
Not this one. Try another answer.
Why C is wrong
Azure Database for PostgreSQL is a PostgreSQL service, not Microsoft SQL Server.
Not this one. Try another answer.
Why D is wrong
Azure Database for PostgreSQL is a cloud-hosted service, not an on-premises solution.
Show all 50 questionsShow fewer questions
Question 11 Play from 15:08
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Relational databases enforce strict schemas, not flexible data structures.
Right, B is the answer.
Why B is right
A primary characteristic of relational databases is that data is queried and manipulated using SQL or a variant of SQL. SQL's standardized language for defining, retrieving, and modifying relational data is fundamental to how relational databases operate. Relational databases have structured, not flexible, data; they maintain dependencies between tables through foreign keys; and normalization minimizes duplicate data.
Not this one. Try another answer.
Why C is wrong
Relational databases intentionally establish dependencies between tables through keys and relationships.
Not this one. Try another answer.
Why D is wrong
Relational databases use normalization to minimize duplication, not create large amounts of duplicate data.
Question 12 Play from 16:56
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Multi-master replication provides redundancy across multiple regions, not within a single region.
Right, B is the answer.
Why B is right
Availability Zones provide redundancy and high availability within a single Azure region by distributing replicas across multiple physically separate zones within that region. This ensures data remains available even if one zone fails.
Not this one. Try another answer.
Why C is wrong
Strong consistency is a consistency level setting that does not provide redundancy within a region.
Not this one. Try another answer.
Why D is wrong
Automatic failover handles recovery when a failure occurs but does not itself provide the redundancy mechanism within a region.
Question 13 Play from 18:29
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Archive storage is a tier for retention, not automatic deletion.
Not this one. Try another answer.
Why B is wrong
The change feed tracks blob changes but does not delete blobs.
Not this one. Try another answer.
Why C is wrong
Soft delete allows recovery of deleted blobs; it does not automatically delete them.
Right, D is the answer.
Why D is right
Lifecycle management policies in Azure Blob Storage allow you to automatically delete, archive, or tier blobs based on age and other conditions. Archive storage is a tier for infrequent access, the change feed tracks changes to blobs, and soft delete allows recovery of deleted blobs-none of these automatically delete blobs like lifecycle policies do.
Question 14 Play from 19:54
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
A primary key uniquely identifies rows within its own table. It does not reference another table.
Not this one. Try another answer.
Why B is wrong
An index improves query performance and does not enforce relationships between tables.
Right, C is the answer.
Why C is right
A foreign key constrains a column so that its values must match an existing value in the referenced table's key column. This is what enforces referential integrity between the two tables.
Not this one. Try another answer.
Why D is wrong
A view is a stored query presented as a virtual table and enforces no constraints.
Question 15 Play from 21:16
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
OLTP handles transactional queries, not continuous real-time data streams.
Not this one. Try another answer.
Why B is wrong
Batch processing collects data over time before processing it, not real-time gathering.
Not this one. Try another answer.
Why C is wrong
Massively parallel processing (MPP) is for large-scale data analytics, not real-time telemetry collection.
Right, D is the answer.
Why D is right
Streaming workloads are designed for real-time data ingestion from continuous sources like mobile applications. They process data as it arrives with minimal latency, which matches the requirement to gather real-time telemetry data from a mobile application.
Question 16 Play from 22:44
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
A data warehouse stores aggregated historical data for analysis, not real-time transaction processing.
Not this one. Try another answer.
Why B is wrong
OLAP is used for analytical queries on aggregated data, not for processing individual transactions.
Not this one. Try another answer.
Why C is wrong
ETL is a process for extracting and loading data, not a type of operational system.
Right, D is the answer.
Why D is right
A point of sale (POS) system handles real-time transactions where sales data is immediately recorded. OLTP (Online Transaction Processing) systems are designed for high-volume, real-time transactional operations with frequent inserts, updates, and queries. Data warehouses and OLAP systems are designed for analytical queries on historical data, while ETL is a process for moving data between systems.
Question 17 Play from 24:36
Tap an answer. The reason for that answer shows here.
Right, A is one of the answers.
Why A is right
Throughput in Azure Cosmos DB can be set at two levels: at the database level (applying to all containers within it) or at the container level (for individual container control). This two-level approach allows flexible resource allocation depending on workload requirements.
Not this one. Try another answer.
Why B is wrong
Item-level throughput is not a configuration option in Azure Cosmos DB.
Right, C is one of the answers.
Why C is right
Throughput in Azure Cosmos DB can be set at two levels: at the database level (applying to all containers within it) or at the container level (for individual container control). This two-level approach allows flexible resource allocation depending on workload requirements.
Not this one. Try another answer.
Why D is wrong
Partition-level throughput is not a user-configurable setting; partitions are managed automatically by the service.
Question 18 Play from 26:00
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
YAML is a configuration language, not used for Stream Analytics query definition.
Not this one. Try another answer.
Why B is wrong
KQL (Kusto Query Language) is used in Azure Data Explorer, not Stream Analytics.
Right, C is the answer.
Why C is right
Azure Stream Analytics uses SQL (a variant called Stream Analytics Query Language) to define queries for stream processing jobs. SQL provides an intuitive way to process streaming data with familiar syntax for filtering, joining, and aggregating event data. YAML, KQL, and XML are not used for defining Stream Analytics queries.
Not this one. Try another answer.
Why D is wrong
XML is a markup language, not used for Stream Analytics query definition.
Question 19 Play from 27:32
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Consistency ensures data integrity rules are maintained but does not specifically guarantee preservation during restarts.
Not this one. Try another answer.
Why B is wrong
Atomicity ensures transactions complete fully or not at all but does not guarantee persistence after system failures.
Right, C is the answer.
Why C is right
Durability is the ACID property that ensures transactional changes to a database are preserved during unexpected operating system restarts or failures. Once a transaction is committed, its changes persist permanently even if the system crashes immediately afterward.
Not this one. Try another answer.
Why D is wrong
Isolation prevents concurrent transactions from interfering with each other but does not ensure recovery from system restarts.
Question 20 Play from 29:05
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Document databases are specifically designed to store data as JSON (or similar semi-structured formats) with flexible schemas, where all data for an entity is stored together in a single document. This matches all three criteria in the question perfectly.
Not this one. Try another answer.
Why B is wrong
Columnar stores organize data by column rather than by document, and are optimized for analytical queries on specific columns.
Not this one. Try another answer.
Why C is wrong
Graph databases store data as nodes and edges to represent relationships, not as JSON documents.
Not this one. Try another answer.
Why D is wrong
Time series databases are optimized for timestamped data points, not flexible schema JSON documents.
Question 21 Play from 30:36
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
MERGE is used for conditional insert, update, or delete operations, not for modifying view structure.
Right, B is the answer.
Why B is right
The ALTER statement is used to modify existing database objects, including views. To add a new column to a view definition, you use ALTER VIEW. MERGE is used to perform insert, update, or delete operations based on source and target conditions, INSERT adds new rows, and UPDATE modifies existing row data-none of these modify the structure of a view itself.
Not this one. Try another answer.
Why C is wrong
INSERT adds new data rows but does not modify the view definition.
Not this one. Try another answer.
Why D is wrong
UPDATE modifies data values but does not alter the view structure or definition.
Question 22 Play from 32:13
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
HTML is a markup language for web documents, not a data storage format with typed columns.
Not this one. Try another answer.
Why B is wrong
CSV is a plain text format that does not enforce data types or use columnar compression.
Right, C is the answer.
Why C is right
Apache Parquet is a columnar storage format that defines named columns with specific data types and uses compression techniques optimized for analytical queries. HTML is a markup language, CSV is plain text without type definitions, and JSON is a hierarchical format without enforced schemas or columnar compression.
Not this one. Try another answer.
Why D is wrong
JSON is a hierarchical document format without columnar storage or built-in compression.
Question 23 Play from 33:44
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Graph databases excel at modeling relationships and dependencies between entities. Network traffic patterns showing how changes in one area affect others represents a connected relationship problem that graph data structures handle optimally.
Not this one. Try another answer.
Why B is wrong
Key/value stores are designed for simple lookups and do not model complex relationships well.
Not this one. Try another answer.
Why C is wrong
Document stores are better for storing self-contained entities rather than modeling cross-entity relationships.
Not this one. Try another answer.
Why D is wrong
Columnar databases are optimized for analytical queries on large datasets, not for representing relationships between entities.
Question 24 Play from 35:15
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Transactional workloads are characterized by recording small, discrete units of work events in real time, such as individual sales transactions, account transfers, or inventory updates. These systems prioritize speed, consistency, and immediate data recording rather than bulk analysis or reporting.
Not this one. Try another answer.
Why B is wrong
Aggregating massive amounts of data is characteristic of analytical workloads, not transactional ones.
Not this one. Try another answer.
Why C is wrong
Producing complex reports is an analytical activity, not the primary focus of transactional systems.
Not this one. Try another answer.
Why D is wrong
Self-service data exploration is an analytical and exploratory activity, not typical of transactional workloads.
Question 25 Play from 36:51
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
OLTP is used for transactional systems with frequent writes and operational data, not analytical queries against historical warehouse data.
Not this one. Try another answer.
Why B is wrong
Batch processing refers to processing data in scheduled groups, while OLAP provides interactive analytical query capability.
Right, C is the answer.
Why C is right
A quality assurance application reading from a data warehouse uses Online Analytical Processing (OLAP). Data warehouses are designed to support analytical queries and reporting on historical data, which is the core function of OLAP systems.
Not this one. Try another answer.
Why D is wrong
Stream processing handles real-time continuous data flows, not the static analytical queries typical of data warehouse applications.
Question 26 Play from 38:33
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Data cleaning routines are typically handled by data engineers or ETL specialists, not core DBA responsibilities.
Not this one. Try another answer.
Why B is wrong
Creating data visualizations is the role of business analysts or data visualization specialists, not database administrators.
Not this one. Try another answer.
Why C is wrong
Managing data integration processes is primarily an ETL engineer or data integration specialist role, not a DBA function.
Right, D is the answer.
Why D is right
A database administrator's primary responsibility is ensuring data protection and business continuity through backup and recovery procedures. While DBAs may be involved in other tasks, storing and managing backup copies is a core DBA function that protects against data loss and ensures disaster recovery capability.
Question 27 Play from 40:16
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Non-relational databases typically have indexes to optimize query performance.
Right, B is the answer.
Why B is right
Non-relational data is typically characterized by self-describing entities, where the structure and metadata are embedded within the data itself. This allows flexible schemas and varied structures across different records without predefined enforcement.
Not this one. Try another answer.
Why C is wrong
Non-relational data specifically allows flexible, application-defined schemas rather than well-defined rigid schemas.
Not this one. Try another answer.
Why D is wrong
Non-relational data stores do use unique key values to identify records.
Question 28 Play from 41:41
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
The Hot access tier is a performance/cost classification, not a synchronization mechanism for external caches.
Right, B is the answer.
Why B is right
Change feed is the Azure Blob Storage feature that enables syncing a Blob Storage account to an external cache by providing a record of all changes that occur to blobs and metadata in a storage account. This allows external systems to detect and respond to modifications, facilitating cache synchronization.
Not this one. Try another answer.
Why C is wrong
Snapshots create point-in-time copies of blobs but do not provide change tracking for cache synchronization.
Not this one. Try another answer.
Why D is wrong
Versioning maintains previous versions of blobs but does not track changes for external cache synchronization purposes.
Question 29 Play from 43:07
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Control flow manages the flow of activities within a pipeline after execution has begun, not the initiation.
Right, B is the answer.
Why B is right
A trigger is the Azure Data Factory component that initiates pipeline execution. Triggers define when and how a pipeline should run, whether on a schedule, in response to events, or through manual invocation.
Not this one. Try another answer.
Why C is wrong
Parameters are used to pass values into pipelines but do not initiate execution.
Not this one. Try another answer.
Why D is wrong
Activities are individual tasks within a pipeline that execute after the pipeline has been triggered.
Question 30 Play from 44:27
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Relational databases are not optimized for the high-velocity, high-volume nature of sensor data.
Right, B is the answer.
Why B is right
Time series databases are purpose-built for storing and analyzing sensor data collected over time. They are optimized for ingesting high-volume sequential data points and performing trend analysis, making them ideal for temperature sensor telemetry that requires temporal analysis.
Not this one. Try another answer.
Why C is wrong
Graph databases are for relationship analysis, not temporal trend analysis.
Not this one. Try another answer.
Why D is wrong
Columnar databases, while good for analytics, lack the temporal optimizations of time series databases.
Question 31 Play from 45:55
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Predictive analytics forecasts future outcomes based on historical data, not summarizes past performance.
Not this one. Try another answer.
Why B is wrong
Prescriptive analytics recommends actions to optimize outcomes, not merely displays historical results.
Right, C is the answer.
Why C is right
A bar chart showing year-to-date sales by region is descriptive analytics because it describes what has happened in the past by presenting historical sales data organized by geographic region. Descriptive analytics answers the question 'what happened?' by summarizing and visualizing existing data, which is exactly what this chart does.
Not this one. Try another answer.
Why D is wrong
Diagnostic analytics investigates why something happened by drilling deeper into causes, not simply reporting regional totals.
Question 32 Play from 47:28
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
A funnel chart displays progressive stages in a process, not trends over time.
Not this one. Try another answer.
Why B is wrong
A pie chart shows proportions of a whole at a single point in time, not trends over time.
Not this one. Try another answer.
Why C is wrong
A table displays raw data in rows and columns but does not visually emphasize trends over time.
Right, D is the answer.
Why D is right
A line chart is specifically designed to display trends over time by connecting data points with lines. It effectively shows how one or more series of values change across a continuous time axis, making it ideal for trend analysis.
Question 33 Play from 48:48
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Normalization is the systematic database design process that organizes data into related tables to eliminate redundancy and enforce referential integrity. It reduces data duplication through techniques like breaking data into multiple tables and establishing key relationships.
Not this one. Try another answer.
Why B is wrong
Batch processing is a data processing technique for handling large volumes of data, not a schema design process.
Not this one. Try another answer.
Why C is wrong
Extraction is part of ETL operations and refers to retrieving data from sources, not schema design.
Not this one. Try another answer.
Why D is wrong
Virtualization abstracts underlying infrastructure but does not address schema design principles for data integrity.
Question 34 Play from 50:16
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Application Gateway is a web traffic load balancer, not designed for private database connectivity.
Not this one. Try another answer.
Why B is wrong
Traffic Manager is a DNS-based traffic router for load balancing across regions, not for private connectivity.
Not this one. Try another answer.
Why C is wrong
DNS is a name resolution service and does not provide private connectivity between services.
Right, D is the answer.
Why D is right
Azure Private Link enables private connectivity between Azure virtual machines and Azure SQL databases by creating private endpoints, eliminating exposure to the public internet. This solution provides secure, dedicated network connections without requiring VPN or gateway configurations.
Question 35 Play from 51:49
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Atomicity is the ACID property that guarantees each transaction is treated as a single indivisible unit-it either completes entirely and succeeds, or fails completely with no partial results. This all-or-nothing approach prevents data inconsistencies from incomplete transactions.
Not this one. Try another answer.
Why B is wrong
Isolation ensures transactions do not interfere with each other, not that they succeed or fail completely.
Not this one. Try another answer.
Why C is wrong
Durability ensures committed data persists after a transaction completes, not that transactions are all-or-nothing.
Not this one. Try another answer.
Why D is wrong
Consistency ensures the database moves from one valid state to another, not that transactions are treated as single units.
Question 36 Play from 53:21
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Versioning being disabled is not a requirement for Data Lake Storage provisioning.
Not this one. Try another answer.
Why B is wrong
Hierarchical namespace must be enabled, not disabled, to use Data Lake Storage.
Not this one. Try another answer.
Why C is wrong
Versioning being enabled is not a requirement for Data Lake Storage provisioning.
Right, D is the answer.
Why D is right
Azure Data Lake Storage Gen2 requires that hierarchical namespace be enabled on the Azure Storage account. Hierarchical namespace enables the file system semantics and organizational structure that makes Data Lake Storage distinct from standard Blob Storage. Without enabling this feature, you cannot provision Data Lake Storage capabilities.
Question 37 Play from 54:53
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
A graph database is specifically designed to store and query data organized as nodes and edges, representing entities and their relationships. Graph databases excel at traversing complex relationship networks and are used for social networks, recommendation systems, and knowledge graphs.
Not this one. Try another answer.
Why B is wrong
Key/value databases store simple key-value pairs without explicit node and edge structures.
Not this one. Try another answer.
Why C is wrong
Columnar databases organize data by columns for analytical queries, not by nodes and edges.
Not this one. Try another answer.
Why D is wrong
Time series databases are optimized for time-stamped data points, not graph structures with nodes and edges.
Question 38 Play from 56:20
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Structured data conforms to a rigid, predefined schema where every row has the same columns.
Right, B is the answer.
Why B is right
Semi-structured data carries its own organisational markers, such as JSON keys, but does not conform to a fixed schema. Different documents can hold different fields, which is precisely the described scenario.
Not this one. Try another answer.
Why C is wrong
Unstructured data has no organisational markers at all, such as video files or free-form text. JSON keys are markers.
Not this one. Try another answer.
Why D is wrong
Relational data is a form of structured data stored in tables with a fixed schema and defined relationships.
Question 39 Play from 57:49
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
A column defines an attribute type, not an individual instance of an entity.
Not this one. Try another answer.
Why B is wrong
A table is a collection of multiple entity instances, not a single instance.
Not this one. Try another answer.
Why C is wrong
A cell is a single data value, not an entire entity instance.
Right, D is the answer.
Why D is right
In tabular data, a row represents a single record or instance of a data entity, with each column containing a specific attribute value for that entity. Columns define attributes, a table is a collection of rows, and a cell is a single value within a row.
Question 40 Play from 59:08
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Stream processing handles continuous data flows in real-time, not discrete database transactions typical of e-commerce.
Not this one. Try another answer.
Why B is wrong
Batch processing groups multiple transactions together for processing at scheduled intervals, not the immediate transaction handling needed for e-commerce.
Not this one. Try another answer.
Why C is wrong
OLAP is used for analytical queries on historical data, not the transactional operations of an e-commerce application.
Right, D is the answer.
Why D is right
An e-commerce application that reads and writes data in real-time performs Online Transaction Processing (OLTP). OLTP systems handle individual transactions immediately, which is characteristic of e-commerce platforms that process orders, payments, and inventory updates as they occur. Azure SQL Database is optimized for OLTP workloads with its support for concurrent transactions and ACID properties.
Question 41 Play from 1:00:59
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Graph databases are designed to model and visualize relationships between entities. Network device utilization levels and their interconnected relationships are best represented as nodes (devices) and edges (relationships), making a graph database ideal for this scenario.
Not this one. Try another answer.
Why B is wrong
Key/value stores lack the relationship modeling capabilities needed to show how device utilization levels interconnect.
Not this one. Try another answer.
Why C is wrong
Document stores organize self-contained entities rather than emphasizing relationships between network devices.
Not this one. Try another answer.
Why D is wrong
Columnar databases are optimized for analytical aggregations on large datasets, not for illustrating entity relationships.
Question 42 Play from 1:02:33
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Modern data warehouses support both batch and real-time processing, not batch only.
Right, B is the answer.
Why B is right
A modern data warehouse supports both real-time and batch processing, enabling organizations to handle streaming data alongside traditional batch operations. This dual capability allows businesses to serve both immediate analytical needs and comprehensive reporting requirements from a single unified platform.
Not this one. Try another answer.
Why C is wrong
While some modern data warehouses include native OLAP capabilities, this is not a universal requirement.
Not this one. Try another answer.
Why D is wrong
Modern data warehouses process transformed and structured data, not raw data only.
Question 43 Play from 1:04:08
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Moving from Hot to Cool is a standard tier transition, not a rehydration process.
Not this one. Try another answer.
Why B is wrong
Moving from Hot to Archive is archival, the opposite direction of rehydration.
Not this one. Try another answer.
Why C is wrong
Moving from Cool to Archive is archival, not rehydration.
Right, D is the answer.
Why D is right
Blob rehydration is the process of moving a blob from the Archive tier to a more accessible tier like Cool or Hot. Archive is the coldest tier with lowest cost but longest retrieval times. When data needs to be accessed again, it must be rehydrated by moving it to Cool or Hot tier, making Archive to Cool the correct answer.
Question 44 Play from 1:05:34
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Queue storage is for message queuing and asynchronous communication, not file sharing.
Not this one. Try another answer.
Why B is wrong
Blob storage is for unstructured binary data and does not provide file share semantics or folder hierarchies.
Right, C is the answer.
Why C is right
Azure Files provides cloud-based file shares that replicate the functionality of Windows network file shares, making it the natural replacement for an on-premises shared folder. It supports SMB and NFS protocols and integrates seamlessly with existing file-based workflows.
Not this one. Try another answer.
Why D is wrong
Table storage is for structured key-attribute data, not for hierarchical file organization.
Question 45 Play from 1:07:02
Tap an answer. The reason for that answer shows here.
Right, A is the answer.
Why A is right
Azure Data Lake Storage supports access control lists (ACLs) at both the file and folder level, providing granular permissions management. This hierarchical ACL support is essential for data governance and security in analytics scenarios.
Not this one. Try another answer.
Why B is wrong
Azure Queue storage is a message queuing service and does not support file or folder-level ACLs.
Not this one. Try another answer.
Why C is wrong
Azure Blob storage supports role-based access control (RBAC) but not traditional file and folder-level ACLs like Data Lake Storage.
Not this one. Try another answer.
Why D is wrong
Azure Cosmos DB is a NoSQL database and does not support file and folder-level ACLs.
Question 46 Play from 1:08:35
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
Columnar stores are optimized for analytical queries on fixed schemas, not flexible JSON data.
Not this one. Try another answer.
Why B is wrong
Key/value stores lack the ability to query within the document structure that JSON data requires.
Right, C is the answer.
Why C is right
Document stores are designed for high-volume JSON data with flexible, application-defined schemas. They store semi-structured data natively and allow schema variation across documents, making them ideal for scenarios where the data structure is defined by the application rather than enforced by the database.
Not this one. Try another answer.
Why D is wrong
Graph databases are optimized for relationship traversal, not storing large volumes of JSON documents.
Question 47 Play from 1:10:09
Tap an answer. The reason for that answer shows here.
Right, A is one of the answers.
Why A is right
In Azure Table Storage, each row (entity) is uniquely identified by the combination of a partition key and a row key. The partition key groups related data and distributes it across partitions, while the row key uniquely identifies the entity within that partition. Together, they form the composite primary key.
Not this one. Try another answer.
Why B is wrong
A range is not a component of Table Storage entity identification.
Right, C is one of the answers.
Why C is right
In Azure Table Storage, each row (entity) is uniquely identified by the combination of a partition key and a row key. The partition key groups related data and distributes it across partitions, while the row key uniquely identifies the entity within that partition. Together, they form the composite primary key.
Not this one. Try another answer.
Why D is wrong
Timestamp is a property that tracks last modification but does not uniquely identify entities.
Question 48 Play from 1:11:36
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
SQL Server on Azure Virtual Machines does not support serverless configurations.
Not this one. Try another answer.
Why B is wrong
Elastic pools in Azure SQL Database do not support serverless compute tiers.
Right, C is the answer.
Why C is right
The serverless compute tier is available for single databases in Azure SQL Database, providing automatic scaling and pause/resume functionality. SQL Server on VMs, elastic pools, and Managed Instance do not support serverless configurations.
Not this one. Try another answer.
Why D is wrong
Azure SQL Managed Instance does not offer serverless configuration options.
Question 49 Play from 1:13:11
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
This command creates a file share, not Table storage.
Right, B is the answer.
Why B is right
To create an Azure resource for storing data in Azure Table storage, you must first create a storage account using 'az storage account create'. Table storage is a service within a storage account. While 'az storage container create' creates a blob container (for blob storage) and 'az cosmosdb create' creates a Cosmos database, and 'az storage share create' creates a file share, none of these commands directly provision Table storage. The storage account must exist first.
Not this one. Try another answer.
Why C is wrong
This command creates a Cosmos DB resource, which is a different service from Table storage.
Not this one. Try another answer.
Why D is wrong
This command creates a blob container, not Table storage.
Question 50 Play from 1:14:51
Tap an answer. The reason for that answer shows here.
Not this one. Try another answer.
Why A is wrong
XML is a hierarchical, semi-structured format that does not organize data as simple rows and columns.
Right, B is the answer.
Why B is right
Tabular schema represents structured data in rows and columns where each row represents a single data entity. This is the standard format for relational databases and structured data storage, with consistent columns across rows.
Not this one. Try another answer.
Why C is wrong
Blob storage holds unstructured binary data without schema or rows.
Not this one. Try another answer.
Why D is wrong
JSON is a semi-structured format that can nest data and does not enforce the strict tabular row-column structure.
Transcript
Play from 00:00 Question 1. Which Azure Data Factory component provides the compute environment for activities? Here are the options. Option A. SSIS packages. Option B. an integration runtime. Option C. a control flow. Option D. a pipeline. Pause the video now if you want time to think about the answer.
The correct answer is B. an integration runtime. An integration runtime is the compute infrastructure in Azure Data Factory that provides the execution environment for activities. It handles data movement, activity dispatch, and execution across on-premises and cloud environments. Integration runtimes are essential for running pipelines and activities. Now, why are the other options incorrect? Option A is incorrect. SSIS packages are SQL Server Integration Services components and are not part of the Azure Data Factory architecture. Option C is incorrect. A control flow is a logical structure within a pipeline for orchestrating activities, not a compute environment. Option D is incorrect. A pipeline is a container for activities and doesn't provide compute; it relies on integration runtimes for execution. Therefore, B, an integration runtime, is the correct answer.
Play from 01:36 Question 2. Which statement is an example of Data Definition Language (DDL)? Here are the options. Option A. SELECT. Option B. JOIN. Option C. UPDATE. Option D. CREATE. Pause the video now if you want time to think about the answer.
The correct answer is D. CREATE. CREATE is a DDL (Data Definition Language) statement that defines database schema objects such as tables, indexes, and views. DDL statements modify the structure of the database itself rather than the data within it. Now, why are the other options incorrect? Option A is incorrect. SELECT is a DML (Data Manipulation Language) statement used to retrieve data, not define schema. Option B is incorrect. JOIN is a clause used within DML queries to combine rows from multiple tables, not a DDL statement. Option C is incorrect. UPDATE is a DML statement used to modify existing data, not define or alter database structure. Therefore, D, CREATE, is the correct answer.
Play from 03:08 Question 3. You need to store data by using Azure Table storage. What should you create first? Here are the options. Option A. an Azure Cosmos DB instance. Option B. a storage account. Option C. a blob container. Option D. a table. Pause the video now if you want time to think about the answer.
The correct answer is B. a storage account. A storage account is the foundational Azure resource that must be created first. Azure Table storage is a service within a storage account, so the storage account must exist before you can create tables or use any table storage functionality. Now, why are the other options incorrect? Option A is incorrect. Azure Cosmos DB is a separate service and not required for Azure Table storage. Option C is incorrect. Blob containers are for blob storage, a different service, and not needed for Table storage. Option D is incorrect. A table cannot be created without first having a storage account to contain it. Therefore, B, a storage account, is the correct answer.
Show full transcriptShow less
Play from 04:28 Question 4. Which clause should you use in a SELECT statement to combine rows in one table with rows in another table? Here are the options. Option A. SET. Option B. VALUES. Option C. KEY. Option D. JOIN. Pause the video now if you want time to think about the answer.
The correct answer is D. JOIN. The JOIN clause is used in SELECT statements to combine rows from two or more tables based on related columns. SET is used in UPDATE statements, VALUES is used in INSERT statements, and KEY is used for constraint definitions, not for combining table rows. Now, why are the other options incorrect? Option A is incorrect. SET is used in UPDATE statements to modify column values. Option B is incorrect. VALUES is used in INSERT statements to specify the data being inserted. Option C is incorrect. KEY is used to define constraints or indexes, not to combine rows from tables. Therefore, D, JOIN, is the correct answer.
Play from 06:03 Question 5. How is raw data stored in a data lakehouse? Here are the options. Option A. as tables. Option B. as queues. Option C. as files. Option D. as disks. Pause the video now if you want time to think about the answer.
The correct answer is C. as files. Raw data in a data lakehouse is stored as files, typically in open formats like Parquet, CSV, or JSON. This file-based approach provides flexibility, scalability, and compatibility with various processing engines while maintaining the schema-on-read capability that distinguishes lakehouses from traditional data warehouses. Now, why are the other options incorrect? Option A is incorrect. While a lakehouse can expose data as tables through metadata layers, the underlying storage is file-based. Option B is incorrect. Queues are used for message streaming, not for storing raw data in a lakehouse. Option D is incorrect. Disks refer to physical storage infrastructure, not the logical format in which data is organized. Therefore, C, as files, is the correct answer.
Play from 07:29 Question 6. What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage? Here are the options. Option A. a few milliseconds. Option B. a few seconds. Option C. a few minutes. Option D. a few hours. Pause the video now if you want time to think about the answer.
The correct answer is A. a few milliseconds. The Cool access tier in Azure Blob Storage is designed for infrequently accessed data but still provides relatively fast read latency measured in milliseconds. While Cool tier has higher retrieval costs than Hot tier, it maintains quick access times suitable for occasional reads. Archive tier would have latencies measured in hours. Now, why are the other options incorrect? Option B is incorrect. Cool tier provides sub-second latency, not several seconds. Option C is incorrect. Cool tier access latency is measured in milliseconds, not minutes. Option D is incorrect. Archive tier has latencies in the hours range; Cool tier is much faster. Therefore, A, a few milliseconds, is the correct answer.
Play from 08:55 Question 7. Which statement is an example of Data Manipulation Language (DML)? Here are the options. Option A. GRANT. Option B. INSERT. Option C. REVOKE. Option D. DROP. Pause the video now if you want time to think about the answer.
The correct answer is B. INSERT. INSERT is a Data Manipulation Language (DML) statement used to add new rows of data into a table. DML statements modify data within tables. GRANT and REVOKE are Data Control Language (DCL) statements that manage permissions, while DROP is a Data Definition Language (DDL) statement that removes database objects. Now, why are the other options incorrect? Option A is incorrect. GRANT is DCL, not DML; it controls access permissions. Option C is incorrect. REVOKE is DCL, not DML; it removes access permissions. Option D is incorrect. DROP is DDL, not DML; it removes database objects. Therefore, B, INSERT, is the correct answer.
Play from 10:23 Question 8. Which Azure Cosmos DB API should you use for a graph database? Here are the options. Option A. Azure Cosmos DB for Table. Option B. Azure Cosmos DB for Apache Cassandra. Option C. Azure Cosmos DB for NoSQL. Option D. Azure Cosmos DB for Apache Gremlin. Pause the video now if you want time to think about the answer.
The correct answer is D. Azure Cosmos DB for Apache Gremlin. Azure Cosmos DB for Apache Gremlin is the API designed for graph databases, supporting graph data models with vertices, edges, and properties. Gremlin is a graph traversal language that allows querying and manipulating graph structures, making it the appropriate choice for graph database workloads. Now, why are the other options incorrect? Option A is incorrect. Azure Cosmos DB for Table is designed for key-value storage, not graph databases. Option B is incorrect. Azure Cosmos DB for Apache Cassandra is designed for wide-column stores, not graph databases. Option C is incorrect. Azure Cosmos DB for NoSQL is a document database API, not optimized for graph structures. Therefore, D, Azure Cosmos DB for Apache Gremlin, is the correct answer.
Play from 12:04 Question 9. You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use? Here are the options. Option A. Azure Files. Option B. Azure Blob storage. Option C. Azure Cosmos DB. Option D. Azure Table storage. Pause the video now if you want time to think about the answer.
The correct answer is A. Azure Files. Azure Files provides SMB protocol support that allows Windows applications to mount network shares as mapped drives. This is the only Azure service listed that supports the standard Windows file-sharing protocols required for mapped drive functionality. Now, why are the other options incorrect? Option B is incorrect. Azure Blob Storage is object storage without mapped drive support. Option C is incorrect. Azure Cosmos DB is a NoSQL database, not a file storage service. Option D is incorrect. Azure Table Storage is for structured key-value data, not file-based mapped drives. Therefore, A, Azure Files, is the correct answer.
Play from 13:28 Question 10. Which type of database is Azure Database for PostgreSQL? Here are the options. Option A. Platform as a service (PaaS). Option B. Infrastructure as a service (IaaS). Option C. Microsoft SQL Server. Option D. on-premises. Pause the video now if you want time to think about the answer.
The correct answer is A. Platform as a service (PaaS). Azure Database for PostgreSQL is a Platform as a Service (PaaS) offering, meaning Microsoft manages the infrastructure, operating system, and database software, while customers focus only on data and application configuration. This eliminates the need for manual patching, backups, and maintenance tasks. Now, why are the other options incorrect? Option B is incorrect. Infrastructure as a Service involves managing VMs and infrastructure yourself, which is not the case with Azure Database for PostgreSQL. Option C is incorrect. Azure Database for PostgreSQL is a PostgreSQL service, not Microsoft SQL Server. Option D is incorrect. Azure Database for PostgreSQL is a cloud-hosted service, not an on-premises solution. Therefore, A, Platform as a service (PaaS), is the correct answer.
Play from 15:08 Question 11. What is a primary characteristic of a relational database? Here are the options. Option A. a flexible data structure. Option B. data is queried and manipulated by using a variant of the SQL language. Option C. a lack of dependencies between tables. Option D. a large amount of duplicate data. Pause the video now if you want time to think about the answer.
The correct answer is B. data is queried and manipulated by using a variant of the SQL language. A primary characteristic of relational databases is that data is queried and manipulated using SQL or a variant of SQL. SQL's standardized language for defining, retrieving, and modifying relational data is fundamental to how relational databases operate. Relational databases have structured, not flexible, data; they maintain dependencies between tables through foreign keys; and normalization minimizes duplicate data. Now, why are the other options incorrect? Option A is incorrect. Relational databases enforce strict schemas, not flexible data structures. Option C is incorrect. Relational databases intentionally establish dependencies between tables through keys and relationships. Option D is incorrect. Relational databases use normalization to minimize duplication, not create large amounts of duplicate data. Therefore, B, data is queried and manipulated by using a variant of the SQL language, is the correct answer.
Play from 16:56 Question 12. When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region? Here are the options. Option A. multi-master replication. Option B. Availability Zones. Option C. the strong consistency level. Option D. automatic failover. Pause the video now if you want time to think about the answer.
The correct answer is B. Availability Zones. Availability Zones provide redundancy and high availability within a single Azure region by distributing replicas across multiple physically separate zones within that region. This ensures data remains available even if one zone fails. Now, why are the other options incorrect? Option A is incorrect. Multi-master replication provides redundancy across multiple regions, not within a single region. Option C is incorrect. Strong consistency is a consistency level setting that does not provide redundancy within a region. Option D is incorrect. Automatic failover handles recovery when a failure occurs but does not itself provide the redundancy mechanism within a region. Therefore, B, Availability Zones, is the correct answer.
Play from 18:29 Question 13. What should you use to automatically delete blobs from Azure Blob Storage? Here are the options. Option A. archive storage. Option B. the change feed. Option C. soft delete. Option D. a lifecycle management policy. Pause the video now if you want time to think about the answer.
The correct answer is D. a lifecycle management policy. Lifecycle management policies in Azure Blob Storage allow you to automatically delete, archive, or tier blobs based on age and other conditions. Archive storage is a tier for infrequent access, the change feed tracks changes to blobs, and soft delete allows recovery of deleted blobs-none of these automatically delete blobs like lifecycle policies do. Now, why are the other options incorrect? Option A is incorrect. Archive storage is a tier for retention, not automatic deletion. Option B is incorrect. The change feed tracks blob changes but does not delete blobs. Option C is incorrect. Soft delete allows recovery of deleted blobs; it does not automatically delete them. Therefore, D, a lifecycle management policy, is the correct answer.
Play from 19:54 Question 14. In a relational database, which element enforces that a value in one table must already exist in another table? Here are the options. Option A. Primary key. Option B. Index. Option C. Foreign key. Option D. View. Pause the video now if you want time to think about the answer.
The correct answer is C. Foreign key. A foreign key constrains a column so that its values must match an existing value in the referenced table's key column. This is what enforces referential integrity between the two tables. Now, why are the other options incorrect? Option A is incorrect. A primary key uniquely identifies rows within its own table. It does not reference another table. Option B is incorrect. An index improves query performance and does not enforce relationships between tables. Option D is incorrect. A view is a stored query presented as a virtual table and enforces no constraints. Therefore, C, Foreign key, is the correct answer.
Play from 21:16 Question 15. You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario? Here are the options. Option A. Online Transaction Processing (OLTP). Option B. batch. Option C. massively parallel processing (MPP). Option D. streaming. Pause the video now if you want time to think about the answer.
The correct answer is D. streaming. Streaming workloads are designed for real-time data ingestion from continuous sources like mobile applications. They process data as it arrives with minimal latency, which matches the requirement to gather real-time telemetry data from a mobile application. Now, why are the other options incorrect? Option A is incorrect. OLTP handles transactional queries, not continuous real-time data streams. Option B is incorrect. Batch processing collects data over time before processing it, not real-time gathering. Option C is incorrect. Massively parallel processing (MPP) is for large-scale data analytics, not real-time telemetry collection. Therefore, D, streaming, is the correct answer.
Play from 22:44 Question 16. A retail point of sale (POS) system is an example of which type of solution? Here are the options. Option A. a data warehouse. Option B. online analytical processing (OLAP). Option C. extract, transform, and load (ETL). Option D. online transaction processing (OLTP). Pause the video now if you want time to think about the answer.
The correct answer is D. online transaction processing (OLTP). A point of sale (POS) system handles real-time transactions where sales data is immediately recorded. OLTP (Online Transaction Processing) systems are designed for high-volume, real-time transactional operations with frequent inserts, updates, and queries. Data warehouses and OLAP systems are designed for analytical queries on historical data, while ETL is a process for moving data between systems. Now, why are the other options incorrect? Option A is incorrect. A data warehouse stores aggregated historical data for analysis, not real-time transaction processing. Option B is incorrect. OLAP is used for analytical queries on aggregated data, not for processing individual transactions. Option C is incorrect. ETL is a process for extracting and loading data, not a type of operational system. Therefore, D, online transaction processing (OLTP), is the correct answer.
Play from 24:36 Question 17. At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. Here are the options. Option A. database. Option B. item. Option C. container. Option D. partition. Pause the video now if you want time to think about the answer.
The correct answers are A. database, and C. container. Throughput in Azure Cosmos DB can be set at two levels: at the database level (applying to all containers within it) or at the container level (for individual container control). This two-level approach allows flexible resource allocation depending on workload requirements. Now, why are the other options incorrect? Option B is incorrect. Item-level throughput is not a configuration option in Azure Cosmos DB. Option D is incorrect. Partition-level throughput is not a user-configurable setting; partitions are managed automatically by the service. Therefore, A and C are the correct answers.
Play from 26:00 Question 18. What is used to define a query in a stream processing jobs in Azure Stream Analytics? Here are the options. Option A. YAML. Option B. KQL. Option C. SQL. Option D. XML. Pause the video now if you want time to think about the answer.
The correct answer is C. SQL. Azure Stream Analytics uses SQL (a variant called Stream Analytics Query Language) to define queries for stream processing jobs. SQL provides an intuitive way to process streaming data with familiar syntax for filtering, joining, and aggregating event data. YAML, KQL, and XML are not used for defining Stream Analytics queries. Now, why are the other options incorrect? Option A is incorrect. YAML is a configuration language, not used for Stream Analytics query definition. Option B is incorrect. KQL (Kusto Query Language) is used in Azure Data Explorer, not Stream Analytics. Option D is incorrect. XML is a markup language, not used for Stream Analytics query definition. Therefore, C, SQL, is the correct answer.
Play from 27:32 Question 19. Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts? Here are the options. Option A. consistency. Option B. atomicity. Option C. durability. Option D. isolation. Pause the video now if you want time to think about the answer.
The correct answer is C. durability. Durability is the ACID property that ensures transactional changes to a database are preserved during unexpected operating system restarts or failures. Once a transaction is committed, its changes persist permanently even if the system crashes immediately afterward. Now, why are the other options incorrect? Option A is incorrect. Consistency ensures data integrity rules are maintained but does not specifically guarantee preservation during restarts. Option B is incorrect. Atomicity ensures transactions complete fully or not at all but does not guarantee persistence after system failures. Option D is incorrect. Isolation prevents concurrent transactions from interfering with each other but does not ensure recovery from system restarts. Therefore, C, durability, is the correct answer.
Play from 29:05 Question 20. Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document? Here are the options. Option A. document. Option B. columnar. Option C. graph. Option D. time series. Pause the video now if you want time to think about the answer.
The correct answer is A. document. Document databases are specifically designed to store data as JSON (or similar semi-structured formats) with flexible schemas, where all data for an entity is stored together in a single document. This matches all three criteria in the question perfectly. Now, why are the other options incorrect? Option B is incorrect. Columnar stores organize data by column rather than by document, and are optimized for analytical queries on specific columns. Option C is incorrect. Graph databases store data as nodes and edges to represent relationships, not as JSON documents. Option D is incorrect. Time series databases are optimized for timestamped data points, not flexible schema JSON documents. Therefore, A, document, is the correct answer.
Play from 30:36 Question 21. You need to modify a view in a relational database by adding a new column. Which statement should you use? Here are the options. Option A. MERGE. Option B. ALTER. Option C. INSERT. Option D. UPDATE. Pause the video now if you want time to think about the answer.
The correct answer is B. ALTER. The ALTER statement is used to modify existing database objects, including views. To add a new column to a view definition, you use ALTER VIEW. MERGE is used to perform insert, update, or delete operations based on source and target conditions, INSERT adds new rows, and UPDATE modifies existing row data-none of these modify the structure of a view itself. Now, why are the other options incorrect? Option A is incorrect. MERGE is used for conditional insert, update, or delete operations, not for modifying view structure. Option C is incorrect. INSERT adds new data rows but does not modify the view definition. Option D is incorrect. UPDATE modifies data values but does not alter the view structure or definition. Therefore, B, ALTER, is the correct answer.
Play from 32:13 Question 22. Which file format has defined names and data types for each column and uses compressed columnar storage? Here are the options. Option A. HTML. Option B. CSV. Option C. Apache Parquet. Option D. JSON. Pause the video now if you want time to think about the answer.
The correct answer is C. Apache Parquet. Apache Parquet is a columnar storage format that defines named columns with specific data types and uses compression techniques optimized for analytical queries. HTML is a markup language, CSV is plain text without type definitions, and JSON is a hierarchical format without enforced schemas or columnar compression. Now, why are the other options incorrect? Option A is incorrect. HTML is a markup language for web documents, not a data storage format with typed columns. Option B is incorrect. CSV is a plain text format that does not enforce data types or use columnar compression. Option D is incorrect. JSON is a hierarchical document format without columnar storage or built-in compression. Therefore, C, Apache Parquet, is the correct answer.
Play from 33:44 Question 23. Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network. Which type of data store should you use? Here are the options. Option A. graph. Option B. key/value. Option C. document. Option D. columnar. Pause the video now if you want time to think about the answer.
The correct answer is A. graph. Graph databases excel at modeling relationships and dependencies between entities. Network traffic patterns showing how changes in one area affect others represents a connected relationship problem that graph data structures handle optimally. Now, why are the other options incorrect? Option B is incorrect. Key/value stores are designed for simple lookups and do not model complex relationships well. Option C is incorrect. Document stores are better for storing self-contained entities rather than modeling cross-entity relationships. Option D is incorrect. Columnar databases are optimized for analytical queries on large datasets, not for representing relationships between entities. Therefore, A, graph, is the correct answer.
Play from 35:15 Question 24. Which activity is most common for transactional workloads? Here are the options. Option A. recording small units of work events in real time. Option B. aggregating massive amounts of data. Option C. producing complex reports. Option D. performing self-service data exploration. Pause the video now if you want time to think about the answer.
The correct answer is A. recording small units of work events in real time. Transactional workloads are characterized by recording small, discrete units of work events in real time, such as individual sales transactions, account transfers, or inventory updates. These systems prioritize speed, consistency, and immediate data recording rather than bulk analysis or reporting. Now, why are the other options incorrect? Option B is incorrect. Aggregating massive amounts of data is characteristic of analytical workloads, not transactional ones. Option C is incorrect. Producing complex reports is an analytical activity, not the primary focus of transactional systems. Option D is incorrect. Self-service data exploration is an analytical and exploratory activity, not typical of transactional workloads. Therefore, A, recording small units of work events in real time, is the correct answer.
Play from 36:51 Question 25. You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use? Here are the options. Option A. Online Transaction Processing (OLTP). Option B. batch processing. Option C. Online Analytical Processing (OLAP). Option D. stream processing. Pause the video now if you want time to think about the answer.
The correct answer is C. Online Analytical Processing (OLAP). A quality assurance application reading from a data warehouse uses Online Analytical Processing (OLAP). Data warehouses are designed to support analytical queries and reporting on historical data, which is the core function of OLAP systems. Now, why are the other options incorrect? Option A is incorrect. OLTP is used for transactional systems with frequent writes and operational data, not analytical queries against historical warehouse data. Option B is incorrect. Batch processing refers to processing data in scheduled groups, while OLAP provides interactive analytical query capability. Option D is incorrect. Stream processing handles real-time continuous data flows, not the static analytical queries typical of data warehouse applications. Therefore, C, Online Analytical Processing (OLAP), is the correct answer.
Play from 38:33 Question 26. What is the responsibility of a database administrator? Here are the options. Option A. applying data cleaning routines. Option B. creating data visualizations. Option C. managing data integration processes. Option D. storing backup copies of data. Pause the video now if you want time to think about the answer.
The correct answer is D. storing backup copies of data. A database administrator's primary responsibility is ensuring data protection and business continuity through backup and recovery procedures. While DBAs may be involved in other tasks, storing and managing backup copies is a core DBA function that protects against data loss and ensures disaster recovery capability. Now, why are the other options incorrect? Option A is incorrect. Data cleaning routines are typically handled by data engineers or ETL specialists, not core DBA responsibilities. Option B is incorrect. Creating data visualizations is the role of business analysts or data visualization specialists, not database administrators. Option C is incorrect. Managing data integration processes is primarily an ETL engineer or data integration specialist role, not a DBA function. Therefore, D, storing backup copies of data, is the correct answer.
Play from 40:16 Question 27. What is a characteristic of non-relational data? Here are the options. Option A. no indexes. Option B. self-describing entities. Option C. a well-defined schema. Option D. no unique key values. Pause the video now if you want time to think about the answer.
The correct answer is B. self-describing entities. Non-relational data is typically characterized by self-describing entities, where the structure and metadata are embedded within the data itself. This allows flexible schemas and varied structures across different records without predefined enforcement. Now, why are the other options incorrect? Option A is incorrect. Non-relational databases typically have indexes to optimize query performance. Option C is incorrect. Non-relational data specifically allows flexible, application-defined schemas rather than well-defined rigid schemas. Option D is incorrect. Non-relational data stores do use unique key values to identify records. Therefore, B, self-describing entities, is the correct answer.
Play from 41:41 Question 28. Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache? Here are the options. Option A. the Hot access tier. Option B. change feed. Option C. snapshots. Option D. versioning. Pause the video now if you want time to think about the answer.
The correct answer is B. change feed. Change feed is the Azure Blob Storage feature that enables syncing a Blob Storage account to an external cache by providing a record of all changes that occur to blobs and metadata in a storage account. This allows external systems to detect and respond to modifications, facilitating cache synchronization. Now, why are the other options incorrect? Option A is incorrect. The Hot access tier is a performance/cost classification, not a synchronization mechanism for external caches. Option C is incorrect. Snapshots create point-in-time copies of blobs but do not provide change tracking for cache synchronization. Option D is incorrect. Versioning maintains previous versions of blobs but does not track changes for external cache synchronization purposes. Therefore, B, change feed, is the correct answer.
Play from 43:07 Question 29. Which Azure Data Factory component initiates the execution of a pipeline? Here are the options. Option A. a control flow. Option B. a trigger. Option C. a parameter. Option D. an activity. Pause the video now if you want time to think about the answer.
The correct answer is B. a trigger. A trigger is the Azure Data Factory component that initiates pipeline execution. Triggers define when and how a pipeline should run, whether on a schedule, in response to events, or through manual invocation. Now, why are the other options incorrect? Option A is incorrect. Control flow manages the flow of activities within a pipeline after execution has begun, not the initiation. Option C is incorrect. Parameters are used to pass values into pipelines but do not initiate execution. Option D is incorrect. Activities are individual tasks within a pipeline that execute after the pipeline has been triggered. Therefore, B, a trigger, is the correct answer.
Play from 44:27 Question 30. Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use? Here are the options. Option A. relational. Option B. time series. Option C. graph. Option D. columnar. Pause the video now if you want time to think about the answer.
The correct answer is B. time series. Time series databases are purpose-built for storing and analyzing sensor data collected over time. They are optimized for ingesting high-volume sequential data points and performing trend analysis, making them ideal for temperature sensor telemetry that requires temporal analysis. Now, why are the other options incorrect? Option A is incorrect. Relational databases are not optimized for the high-velocity, high-volume nature of sensor data. Option C is incorrect. Graph databases are for relationship analysis, not temporal trend analysis. Option D is incorrect. Columnar databases, while good for analytics, lack the temporal optimizations of time series databases. Therefore, B, time series, is the correct answer.
Play from 45:55 Question 31. A bar chart showing year-to-date sales by region is an example of which type of analytics? Here are the options. Option A. predictive. Option B. prescriptive. Option C. descriptive. Option D. diagnostic. Pause the video now if you want time to think about the answer.
The correct answer is C. descriptive. A bar chart showing year-to-date sales by region is descriptive analytics because it describes what has happened in the past by presenting historical sales data organized by geographic region. Descriptive analytics answers the question 'what happened?' by summarizing and visualizing existing data, which is exactly what this chart does. Now, why are the other options incorrect? Option A is incorrect. Predictive analytics forecasts future outcomes based on historical data, not summarizes past performance. Option B is incorrect. Prescriptive analytics recommends actions to optimize outcomes, not merely displays historical results. Option D is incorrect. Diagnostic analytics investigates why something happened by drilling deeper into causes, not simply reporting regional totals. Therefore, C, descriptive, is the correct answer.
Play from 47:28 Question 32. Which type of Microsoft Power BI visual can you use to examine trends over time for one or more series of values? Here are the options. Option A. funnel chart. Option B. pie chart. Option C. table. Option D. line chart. Pause the video now if you want time to think about the answer.
The correct answer is D. line chart. A line chart is specifically designed to display trends over time by connecting data points with lines. It effectively shows how one or more series of values change across a continuous time axis, making it ideal for trend analysis. Now, why are the other options incorrect? Option A is incorrect. A funnel chart displays progressive stages in a process, not trends over time. Option B is incorrect. A pie chart shows proportions of a whole at a single point in time, not trends over time. Option C is incorrect. A table displays raw data in rows and columns but does not visually emphasize trends over time. Therefore, D, line chart, is the correct answer.
Play from 48:48 Question 33. Which schema design process minimizes data duplication and enforces data integrity? Here are the options. Option A. normalization. Option B. batch processing. Option C. extraction. Option D. virtualization. Pause the video now if you want time to think about the answer.
The correct answer is A. normalization. Normalization is the systematic database design process that organizes data into related tables to eliminate redundancy and enforce referential integrity. It reduces data duplication through techniques like breaking data into multiple tables and establishing key relationships. Now, why are the other options incorrect? Option B is incorrect. Batch processing is a data processing technique for handling large volumes of data, not a schema design process. Option C is incorrect. Extraction is part of ETL operations and refers to retrieving data from sources, not schema design. Option D is incorrect. Virtualization abstracts underlying infrastructure but does not address schema design principles for data integrity. Therefore, A, normalization, is the correct answer.
Play from 50:16 Question 34. Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use? Here are the options. Option A. Azure Application Gateway. Option B. Azure Traffic Manager. Option C. Azure DNS. Option D. Azure Private Link. Pause the video now if you want time to think about the answer.
The correct answer is D. Azure Private Link. Azure Private Link enables private connectivity between Azure virtual machines and Azure SQL databases by creating private endpoints, eliminating exposure to the public internet. This solution provides secure, dedicated network connections without requiring VPN or gateway configurations. Now, why are the other options incorrect? Option A is incorrect. Application Gateway is a web traffic load balancer, not designed for private database connectivity. Option B is incorrect. Traffic Manager is a DNS-based traffic router for load balancing across regions, not for private connectivity. Option C is incorrect. DNS is a name resolution service and does not provide private connectivity between services. Therefore, D, Azure Private Link, is the correct answer.
Play from 51:49 Question 35. Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely? Here are the options. Option A. atomicity. Option B. isolation. Option C. durability. Option D. consistency. Pause the video now if you want time to think about the answer.
The correct answer is A. atomicity. Atomicity is the ACID property that guarantees each transaction is treated as a single indivisible unit-it either completes entirely and succeeds, or fails completely with no partial results. This all-or-nothing approach prevents data inconsistencies from incomplete transactions. Now, why are the other options incorrect? Option B is incorrect. Isolation ensures transactions do not interfere with each other, not that they succeed or fail completely. Option C is incorrect. Durability ensures committed data persists after a transaction completes, not that transactions are all-or-nothing. Option D is incorrect. Consistency ensures the database moves from one valid state to another, not that transactions are treated as single units. Therefore, A, atomicity, is the correct answer.
Play from 53:21 Question 36. What is required to provision Azure Data Lake Storage in an Azure Storage account? Here are the options. Option A. Versioning must be disabled. Option B. Hierarchical namespace must be disabled. Option C. Versioning must be enabled. Option D. Hierarchical namespace must be enabled. Pause the video now if you want time to think about the answer.
The correct answer is D. Hierarchical namespace must be enabled. Azure Data Lake Storage Gen2 requires that hierarchical namespace be enabled on the Azure Storage account. Hierarchical namespace enables the file system semantics and organizational structure that makes Data Lake Storage distinct from standard Blob Storage. Without enabling this feature, you cannot provision Data Lake Storage capabilities. Now, why are the other options incorrect? Option A is incorrect. Versioning being disabled is not a requirement for Data Lake Storage provisioning. Option B is incorrect. Hierarchical namespace must be enabled, not disabled, to use Data Lake Storage. Option C is incorrect. Versioning being enabled is not a requirement for Data Lake Storage provisioning. Therefore, D, Hierarchical namespace must be enabled, is the correct answer.
Play from 54:53 Question 37. Which type of database contains nodes and edges? Here are the options. Option A. graph. Option B. key/value. Option C. columnar. Option D. time series. Pause the video now if you want time to think about the answer.
The correct answer is A. graph. A graph database is specifically designed to store and query data organized as nodes and edges, representing entities and their relationships. Graph databases excel at traversing complex relationship networks and are used for social networks, recommendation systems, and knowledge graphs. Now, why are the other options incorrect? Option B is incorrect. Key/value databases store simple key-value pairs without explicit node and edge structures. Option C is incorrect. Columnar databases organize data by columns for analytical queries, not by nodes and edges. Option D is incorrect. Time series databases are optimized for time-stamped data points, not graph structures with nodes and edges. Therefore, A, graph, is the correct answer.
Play from 56:20 Question 38. A company stores customer records as JSON documents where different customers have different sets of fields. Which type of data is this? Here are the options. Option A. Structured data. Option B. Semi-structured data. Option C. Unstructured data. Option D. Relational data. Pause the video now if you want time to think about the answer.
The correct answer is B. Semi-structured data. Semi-structured data carries its own organisational markers, such as JSON keys, but does not conform to a fixed schema. Different documents can hold different fields, which is precisely the described scenario. Now, why are the other options incorrect? Option A is incorrect. Structured data conforms to a rigid, predefined schema where every row has the same columns. Option C is incorrect. Unstructured data has no organisational markers at all, such as video files or free-form text. JSON keys are markers. Option D is incorrect. Relational data is a form of structured data stored in tables with a fixed schema and defined relationships. Therefore, B, Semi-structured data, is the correct answer.
Play from 57:49 Question 39. You have structured data in tabular format. What represents an individual instance of a data entity? Here are the options. Option A. a column. Option B. a table. Option C. a cell. Option D. a row. Pause the video now if you want time to think about the answer.
The correct answer is D. a row. In tabular data, a row represents a single record or instance of a data entity, with each column containing a specific attribute value for that entity. Columns define attributes, a table is a collection of rows, and a cell is a single value within a row. Now, why are the other options incorrect? Option A is incorrect. A column defines an attribute type, not an individual instance of an entity. Option B is incorrect. A table is a collection of multiple entity instances, not a single instance. Option C is incorrect. A cell is a single data value, not an entire entity instance. Therefore, D, a row, is the correct answer.
Play from 59:08 Question 40. You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use? Here are the options. Option A. stream processing. Option B. batch processing. Option C. Online Analytical Processing (OLAP). Option D. Online Transaction Processing (OLTP). Pause the video now if you want time to think about the answer.
The correct answer is D. Online Transaction Processing (OLTP). An e-commerce application that reads and writes data in real-time performs Online Transaction Processing (OLTP). OLTP systems handle individual transactions immediately, which is characteristic of e-commerce platforms that process orders, payments, and inventory updates as they occur. Azure SQL Database is optimized for OLTP workloads with its support for concurrent transactions and ACID properties. Now, why are the other options incorrect? Option A is incorrect. Stream processing handles continuous data flows in real-time, not discrete database transactions typical of e-commerce. Option B is incorrect. Batch processing groups multiple transactions together for processing at scheduled intervals, not the immediate transaction handling needed for e-commerce. Option C is incorrect. OLAP is used for analytical queries on historical data, not the transactional operations of an e-commerce application. Therefore, D, Online Transaction Processing (OLTP), is the correct answer.
Play from 1:00:59 Question 41. Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network. Which type of data store should you use? Here are the options. Option A. graph. Option B. key/value. Option C. document. Option D. columnar. Pause the video now if you want time to think about the answer.
The correct answer is A. graph. Graph databases are designed to model and visualize relationships between entities. Network device utilization levels and their interconnected relationships are best represented as nodes (devices) and edges (relationships), making a graph database ideal for this scenario. Now, why are the other options incorrect? Option B is incorrect. Key/value stores lack the relationship modeling capabilities needed to show how device utilization levels interconnect. Option C is incorrect. Document stores organize self-contained entities rather than emphasizing relationships between network devices. Option D is incorrect. Columnar databases are optimized for analytical aggregations on large datasets, not for illustrating entity relationships. Therefore, A, graph, is the correct answer.
Play from 1:02:33 Question 42. What is a function of a modern data warehouse? Here are the options. Option A. supports batch processing only. Option B. supports real-time and batch processing. Option C. provides built-in or native online analytical processing. Option D. stores raw data only. Pause the video now if you want time to think about the answer.
The correct answer is B. supports real-time and batch processing. A modern data warehouse supports both real-time and batch processing, enabling organizations to handle streaming data alongside traditional batch operations. This dual capability allows businesses to serve both immediate analytical needs and comprehensive reporting requirements from a single unified platform. Now, why are the other options incorrect? Option A is incorrect. Modern data warehouses support both batch and real-time processing, not batch only. Option C is incorrect. While some modern data warehouses include native OLAP capabilities, this is not a universal requirement. Option D is incorrect. Modern data warehouses process transformed and structured data, not raw data only. Therefore, B, supports real-time and batch processing, is the correct answer.
Play from 1:04:08 Question 43. Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers? Here are the options. Option A. Hot to Cool. Option B. Hot to Archive. Option C. Cool to Archive. Option D. Archive to Cool. Pause the video now if you want time to think about the answer.
The correct answer is D. Archive to Cool. Blob rehydration is the process of moving a blob from the Archive tier to a more accessible tier like Cool or Hot. Archive is the coldest tier with lowest cost but longest retrieval times. When data needs to be accessed again, it must be rehydrated by moving it to Cool or Hot tier, making Archive to Cool the correct answer. Now, why are the other options incorrect? Option A is incorrect. Moving from Hot to Cool is a standard tier transition, not a rehydration process. Option B is incorrect. Moving from Hot to Archive is archival, the opposite direction of rehydration. Option C is incorrect. Moving from Cool to Archive is archival, not rehydration. Therefore, D, Archive to Cool, is the correct answer.
Play from 1:05:34 Question 44. You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use? Here are the options. Option A. queue. Option B. blob. Option C. file. Option D. table. Pause the video now if you want time to think about the answer.
The correct answer is C. file. Azure Files provides cloud-based file shares that replicate the functionality of Windows network file shares, making it the natural replacement for an on-premises shared folder. It supports SMB and NFS protocols and integrates seamlessly with existing file-based workflows. Now, why are the other options incorrect? Option A is incorrect. Queue storage is for message queuing and asynchronous communication, not file sharing. Option B is incorrect. Blob storage is for unstructured binary data and does not provide file share semantics or folder hierarchies. Option D is incorrect. Table storage is for structured key-attribute data, not for hierarchical file organization. Therefore, C, file, is the correct answer.
Play from 1:07:02 Question 45. Which storage solution supports access control lists (ACLs) at the file and folder level? Here are the options. Option A. Azure Data Lake Storage. Option B. Azure Queue storage. Option C. Azure Blob storage. Option D. Azure Cosmos DB. Pause the video now if you want time to think about the answer.
The correct answer is A. Azure Data Lake Storage. Azure Data Lake Storage supports access control lists (ACLs) at both the file and folder level, providing granular permissions management. This hierarchical ACL support is essential for data governance and security in analytics scenarios. Now, why are the other options incorrect? Option B is incorrect. Azure Queue storage is a message queuing service and does not support file or folder-level ACLs. Option C is incorrect. Azure Blob storage supports role-based access control (RBAC) but not traditional file and folder-level ACLs like Data Lake Storage. Option D is incorrect. Azure Cosmos DB is a NoSQL database and does not support file and folder-level ACLs. Therefore, A, Azure Data Lake Storage, is the correct answer.
Play from 1:08:35 Question 46. Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema. Which type of data store should you use? Here are the options. Option A. columnar. Option B. key/value. Option C. document. Option D. graph. Pause the video now if you want time to think about the answer.
The correct answer is C. document. Document stores are designed for high-volume JSON data with flexible, application-defined schemas. They store semi-structured data natively and allow schema variation across documents, making them ideal for scenarios where the data structure is defined by the application rather than enforced by the database. Now, why are the other options incorrect? Option A is incorrect. Columnar stores are optimized for analytical queries on fixed schemas, not flexible JSON data. Option B is incorrect. Key/value stores lack the ability to query within the document structure that JSON data requires. Option D is incorrect. Graph databases are optimized for relationship traversal, not storing large volumes of JSON documents. Therefore, C, document, is the correct answer.
Play from 1:10:09 Question 47. In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. Here are the options. Option A. a partition key. Option B. a range. Option C. a row key. Option D. a timestamp. Pause the video now if you want time to think about the answer.
The correct answers are A. a partition key, and C. a row key. In Azure Table Storage, each row (entity) is uniquely identified by the combination of a partition key and a row key. The partition key groups related data and distributes it across partitions, while the row key uniquely identifies the entity within that partition. Together, they form the composite primary key. Now, why are the other options incorrect? Option B is incorrect. A range is not a component of Table Storage entity identification. Option D is incorrect. Timestamp is a property that tracks last modification but does not uniquely identify entities. Therefore, A and C are the correct answers.
Play from 1:11:36 Question 48. Which type of Azure resource supports the serverless configuration of an Azure SQL database? Here are the options. Option A. SQL Server on Azure Virtual Machines. Option B. an Azure SQL Database elastic pool. Option C. a single database in Azure SQL Database. Option D. Azure SQL Managed Instance. Pause the video now if you want time to think about the answer.
The correct answer is C. a single database in Azure SQL Database. The serverless compute tier is available for single databases in Azure SQL Database, providing automatic scaling and pause/resume functionality. SQL Server on VMs, elastic pools, and Managed Instance do not support serverless configurations. Now, why are the other options incorrect? Option A is incorrect. SQL Server on Azure Virtual Machines does not support serverless configurations. Option B is incorrect. Elastic pools in Azure SQL Database do not support serverless compute tiers. Option D is incorrect. Azure SQL Managed Instance does not offer serverless configuration options. Therefore, C, a single database in Azure SQL Database, is the correct answer.
Play from 1:13:11 Question 49. You need to create an Azure resource to store data in Azure Table storage. Which command should you run? Here are the options. Option A. az storage share create. Option B. az storage account create. Option C. az cosmosdb create. Option D. az storage container create. Pause the video now if you want time to think about the answer.
The correct answer is B. az storage account create. To create an Azure resource for storing data in Azure Table storage, you must first create a storage account using 'az storage account create'. Table storage is a service within a storage account. While 'az storage container create' creates a blob container (for blob storage) and 'az cosmosdb create' creates a Cosmos database, and 'az storage share create' creates a file share, none of these commands directly provision Table storage. The storage account must exist first. Now, why are the other options incorrect? Option A is incorrect. This command creates a file share, not Table storage. Option C is incorrect. This command creates a Cosmos DB resource, which is a different service from Table storage. Option D is incorrect. This command creates a blob container, not Table storage. Therefore, B, az storage account create, is the correct answer.
Play from 1:14:51 Question 50. Structured data where each row represents a single data entity uses which type of schema? Here are the options. Option A. XML. Option B. tabular. Option C. blob. Option D. JSON. Pause the video now if you want time to think about the answer.
The correct answer is B. tabular. Tabular schema represents structured data in rows and columns where each row represents a single data entity. This is the standard format for relational databases and structured data storage, with consistent columns across rows. Now, why are the other options incorrect? Option A is incorrect. XML is a hierarchical, semi-structured format that does not organize data as simple rows and columns. Option C is incorrect. Blob storage holds unstructured binary data without schema or rows. Option D is incorrect. JSON is a semi-structured format that can nest data and does not enforce the strict tabular row-column structure. Therefore, B, tabular, is the correct answer.
