Azure Data Engineer (DP-203) Azure Data Engineer (DP-203) Azure Data Engineer (DP-203) 1 / 20 Which of the following can be used to move data from on-premises sources to Azure data services? Azure Data Factory Azure SQL Data Warehouse Azure Databricks Azure Synapse Studio 2 / 20 Which Azure service provides a set of tools for managing and analyzing large-scale datasets in real-time? Azure Stream Analytics Azure Data Explorer Azure SQL Database Azure Data Lake Storage 3 / 20 How do you ensure high availability in Azure SQL Database? By enabling sharding By storing data in Azure Blob Storage By using Azure Kubernetes Services (AKS) By using geo-replication 4 / 20 What is the purpose of an Azure Data Lake Gen2 hierarchical namespace? To organize data and improve management of large datasets To store data in a secure format To support multi-region replication To enhance machine learning training speeds 5 / 20 Which of the following is the main advantage of using Azure Cosmos DB? Global distribution with low-latency access Real-time processing of large datasets Cost-effective data storage for small applications Built-in machine learning capabilities 6 / 20 What type of data is most suited for Azure Data Lake Storage Gen2? Unstructured data such as logs and multimedia files Structured transactional data Binary data for secure storage Relational data with fixed schemas 7 / 20 Which service is used in Azure to provide monitoring and logging for all your resources? Azure Synapse Studio Azure Monitor Azure Key Vault Azure Event Grid 8 / 20 Which of the following is a feature of Azure Synapse Analytics? Ability to manage both on-demand and provisioned resources Store only transactional data Limited support for non-relational data Provides built-in machine learning pipelines 9 / 20 How does Azure Data Lake Storage Gen2 support big data analytics? By offering low-latency transactional processing By supporting advanced analytics in the cloud By enabling data processing using Spark and Hive By storing data in a distributed, hierarchical structure 10 / 20 Which of the following data types is NOT supported by Azure SQL Database? Images Binary Data JSON BigInt 11 / 20 What is the function of Azure Data Factory’s data flow feature? Stores data in a centralized repository Analyzes data to generate machine learning models Allows designing data transformation and movement workflows Provides security measures for data 12 / 20 What does the term "data wrangling" refer to in Azure? Preparing data for analysis Real-time streaming data ingestion Generating insights from machine learning models Storing and encrypting data 13 / 20 In Azure, which service provides both a fully-managed relational database and a global distribution model? Azure Cosmos DB Azure SQL Database Azure Databricks Azure Data Lake Storage 14 / 20 What is the default file format used by Azure Data Lake Storage Gen2 for storing data? CSV JSON Avro Parquet 15 / 20 Which of the following services can be used for serverless SQL queries on Azure Data Lake? Azure Synapse Studio Azure SQL Data Warehouse Azure Blob Storage Azure Data Factory 16 / 20 What is the primary benefit of using Azure Databricks? Unified analytics platform for big data and AI Data storage in the cloud Basic machine learning model deployment Real-time data ingestion 17 / 20 Which of the following is used to process large-scale real-time streaming data in Azure? Azure SQL Database Azure Machine Learning Azure Stream Analytics Azure Databricks 18 / 20 In Azure Synapse Analytics, which of the following is used for querying and transforming data? Data Flow Azure Functions SQL Pools Cosmos DB 19 / 20 Which Azure service is designed to store unstructured data such as images, audio, and video? Azure Data Lake Azure SQL Database Azure Blob Storage Azure Cosmos DB 20 / 20 What is the primary purpose of the Azure Data Factory service? Orchestrating data flows and ETL processes Storing structured data Performing machine learning tasks Monitoring network traffic Your score isThe average score is 0% 0% Restart quiz
