Home/Directory/dp 900

dp 900 Practice Questions

Page 1 of 1 (25 total questions)

Which data format uses key-value pairs to represent semi-structured data and is heavily used in web APIs and document databases?
View Question & Answer ➔
Your company is migrating data to Azure. Which data role is primarily responsible for securing the database, managing backups, and tuning performance for relational data systems?
View Question & Answer ➔
Which data role focuses on transforming raw data into meaningful business insights by creating reports and dashboards using tools like Power BI?
View Question & Answer ➔
A retail application processes hundreds of thousands of small, rapid customer transactions (purchases, updates) every minute. What type of workload does this describe?
View Question & Answer ➔
You need to run complex queries that aggregate sales data across the last five years to find yearly trends. This operation is highly resource-intensive and reads millions of rows. Which type of workload is this?
View Question & Answer ➔
In a relational database, what is used to enforce a relationship between two tables, ensuring that a value in one table corresponds to a valid row in another table?
View Question & Answer ➔
You are writing a query in SQL. Which of the following commands is considered a Data Manipulation Language (DML) statement?
View Question & Answer ➔
Your company wants to lift-and-shift an existing on-premises SQL Server to Azure. You require full control over the operating system, SQL Server instance configuration, and SQL Server Agent. Which deployment option should you choose?
View Question & Answer ➔
You want a fully managed relational database service in Azure that automatically handles patching, backups, and high availability. You do not need instance-level features like SQL Server Agent. Which service is the best fit?
View Question & Answer ➔
Which Azure service provides a globally distributed, multi-model database that supports NoSQL, enables single-digit millisecond response times, and guarantees 99.999% availability?
View Question & Answer ➔
You are migrating an existing application that uses MongoDB to Azure. You want to use a fully managed service without rewriting the application's data access code. Which service/API should you use?
View Question & Answer ➔
You need to store petabytes of unstructured video and audio files. There is no need to query this data via SQL; it just needs to be stored cost-effectively. Which service should you use?
View Question & Answer ➔
You are building an analytics solution and need a highly scalable data lake that supports a hierarchical directory namespace (like a traditional file system). Which storage option should you choose?
View Question & Answer ➔
In a modern data warehousing process, data is extracted from source systems, loaded directly into the data warehouse, and then transformed using the massive compute power of the data warehouse itself. What is this process called?
View Question & Answer ➔
Which Azure service is a cloud-based data integration service that allows you to create data-driven workflows for orchestrating and automating data movement and data transformation?
View Question & Answer ➔
Your organization wants an enterprise analytics service that brings together data integration, enterprise data warehousing, and big data analytics into a single workspace. Which service provides this unified experience?
View Question & Answer ➔
Which data processing method involves collecting a large volume of data over a period of time and then processing all the data simultaneously in one large job?
View Question & Answer ➔
A manufacturing company has sensors on its machines that constantly transmit temperature and vibration data every second. They need to analyze this data instantly to detect anomalies and trigger immediate alerts. Which processing method is required?
View Question & Answer ➔
What is the primary purpose of Microsoft Power BI?
View Question & Answer ➔
Which feature of Azure SQL Database helps protect data 'at rest' by automatically encrypting the database files, backups, and transaction logs on physical storage?
View Question & Answer ➔
You are using Azure Table Storage. What type of NoSQL database model does this service represent?
View Question & Answer ➔
Which API in Azure Cosmos DB allows you to define relationships between data entities as nodes and edges, making it ideal for social networks or recommendation engines?
View Question & Answer ➔
What is the process of structuring a relational database to reduce data redundancy and improve data integrity by dividing large tables into smaller tables and defining relationships between them?
View Question & Answer ➔
You need to process massive amounts of Big Data using Apache Spark. You prefer a fully managed, collaborative environment where data engineers and data scientists can work together in interactive notebooks. Which Azure service is designed for this?
View Question & Answer ➔
In Power BI, what is the term for a single-page canvas that tells a story through a collection of visual tiles pinned from different reports?
View Question & Answer ➔

Page 1 of 1

dp 900 Practice Questions

Which data format uses key-value pairs to represent semi-structured data and is heavily used in web APIs and document databases?

Your company is migrating data to Azure. Which data role is primarily responsible for securing the database, managing backups, and tuning performance for relational data systems?

Which data role focuses on transforming raw data into meaningful business insights by creating reports and dashboards using tools like Power BI?

A retail application processes hundreds of thousands of small, rapid customer transactions (purchases, updates) every minute. What type of workload does this describe?

You need to run complex queries that aggregate sales data across the last five years to find yearly trends. This operation is highly resource-intensive and reads millions of rows. Which type of workload is this?

In a relational database, what is used to enforce a relationship between two tables, ensuring that a value in one table corresponds to a valid row in another table?

You are writing a query in SQL. Which of the following commands is considered a Data Manipulation Language (DML) statement?

Your company wants to lift-and-shift an existing on-premises SQL Server to Azure. You require full control over the operating system, SQL Server instance configuration, and SQL Server Agent. Which deployment option should you choose?

You want a fully managed relational database service in Azure that automatically handles patching, backups, and high availability. You do not need instance-level features like SQL Server Agent. Which service is the best fit?

Which Azure service provides a globally distributed, multi-model database that supports NoSQL, enables single-digit millisecond response times, and guarantees 99.999% availability?

You are migrating an existing application that uses MongoDB to Azure. You want to use a fully managed service without rewriting the application's data access code. Which service/API should you use?

You need to store petabytes of unstructured video and audio files. There is no need to query this data via SQL; it just needs to be stored cost-effectively. Which service should you use?

You are building an analytics solution and need a highly scalable data lake that supports a hierarchical directory namespace (like a traditional file system). Which storage option should you choose?

In a modern data warehousing process, data is extracted from source systems, loaded directly into the data warehouse, and then transformed using the massive compute power of the data warehouse itself. What is this process called?

Which Azure service is a cloud-based data integration service that allows you to create data-driven workflows for orchestrating and automating data movement and data transformation?

Your organization wants an enterprise analytics service that brings together data integration, enterprise data warehousing, and big data analytics into a single workspace. Which service provides this unified experience?

Which data processing method involves collecting a large volume of data over a period of time and then processing all the data simultaneously in one large job?

A manufacturing company has sensors on its machines that constantly transmit temperature and vibration data every second. They need to analyze this data instantly to detect anomalies and trigger immediate alerts. Which processing method is required?

What is the primary purpose of Microsoft Power BI?

Which feature of Azure SQL Database helps protect data 'at rest' by automatically encrypting the database files, backups, and transaction logs on physical storage?

You are using Azure Table Storage. What type of NoSQL database model does this service represent?

Which API in Azure Cosmos DB allows you to define relationships between data entities as nodes and edges, making it ideal for social networks or recommendation engines?

What is the process of structuring a relational database to reduce data redundancy and improve data integrity by dividing large tables into smaller tables and defining relationships between them?

You need to process massive amounts of Big Data using Apache Spark. You prefer a fully managed, collaborative environment where data engineers and data scientists can work together in interactive notebooks. Which Azure service is designed for this?

In Power BI, what is the term for a single-page canvas that tells a story through a collection of visual tiles pinned from different reports?