DON'T WANT TO MISS A THING?

Certification Exam Passing Tips

Latest exam news and discount info

Curated and up-to-date by our experts

Yes, send me the newsletter

Boost Your Performance in the Microsoft DP-900 Exam with Practice Tests

SPOTO provides high-quality study materials that dive deep into crucial areas such as Azure data services, helping you build a strong foundation of knowledge. Their exam resources are designed to enhance your understanding and readiness for the DP-900 exam, increasing your chances of passing successfully. The advantages of SPOTO Microsoft DP-900 exam questions for the Microsoft Certified: Azure Data Fundamentals certification are immense. These exam questions cover essential topics related to Microsoft Azure data services, including core concepts, best practices, and use cases. With SPOTO's exam questions and answers, you gain access to comprehensive test questions that mirror the actual exam format, ensuring thorough preparation.Moreover, SPOTO offers mock exams that simulate the real exam environment, allowing you to practice effectively and improve your performance. Overall, SPOTO's Microsoft DP-900 exam preparation resources equip you with the skills and confidence needed to excel in your Azure Data Fundamentals certification journey.
Take other online exams
Question #1
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #2
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
A. rovides resiliency if an Azure region fails
B. upports partitioning
C. rovides a higher storage capacity
D. upports a multi-master model
View answer
Correct Answer: D
Question #3
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.
A. access to the latest features
B. complete control over backup and restore processes
C. in-database machine learning services
D. reduced administrative effort for managing the server infrastructure
View answer
Correct Answer: AD
Question #4
You need to design and model a database by using a graphical tool that supports project-oriented offline database development.What should you use?
A. icrosoft SQL Server Data Tools (SSDT)
B. icrosoft SQL Server Management Studio (SSMS)
C. zure Databricks
D. zure Data Studio
View answer
Correct Answer: A
Question #5
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #6
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #7
You have an application that runs on Windows and requires access to a mapped drive.Which Azure service should you use?
A. zure Files
B. zure Blob storage
C. zure Cosmos DB
D. zure Table storage
View answer
Correct Answer: A
Question #8
You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?
A. ou need to generate reports without affecting the transactional workload
B. ou need to audit the transactional application
C. ou need to implement high availability in the event of a regional outage
D. ou need to improve the recovery point objective (RPO)
View answer
Correct Answer: A
Question #9
Which statement is an example of Data Definition Language (DDL)?
A. ELECT
B. NSERT
C. ELETE
D. ROP
View answer
Correct Answer: D
Question #10
You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you use?
A. zure Cosmos DB
B. zure Table storage
C. zure Files
D. zure Blob Storage
View answer
Correct Answer: A
Question #11
DRAG DROP (Drag and Drop is not supported)Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth o
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #12
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #13
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #14
What are two uses of data visualization? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
A. zure Functions
B. icrosoft SQL Server Integration Services (SSIS)
C. olyBase
D. zure Data Factory
View answer
Correct Answer: AC
Question #15
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?
A. ervice principal authentication
B. zure Active Directory (Azure AD) authentication
C. QL authentication
D. ertificate authentication
View answer
Correct Answer: B
Question #16
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #17
You need to store data by using Azure Table storage.What should you create first?
A. n Azure Cosmos DB instance
B. storage account
C. blob container
D. table
View answer
Correct Answer: B
Question #18
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #19
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #20
DRAG DROP (Drag and Drop is not supported)Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth o
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #21
DRAG DROP (Drag and Drop is not supported)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 right. Each component may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.Select and Place:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #22
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #23
Your company is designing a data store for internet-connected temperature sensors.The collected data will be used to analyze temperature trends.Which type of data store should you use?
A. elational
B. ime series
C. raph
D. olumnar
View answer
Correct Answer: B
Question #24
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. UPDATE
D. CREATE
View answer
Correct Answer: D
Question #25
When can you use an Azure Resource Manager template?
A. o automate the creation of an interdependent group of Azure resources in a repeatable way
B. o apply Azure policies for multi-tenant deployments
C. o provision Azure subscriptions
D. o control which services and feature administrators and developers can deploy from the Azure portal
View answer
Correct Answer: A
Question #26
You have a transactional application that stores data in an Azure SQL managed instance.When should you implement a read-only database replica?
A. ou need to generate reports without affecting the transactional workload
B. ou need to audit the transactional application
C. ou need to implement high availability in the event of a regional outage
D. ou need to improve the recovery point objective (RPO)
View answer
Correct Answer: A
Question #27
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?
A. ocument
B. olumnar
C. raph
D. ime series
View answer
Correct Answer: A
Question #28
When can you use an Azure Resource Manager template?
A. to automate the creation of an interdependent group of Azure resources in a repeatable way
B. to apply Azure policies for multi-tenant deployments
C. to provision Azure subscriptions
D. to control which services and feature administrators and developers can deploy from the Azure portal
View answer
Correct Answer: A
Question #29
What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.
A. ee Explanation section for answer
View answer
Correct Answer: BD
Question #30
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #31
You need to query a table named Products in an Azure SQL database.Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
A. ET
B. ALUES
C. EY
D. OIN
View answer
Correct Answer: BCE
Question #32
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #33
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #34
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. tomicity
B. solation
C. urability
D. onsistency
View answer
Correct Answer: A
Question #35
You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?
A. zure Cosmos
B. zure Table storage
C. zure Files
D. zure Blob storage
View answer
Correct Answer: A
Question #36
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 possible during idle times. The solution must ensure that the data remains intact.What should you do on the dedicated SQL pool?
A. cale down the data warehouse units (DWUs)
B. ause the pool
C. reate a user-defined restore point
D. elete the pool
View answer
Correct Answer: B
Question #37
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:
A. view
B. report
C. dataflow
D. icrosoft Power Apps
View answer
Correct Answer: A
Question #38
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #39
Which storage solution supports role-based access control (RBAC) at the file and folder level?
A. zure Disk Storage
B. zure Data Lake Storage
C. zure Blob storage
D. zure Queue storage
View answer
Correct Answer: B
Question #40
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #41
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #42
DRAG DROP (Drag and Drop is not supported)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 its question on the right. Each analytics type may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #43
Select the answer that correctly completes the sentence.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #44
Which statement is an example of Data Manipulation Language (DML)?
A. EVOKE
B. ISABLE
C. REATE
D. PDATE
View answer
Correct Answer: D
Question #45
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #46
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #47
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
A. ulti-master replication
B. vailability Zones
C. he strong consistency level
D. utomatic failover
View answer
Correct Answer: B
Question #48
DRAG DROP (Drag and Drop is not supported)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 may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.Select and Place:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #49
DRAG DROP (Drag and Drop is not supported)Match the types of workloads to the appropriate scenarios.To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #50
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #51
You have an e-commerce application that reads and writes data to an Azure SQL database.Which type of processing does the application use?
A. tream processing
B. atch processing
C. nline Analytical Processing (OLAP)
D. nline Transaction Processing (OLTP)
View answer
Correct Answer: D
Question #52
DRAG DROP (Drag and Drop is not supported)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 its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.Select and Place:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #53
Which statement is an example of Data Manipulation Language (DML)?
A. EVOKE
B. ISABLE
C. NSERT
D. RANT
View answer
Correct Answer: C
Question #54
What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE. Each correct selection is worth one point.
A. ormalized data
B. chema defined in a database
C. chema defined when reading unstructured data from a database
D. ormalized data
E. ight writes and heavy reads
View answer
Correct Answer: ACF
Question #55
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).Which Azure service should you use to support the application?
A. Azure Cosmos DB
B. Azure HDInsight
C. Azure SQL Database
D. Azure Synapse Analytics
View answer
Correct Answer: C
Question #56
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #57
Which storage solution supports access control lists (ACLs) at the file and folder level?
A. zure Data Lake Storage
B. zure Cosmos DB
C. zure Queue storage
D. zure Blob storage
View answer
Correct Answer: A
Question #58
What is a characteristic of batch processing?
A. he data ingested during batch processing must be processed as soon as the data is received
B. arge datasets must be split into batches of less than 1 GB before the data can be processed
C. here is a noticeable time delay between ingesting data and obtaining the data processing results
D. atch processing can only process data that is structured
View answer
Correct Answer: D
Question #59
You need to create an Azure resource to store data in Azure Table storage. Which command should you run?
A. ee Explanation section for answer
View answer
Correct Answer: D
Question #60
HOTSPOT (Drag and Drop is not supported)You have the following JSON document. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.NOTE: Each correct selection is worth one point.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #61
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #62
DRAG DROP (Drag and Drop is not supported)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 its question on the right. Each analytics type may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #63
Which Azure Data Factory component initiates the execution of a pipeline?
A. control flow
B. trigger
C. parameter
D. n activity
View answer
Correct Answer: B
Question #64
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #65
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.NOTE: Each correct selection is worth one point.
A. raph
B. ey/value
C. bject
D. olumnar
View answer
Correct Answer: AC
Question #66
You have data saved in the following format.Which format was used?
A. AML
B. TML
C. ML
D. SON
View answer
Correct Answer: B
Question #67
Which type of database is Azure Database for PostgreSQL?
A. latform as a service (PaaS)
B. nfrastructure as a service (laaS)
C. icrosoft SQL Server
D. n-premises
View answer
Correct Answer: A
Question #68
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #69
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #70
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #71
DRAG DROP (Drag and Drop is not supported)Match the Azure SQL services to the appropriate use cases.To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.NOTE: Each correct match its worth one point.Select and Place:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #72
HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #73
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #74
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A
Question #75
Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit.Which type of analysis is shown for the fourth quarter?
A. redictive
B. rescription
C. escriptive
D. iagnostic
View answer
Correct Answer: A
Question #76
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
A. uilt-in high availability
B. ative support for cross-database queries and transactions
C. ystem-initiated automatic backups
D. upport for encryption at rest
View answer
Correct Answer: B
Question #77
You need to modify a view in a relational database by adding a new column. Which statement should you use?
A. ERGE
B. LTER
C. NSERT
D. PDATE
View answer
Correct Answer: B
Question #78
HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
A. ee Explanation section for answer
View answer
Correct Answer: A

View Answers after Submission

Please submit your email and WhatsApp to get the answers of questions.

Note: Please make sure your email ID and Whatsapp are valid so that you can get the correct exam results.

Email:
Whatsapp/phone number:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.