Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
DP-900
Free trial
Verified
Question 26
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question 27
You need to store data by using Azure Table storage.
What should you create first?
- A: an Azure Cosmos DB instance
- B: a storage account
- C: a blob container
- D: a table
Question 28
You need to recommend a data store service that meets the following requirements:
✑ Native SQL API access
✑ Configurable indexes
What should you recommend?
- A: Azure Files
- B: Azure Blob storage
- C: Azure Table storage
- D: Azure Cosmos DB
Question 29
HOTSPOT -
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:
Question 30
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question 31
Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.
Which type of data store should you use?
- A: graph
- B: key/value
- C: document
- D: columnar
Question 32
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?
- A: queue
- B: blob
- C: file
- D: table
Question 33
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 shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?
- A: key/value
- B: graph
- C: columnar
- D: document
Question 34
DRAG DROP -
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 one point.
Select and Place:
Question 35
You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?
- A: Azure Files
- B: Azure Blob storage
- C: Azure Cosmos DB
- D: Azure Table storage
Question 36
HOTSPOT -
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:
Question 37
Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?
- A: columnar
- B: key/value
- C: document
- D: graph
Question 38
You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?
- A: key/value
- B: columnar
- C: object
- D: document
Question 39
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: relational
- B: time series
- C: graph
- D: columnar
Question 40
HOTSPOT -
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:
Question 41
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question 42
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A: database
- B: item
- C: container
- D: partition
Question 43
HOTSPOT -
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:
Question 44
What is a characteristic of non-relational data?
- A: no indexes
- B: self-describing entities
- C: a well-defined schema
- D: no unique key values
Question 45
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question 46
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question 47
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
- A: Online Transaction Processing (OLTP)
- B: batch
- C: massively parallel processing (MPP)
- D: streaming
Question 48
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: Scale down the data warehouse units (DWUs).
- B: Pause the pool.
- C: Create a user-defined restore point.
- D: Delete the pool
Question 49
Which Azure Data Factory component initiates the execution of a pipeline?
- A: a control flow
- B: a trigger
- C: a parameter
- D: an activity
Question 50
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 use?
- A: stream processing
- B: batch processing
- C: Online Analytical Processing (OLAP)
- D: Online Transaction Processing (OLTP)
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!