All questions

Microsoft Certified: Azure Data Fundamentals (DP-900) Practice Test

Browse all practice questions for the Microsoft Certified: Azure Data Fundamentals (DP-900) Practice Test. Search by topic, open any question and review its full explanation, then test yourself in the practice quiz.

Start practice testFlash cards
Microsoft Certified: Azure Data Fundamentals (DP-900) Practice Test course image
Discover How Azure Pipelines Streamline Data IngestionWhich Azure Data Factory component is used to run data ingestion tasks?Discover how Bounded Staleness works in Azure Cosmos DBWhat describes the Bounded Staleness option in Azure Cosmos DB?Discover the Key Elements of Power BI for Effective Data InsightsWhich three primary elements make up Power BI?Discover the Key Features of Azure Cosmos DBWhich of the following is a characteristic of Azure Cosmos DB?Discover the Relational Databases Offered by AzureWhich of the following are currently available relational databases on Azure?Discover Why Synapse Spark is Your Go-To for Data Science and AI in Azure SynapseIn Azure Synapse, which component is best suited for data science and AI tasks?Discovering What Azure Databricks Offers on the Azure PlatformWhat does Azure Databricks provide on the Azure platform?Explore Azure Table Storage and its High Scalability for Semi-Structured DataWhat is an essential feature of Azure Table Storage regarding data?Explore the Consistent Prefix Model in Azure Data FundamentalsWhich consistency option ensures that changes appear in order, with possible delays before they are visible?Explore the Power BI Tool for Creating Paginated ReportsWhich Power BI tool is used to create paginated reports?Exploring the Computational Models in Azure Synapse AnalyticsWhat are the two computational models supported by Azure Synapse Analytics?Exploring the Default Behavior of Azure Cosmos DB for ReplicationWhat is the default behavior when configuring Azure Cosmos DB for replication?Exploring the Importance of the Session Consistency Model in Azure DataWhat does the session consistency model ensure?Exploring the Key Benefits of Using PaaS in Modern Application DevelopmentWhat is the main advantage of using PaaS?Exploring the Limits of Azure Table Storage's AdvantagesWhich of the following is NOT an advantage of Azure Table Storage?Exploring the Uses of Azure Blob Storage and Its LimitationsWhich of the following is not a use case for Azure Blob Storage?Exploring the World of Semi-Structured Data with JSONWhich of the following formats is considered semi-structured data?Exploring What Data Really Means in Azure With DP-900Which of the following best describes what data includes?How AzCopy Streamlines Large File Transfers to Azure File StorageWhich command-line utility is optimized for transferring large files between a local computer and Azure File storage?How is Azure Table Storage Structured for Optimal Data Management?How is Azure Table Storage structured?Learn How IP Whitelisting Strengthens Security in Azure DatabasesWhich approach enhances Azure database security by defining which IPs can connect?Understand the Power of Azure Synapse Analytics for Handling Complex Data QueriesWhich service is recommended for high volumes of data and complex queries?Understanding ACID Principles in OLTP DatabasesWhat does ACID stand for in the context of OLTP databases?Understanding Azure Blob Storage and Its Role in Unstructured Data ManagementWhat type of data is Azure Blob Storage primarily designed to store?Understanding Azure Data Factory and Its Role in Data ManagementWhat is Azure Data Factory primarily used for?Understanding Azure RBAC: The Basics of Role-Based Access ControlWhat does Azure RBAC stand for?Understanding Azure Synapse Analytics: Optimizing Complex Queries for High PerformanceWhat type of queries is Azure Synapse Analytics optimized for?Understanding Azure Table Storage Data Limits and ScalabilityWhat is the data storage capacity limit for Azure Table Storage?Understanding Azure Table Storage's Capacity for Large Data VolumesIs Azure Table Storage capable of supporting data volumes up to several hundred TBs?Understanding Azure's Approach to Database Security and PermissionsHow does Azure address security for its databases?Understanding Business Intelligence: A Key Component for Data-Driven DecisionsWhat does Business Intelligence refer to?Understanding Consistent Prefix in Azure Data FundamentalsIn which scenario is Consistent Prefix applicable?Understanding Data: The Backbone of Informed Decision MakingHow is data generally defined?Understanding Descriptive Analytics and What It Focuses OnWhat do descriptive analytics specifically focus on?Understanding how Azure Synapse Analytics processes large amounts of dataAzure Synapse Analytics is designed to quickly process what type of data?Understanding How to Configure Azure SQL Database for Service AccessWhen configuring a SQL Database, what must be in place to allow Azure services to access it?Understanding Limitations of Azure Data ServicesWhat limitation is associated with Azure Data Services?Understanding Non-Relational Data: Key CharacteristicsHow can non-relational data be characterized?Understanding Page Blobs and Their High-Performance CapabilitiesWhich of the following blob types is optimized for random read and write operations?Understanding Power BI Apps and Their Impact on Data VisualizationWhat term in Power BI refers to a collection of visualizations prearranged in reports and dashboards?Understanding Range Queries in Azure Table StorageHow is a range query defined in Azure Table Storage?Understanding Row Insertion in Azure Table StorageWhich statement correctly describes the nature of row insertion in Azure Table Storage?Understanding Staleness in Bounded Staleness Consistency ModelsWhat does the term 'staleness' refer to in the context of Bounded Staleness consistency?Understanding the Azure RBAC Reader Role and Its ImportanceWhich role in Azure RBAC can view existing Azure resources but cannot modify them?Understanding the Benefits of Normalization in Database ManagementWhat does normalization achieve in database management?Understanding the Best Time to Use PolybaseWhen should you consider using Polybase?Understanding the Building Blocks of Power BIWhich of the following is NOT a building block of Power BI?Understanding the Common Flow for Generating Reports in Power BIWhat is the common flow of activity in Power BI for generating reports?Understanding the Concept of Eventual Consistency in DatabasesWhat is 'eventual consistency' in a database?Understanding the Consistency Spectrum in Azure Data ManagementWhich of the following describes the consistency spectrum from least to most consistent?Understanding the Continuous Nature of Streaming DataWhat is the primary characteristic of streaming data?Understanding the Core of Big Data in Modern Data WarehousingWhich term describes the volume, velocity, and variety of data in modern data warehousing?Understanding the Differences Between Azure Analysis Services and Azure Synapse AnalyticsHow does Azure Analysis Services differ from Azure Synapse Analytics?Understanding the Differences Between Reporting and Visualization in Data AnalysisHow do reporting and visualization differ?Understanding the Disadvantages of Using SQL Server in a Virtual Machine EnvironmentWhat is a disadvantage of SQL Server in a VM?Understanding the Essential Port for Connecting to Azure SQL DatabaseWhat port must be opened by your network's firewall to connect to Azure SQL Database?Understanding the Features of Page Blobs in AzureWhich of these best describes the characteristics of page blobs?Understanding the First Step in Creating a Table in Azure StorageWhat is the first step in creating an Azure Table Storage table?Understanding the High Availability Use Case for Azure SQL DatabaseWhat is a primary use case for Azure SQL Database?Understanding the Impact of Prescriptive Analytics on Business OutcomesWhich type of analytics suggests actions to improve business outcomes?Understanding the Importance of Data Transformation in Analytical SystemsWhich phase of an Analytical System is responsible for organizing and cleaning data?Understanding the Key Components of Azure Table StorageWhat constitutes a key in Azure Table Storage?Understanding the Key Differences Between Clustered and Regular Indexes in SQLWhat distinguishes a clustered index from a regular index?Understanding the Key Element of the ETL ProcessWhat is a primary characteristic of the ETL process?Understanding the Key Features of Azure File StorageWhat is a key feature of Azure File Storage?Understanding the Key Features of Non-Relational DatabasesWhat characterizes non-relational databases?Understanding the Key Principle of Network Security in Azure SQL DatabaseWhat is the overarching principle for network security in Azure SQL Database?Understanding the Key Stages of Data AnalyticsWhat are the two important stages of data analytics?Understanding the Major Drawbacks of Normalization in Database DesignWhat is a major drawback of normalization?Understanding the Minimum TLS Version for Azure Security ComplianceWhat minimum TLS version is required for Azure security compliance?Understanding the Nature of Unstructured Data and Its ImportanceWhat type of data includes audio and video files?Understanding the Role of Azure Data Services in the PaaS ModelWhich category do Azure data services primarily fall into?Understanding the Role of Data Models in Power BIIn Power BI, what does the term "data models" refer to?Understanding the Role of Elastic Pools in Azure SQL DatabaseWhat does an Elastic Pool in Azure SQL Database do?Understanding the Role of Provisioning in DatabasesWhat is provisioning in the context of databases?Understanding the Two Tiers of Azure File StorageHow many tiers are available in Azure File Storage?Understanding the Types of Data Processing Solutions: OLTP and OLAP ExplainedWhich are two types of data processing solutions?Understanding the vCore Range for Azure SQL DatabaseWhat is the range of vCores for Azure SQL Database?Understanding the Versatility of NoSQL DatabasesWhat are NoSQL databases primarily known for?Understanding the Workflow of Power BI: From Report Creation to SharingWhich of the following describes the common flow of Power BI?Understanding Tools for Provisioning Services in Azure: A Comprehensive GuideWhich of the following tools can be used to provision services in Azure?Understanding VLAN: The Basics of Virtual Local Area NetworksWhat does VLAN stand for in network terminology?Understanding When Cosmos DB Isn't the Best FitWhich scenario is Cosmos DB NOT particularly suitable for?Understanding When to Use Azure Analysis ServicesWhen is it advisable to use Azure Analysis Services?What Does Geo Redundant Storage Protect Against?Geo Redundant Storage (GRS) is designed to protect against what?What to Do After Creating a Resource in Azure Table StorageWhat must be done after creating a resource in Azure Table Storage?What You Need to Know About Block Blobs in AzureWhat is a typical use case for a block blob?What You Need to Know Before Creating Azure Table StorageBefore creating an Azure Table Storage, what needs to be set up first?What You Should Know About Azure Cosmos DBWhich of the following describes Azure Cosmos DB?When to Consider Azure Managed Instance for Your Database NeedsIn what situation should you consider using Azure Managed Instance?
More practice questions

These questions are part of the practice quiz. Start practicing

  • Which of the following describes a characteristic of Blob Storage?
  • What is the primary purpose of creating an index in a database?
  • What is Azure Table Storage?
  • What type of blobs can only have new blocks added to the end and not be updated?
  • Which node in Azure Synapse Analytics handles the computational workload?
  • What is considered the cheapest method for storing data in Azure?
  • What functionality does Polybase provide in Azure Synapse Analytics?
  • Which of the following is NOT one of Microsoft Azure's relational database options?
  • Which consistency level guarantees that all writes are visible only after successfully being confirmed to all replicas?
  • Can Azure Analysis Services and Synapse Analytics be combined?
  • What is the purpose of point queries in Azure Table Storage?
  • What do predictive analytics do?
  • Which relational database service offers 32GB to 8TB resources?
  • What does the change feed on a blob provide?
  • Which of the following options can be used to protect Azure resources like storage accounts and Azure Cosmos DB?
  • What is the retrieval speed of data in Azure Table Storage generally dependent on?
  • What is the role of a Security Principal in Azure RBAC?
  • Is a CSV file considered an example of unstructured data?
  • What best describes the data consistency model in Azure Table Storage?
  • Why can creating indexes lead to slower insert, update, or delete operations?
  • Which of the following best describes IaaS?
  • What type of representation is referred to as a visualization in Power BI?
  • What role does Analysis Services play in data processing when used with Synapse Analytics?
  • Which of the following describes relational data?
  • What is a common use case for Azure Table Storage?
  • What method can be used to automatically transition blobs from hot to archive tier?
  • What best describes SQL Managed Instance?
  • Which of the following is TRUE about columnar storage in NoSQL databases?
  • What are the two purchasing models supported by SQL Database?
  • Which of the following is the cheapest storage option available in Azure?
  • What capability does Azure Synapse Analytics provide concerning SQL tables?
  • What does eventual consistency imply?
  • When should Azure Synapse Analytics be used?
  • What do you call a read-only version of a blob at a specific point in time?
  • Which of the following elements is NOT part of an RBAC role?
  • Which term refers to the process of separating data into multiple related tables?
  • What is one of the pricing options for Azure SQL Database based on?
  • Which of the following is a characteristic of a report in Power BI?
  • What is primarily impacted by business analytics?
  • Which statement is true regarding Azure Cosmos DB's indexing feature?
  • Which option allows users to pay based on performance in Azure SQL Database?
  • Which of the following best describes data ingestion?
  • What makes Azure Table Storage advantageous for data storage?
  • What is the primary function of the Advanced Security configuration in Azure?
  • What best describes a Data Engineer's primary responsibility?
  • What is the appropriate term for the lag between writing and reading updated data in Azure?
  • What is a significant benefit of using Synapse for data processing?
  • Which formats are considered types of batch data?
  • What is the purpose of a Shared Access Signature (SAS) in Azure?
  • How is data organized in a relational database?
  • What type of data sources can Polybase retrieve data from?
  • What is the default access tier in Azure Blob Storage?
  • Which consistency option is not available when distributing data across multiple global regions?
  • If a SQL Database is set up with a "public endpoint" without further configuration, which type of user can connect to the database?
  • Which options are available when selecting Azure SQL Database?
  • Which type of analytics would be used to determine how to increase sales based on customer behavior?
  • What is a common use case for non-relational data?
  • Which consistency option in Cosmos DB is characterized by the lowest latency and least consistency?
  • Which storage replication option provides the least cost?
  • What is the primary purpose of a container in Azure?
  • What is a disadvantage of using Azure Table Storage?
  • What must be checked to allow other Azure services to access a SQL server?
  • What is one of the primary tasks performed by a Data Analyst?
  • What is a Managed Instance in Azure SQL Database?
  • Which access tier is intended for infrequently accessed data?
  • What does a database schema represent?
  • What types of access can be defined in Azure for your data?
  • What is a security principal in Azure?
  • Which of the following is NOT a benefit of normalization in databases?
  • Which component is NOT part of the basic structure of Business Intelligence?
  • What does configuring a firewall and virtual network do for Azure resources?
  • What is Azure HD Insight primarily designed for?
  • What is the definition of a dashboard in Power BI?
  • How does Azure Data Services typically incur costs?
  • Which scenario is the best use case for IaaS?
  • What is the availability of Azure Data Services?
  • What is a key benefit of using SQL Server in a VM?
  • What configuration must be done to allow access to a SQL database through a public endpoint?
  • What is a tile in Power BI?
  • What are cognitive analytics based on?
  • Which of the following refers to rules that determine who can access resources in a network?
  • Which option is NOT a type of non-relational database offered by Azure?
  • What happens to data visibility in the Session Consistency option?
  • Which type of consistency only makes writes visible to clients after they have been confirmed as written successfully to all replicas?
  • What best defines batch data?
  • What kind of architecture does Azure Synapse Analytics leverage?
  • Which statement best describes the purpose of data in decision making?
  • Which role is specifically associated with database administration in Azure?
  • What is a primary key in a relational database?
  • Which of the following describes Graph databases in NoSQL?
  • True or False: Data in Azure Data Lake can be historical or streamed from its source.
  • Which of the following describes Infrastructure as a Service (IaaS)?
  • Which of the following describes a dataset within Power BI?
  • What is the advantage of using multi-region replication with Azure Cosmos DB?
  • What is the role of the control node in Azure Synapse Analytics?
  • What is a characteristic of document databases?
  • If you want to keep earlier versions of a blob, what feature should you enable?
  • What type of data is best suited for use in an IoT application?
  • Which category does a key-value store fall into?
  • What feature allows the recovery of blobs that have been deleted or overwritten?
  • Which API is NOT supported by Azure Cosmos DB?
  • What components does Azure Synapse Analytics architecture consist of?
  • How many access tiers does Azure Blob Storage provide?
  • What best describes the change feed option in Azure Blob Storage Service?
  • What is the purpose of an App in Power BI?
  • What does semi-structured data include?
  • Which of the following is NOT a function of Azure Data Factory?
  • True or False: Azure Data Factory is an extension of Azure Blob storage that acts as a near-infinite file system.
  • In a relational database, what enforces data integrity?
  • What latency does Cosmos DB guarantee for reads and writes at the 99th percentile globally?
  • What type of data does a data lake primarily consist of?
  • How do you specify the programming language used in a cell within Azure Databricks?
  • What role in Azure RBAC has full access to resources?
  • Data processed by Azure Synapse Analytics is distributed how?
  • In a Spark pool, nodes are replaced with which of the following?
  • What is the maximum size of an Append Blob?
  • What does the ELT process stand for in data processing?
  • What is the primary task involved in Data Ingestion?
  • How does the Consistent Prefix consistency option behave during data change?
  • What does replication in Azure Storage Account ensure?
  • Before using AZCopy, what do you need to create?
  • Azure Data Lake Storage is best described as what type of storage?
  • What Azure service is specifically designed to implement the NoSQL key-value model?
  • Which of the following is considered a non-relational database option in Azure?
  • What is the primary benefit of using Cool Tier in Azure Blob Storage?
  • Which of the following would most likely NOT be considered streaming data?
  • What is the primary purpose of data ingestion?
  • How can a user get more control over their Azure database?
  • What does the process of sharing dashboards in Power BI typically involve?
  • What allows for read access in the secondary region while using Read-Access geo-redundant storage (RA-GRS)?
  • What does data visualization help you to do?
  • What is the main goal of diagnostic analytics?
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy