Are you looking for the latest valid DP-900 dumps questions? You can choose Lead4Pass’ DP-900 dumps questions, which provide 176 exam practice questions and answers online to help you solve all your Microsoft Azure Data Fundamentals exam questions.
Lead4Pass DP-900 Dumps Questions is the best solution for you to prepare for the Microsoft Azure Data Fundamentals exam. Verified by professional IT certified workers and verified by industry experts, authentic and effective.
Now, before you prepare for the DP-900 Microsoft Azure Data Fundamentals exam, start using the DP-900 dumps material: https://www.leads4pass.com/dp-900.html. Help you with your worries.
Microsoft DP-900 free dumps as verification before your selection
Question 1:
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
Correct Answer: B
Question 2:
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
Correct Answer: B
Question 3:
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)
Correct Answer: D
Question 4:
What are two characteristics of real-time data processing? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Data is processed as it is created.
B. Low latency is expected
C. High latency acceptable
D. Data is processed periodically
Correct Answer: BD
Question 5:
Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Azure Databricks
B. Azure Log Analytics
C. Azure Time Series Insights
D. Azure HDinsight
Correct Answer: AD
Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/
Question 6:
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down. What should you use in Microsoft Power BI?
A. a dashboard
B. Microsoft Power Apps
C. a dataflow
D. a report
Correct Answer: D
Reference: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Question 7:
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
A. Azure Queue storage
B. Azure Data Lake Storage
C. Azure table storage
D. Azure Files
Correct Answer: C
Question 8:
You have a transactional application that stems 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).
Correct Answer: A
Use read-only replicas to offload read-only query workloads.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out
Question 9:
You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you use?
A. Azure Cosmos DB
B. Azure Table storage
C. Azure Files
D. Azure Blob Storage
Correct Answer: A
Question 10:
Your company needs to design a database that shows how changes in traffic in one area of a network affect other components of the network. Which type of data store should you use?
A. Key/value
B. Graph
C. Document
D. columnar
Correct Answer: B
Question 11:
You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically. Which two types of the replica can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one pint.
A. read-access geo-redundant storage (RA_GRS)
B. zone-redundant storage (ZRS)
C. geo-redundant storage (GRS)
D. locally-redundant storage (LRS)
Correct Answer: AC
Azure Storage offers two options for copying your data to a secondary region:
Geo-redundant storage (GRS)
Geo-zone-redundant storage (GZRS)
With GRS or GZRS, the data in the secondary region isn\’t available for reading or write access unless there is a failover to the secondary region.
For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone- redundant storage (RA-GZRS).
Reference:
Question 12:
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
Correct Answer: A
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. Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview
Question 13:
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. key/value
B. document
C. graph
D. columnar
Correct Answer: A
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
Question 14:
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. container
B. item
C. database
D. partition
Correct Answer: AC
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/set-throughput
Question 15:
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. columnar
C. graph
D. time series
Correct 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 the total data size can grow rapidly.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
……
Get the latest valid DP-900 dumps: https://www.leads4pass.com/dp-900.html. Really tackle the Microsoft Azure Data Fundamentals exam, helping you add a new skill and career option.
