Microsoft Azure Data Fundamentals DP-900 Exam Practice Test

Page: 1 / 14
Total 306 questions
Question 1

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?



Answer : B


Question 2

What can you use to create data ingestion pipelines?



Answer : C


Question 3

When you create an Azure SQL database, which account can always connect to the database ?



Answer : D

When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.


https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Question 4

Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?



Answer : D

Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.


https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Question 5

Question: 298

You have data in a tabular format as shown in the following table.

Of which type of data is this an example?



Answer : D


Question 6

You need to gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?



Answer : D


https://docs.microsoft.com/en-in/azure/azure-monitor/overview

Question 7

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.



Answer : B, C

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.


https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Page:    1 / 14   
Total 306 questions