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

Online Microsoft DP-900 Mock Tests & Study Materials, Microsoft Azure Data Fundamentals | SPOTO

Dive into a range of essential tools including practice tests, free tests, exam practice, online exam questions, exam questions, sample questions, exam dumps, exam questions and answers, mock exams, and exam materials. Our latest practice tests are expertly crafted to enhance your chances of passing the certification exam with flying colors. This exam presents a valuable opportunity to showcase your understanding of core data concepts and related Microsoft Azure data services. Candidates preparing for this exam should be well-acquainted with DP-900's self-paced or instructor-led learning material. Tailored for individuals venturing into data work in the cloud, this exam marks the initial step towards mastering Azure data fundamentals. Arm yourself for success and excel in your certification journey with our comprehensive resources readily available for your benefit.
Take other online exams
Question #1
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.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #2
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?
A. Azure SQL Database Hyperscale
B. Azure SQL managed instance
C. Azure SQL Database serveless
D. Azure SQL Database elastic pod
View answer
Correct Answer: B
Question #3
Match the Azure services to appropriate requirements. To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all. NOTE: Each correct match is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #4
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. (Choose two.) NOTE: Each correct selection is worth one point.
A. the throughput
B. the read region
C. the partition key
D. the API
View answer
Correct Answer: A
Question #5
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. stream processing
B. batch processing
C. Online Analytical Processing (OLTP)
D. Online Transaction Processing (OLTP)
View answer
Correct Answer: AC
Question #6
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. predictive
B. prescription
C. descriptive
D. diagnostic
View answer
Correct Answer: A
Question #7
Which setting can only be configured during the creation of an Azure Cosmos DB account?
A. geo-redundancy
B. multi-region writes
C. production or non-reduction account type
D. API
View answer
Correct Answer: C
Question #8
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?
A. graph
B. key/value
C. object
D. columnar
View answer
Correct Answer: A
Question #9
Which Azure Data Factory component provides the compute environment for activities?
A. a linked service
B. an integration runtime
C. a control flow
D. a pipeline
View answer
Correct Answer: A
Question #10
You have the following SQL query. NOTE: Each correct selection is worth one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: D
Question #11
You have a table named Sales that contains the following data. You need to query the table to return the average sales amount day. The output must produce the following results. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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 one point.
A. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #12
Which scenario is an example of a streaming workload?
A. sending transactions that are older than a month to an archive
B. sending transactions daily from point of sale (POS) devices
C. sending telemetry data from edge devices
D. sending cloud infrastructure metadata every 30 minutes
View answer
Correct Answer: A
Question #13
Match the types of workloads the appropriate scenario. 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. Mastered
B. Not Mastered
View answer
Correct Answer: A
Question #14
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. document
B. columnar
C. graph
D. time series
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.