DP-900 Exam Questions

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

The visualizations on the Power BI dashboard are known as

Which of the following are the characteristics of real-time data processing? (Select 2 Options)

Read the statement - "In relational databases, all the values in a column will have the same data type." Choose the correct option with respect to the given statement.

An organization has been using a bar chart to present the year-wise sales of a region to track the status of sales year by year. How would you recognize the analytics here?

You are working in an organization and your client wants to migrate all of his SQL workloads to the Azure such that complete SQL Server compatibility and operating system-level acc...

Fill in the blank: A database index allows a query to __________ data efficiently from a database.

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth...

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Ch...

Your company is designing a data store that will contain student data. The data has the following format. Which type of data store should you use?

Which storage solution supports role-based access control (RBAC) at the file and folder level?

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimi...

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?

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?

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a...

Which scenario is an example of a streaming workload?

You work as a Data Associate in a cloud provider company and Data Scientist asks you for a suggestion on which cloud service a client should be used if he wants to get a fully mana...

Which of the following is not a feature of the Azure Database for MariaDB?

Fill in the blank: The __________ contains trusted Fabric Controllers and supporting systems.

Which of the following is used to create and modify the structure of database objects?

Which of the following is a unique identifier for the document, often hashed for the even distribution of data, and helps in the retrieval of data from the document in the document...

You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario?

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the dedicated SQL pool as much as...

Which Azure Data Factory component initiates the execution of a pipeline?

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution us...

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection i...

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection...

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support d...

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one p...

You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one poin...

You have a file system where text files have been stored. The primary index of a file is the file path but you want to perform a search based on the contents of the file. Which of...

Consider the JSON document for your cosmetics e-commerce website: What will be the SQL command to retrieve the product name from the given document?

The objects in Blob storage can not be accessed via

You are working as a Data Associate in an organization. Your client has accomplished the tasks with his Azure CosmoDB account and wants to delete it. He does not know about the ste...

Which of the following is not a checkpoint in the checklist for troubleshooting issues when you are working with Azure Cosmos DB .NET SDK?

Which Azure Data Factory component provides the compute environment for activities?

You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse. What should you use to query the files?

Drag and Drop Question Match the types of analytics that can be used to answer the business questions. To answer, drag the appropriate analytics type from the column on the left to...

Drag and Drop Question Match the terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term...

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one poin...

Drag and Drop Question Match the security components to the appropriate scenarios. To answer, drag the appropriate component from the column on the left to its scenario on the righ...

Drag and Drop Question Match the types of data stores to the appropriate scenarios. To answer, drag the appropriate data store type from the column on the left to its scenario on t...

Drag and Drop Question Match the Azure Cosmos DB APIs to the appropriate data structures. To answer, drag the appropriate API from the column on the left to its data structure on t...

Drag and Drop Question Match the types of activities to the appropriate Azure Data Factory activities. To answer, drag the appropriate activity type from the column on the left to...

You are using an e-commerce application that reads and writes data to an Azure SQL database. Which processing is this application using?

Complete the Sentence: The MPP (Massively Parallel Processing) Engine of Azure Synapse Analytics