It is more faster and easier to pass the Microsoft DP-900 exam by using Printable Microsoft Microsoft Azure Data Fundamentals questuins and answers. Immediate access to the Improve DP-900 Exam and find the same core area DP-900 questions with professionally verified answers, then PASS your exam with a high score now.
Online DP-900 free questions and answers of New Version:
NEW QUESTION 1
Select the answer that correctly completes the sentence.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 2
To complete the sentence, select the appropriate option in the answer area.
Solution:
Note: The data warehouse workload encompasses:
The entire process of loading data into the warehouse
Performing data warehouse analysis and reporting
Managing data in the data warehouse
Exporting data from the data warehouseDoes this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 3
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
- A. multi-master replication
- B. Availability Zones
- C. automatic failover
- D. the strong consistency level
Answer: B
Explanation:
With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given region to provide high availability and resiliency to zonal failures.
Note: Azure Cosmos DB provides high availability in two primary ways. First, Azure Cosmos DB replicates data across regions configured within a Cosmos account. Second, Azure Cosmos DB maintains 4 replicas of data within a region.
NEW QUESTION 4
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
Answer: B
Explanation:
First create an Azure storage account, then use Table service in the Azure portal to create a table.
Note: An Azure storage account contains all of your Azure Storage data objects: blobs, files, queues, and tables.
NEW QUESTION 5
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 automate the creation of an interdependent and develop can deploy from the Azure portal
- C. To provision Azure subscriptions and apply policies for multi-tenant deployments
- D. To set complex permissions automatically on existing objects in an Azure subscription
Answer: A
Explanation:
You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed
To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.
NEW QUESTION 6
What should you use to automatically delete blobs from Azure Blob Storage?
- A. soft delete
- B. archive storage
- C. the change feed
- D. a lifecycle management policy
Answer: D
NEW QUESTION 7
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
Answer: A
NEW QUESTION 8
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
Answer: C
Explanation:
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.
NEW QUESTION 9
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Solution:
Box 1: Yes
Like IaaS, PaaS includes infrastructure – servers, storage, and networking – but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources
Box 2: Yes
You manage the applications and services you develop, and the cloud service provider typically manages everything else.

Box 3: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."
Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 10
A bar chart showing year-to date sales by region is an example of which type of analytics?
- A. descriptive
- B. diagnostic
- C. predictive
- D. prescriptive
Answer: B
NEW QUESTION 11
Select the answer that correctly completes the sentence.
Solution:

Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 12
You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?
- A. You need to generate reports without affecting the transactional workload.
- B. You need to audit the transactional application.
- C. You need to implement high availability in the event of a regional outage
- D. You need to improve the recovery point objective (RPO).
Answer: A
Explanation:
Use read-only replicas to offload read-only query workloads.
NEW QUESTION 13
You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, 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. document
- B. key/value
- C. object
- D. columnar
Answer: C
Explanation:
Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.
NEW QUESTION 14
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
Answer: D
Explanation:
You must create a separate account for each API.
NEW QUESTION 15
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
Answer: D
Explanation:
Azure Cosmos DB comes with native Core (SQL) API support.
In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy.
NEW QUESTION 16
To complete the sentence, select the appropriate option in the answer area.
Solution:
Generally speaking, data analytics comes in four types (Figure 1): Descriptive, to answer the question: What’s happening? Diagnostic, to answer the question: Why’s happening? Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
Does this meet the goal?
- A. Yes
- B. Not Mastered
Answer: A
NEW QUESTION 17
......
P.S. Easily pass DP-900 Exam with 306 Q&As Certleader Dumps & pdf Version, Welcome to Download the Newest Certleader DP-900 Dumps: https://www.certleader.com/DP-900-dumps.html (306 New Questions)