DP-900 Free Certification Exam Material from Test4Cram with 143 Questions
Use Real DP-900 - 100% Cover Real Exam Questions
NEW QUESTION 21
Which statement is an example of Data Manipulation Language (DML)?
- A. GRANT
- B. REVOKE
- C. DISABLE
- D. INSERT
Answer: D
Explanation:
Section: Describe core data concepts
Explanation:
Data Manipulation Language (DML) statements:
* DELETE
* INSERT
* UPDATE
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference- tsql-statements
NEW QUESTION 22
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 23
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation-activities
NEW QUESTION 24
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. in-database machine learning services
- C. complete control over backup and restore processes
- D. reduced administrative effort for managing the server infrastructure
Answer: A,D
Explanation:
Explanation
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
NEW QUESTION 25
Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network.
Which type of data store should you use?
- A. key/value
- B. columnar
- C. graph
- D. document
Answer: C
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation:
Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.
A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB's Gremlin API supports the property graph model.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases
NEW QUESTION 26
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.
- A. a report page
- B. a dataflow
- C. a text box
- D. a Microsoft PowerPoint slide
- E. a visualization from a report
Answer: A,C,E
NEW QUESTION 27
You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically.
Which two types of replica can you us 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. geo-redundant storage (GRS)
- C. locally-redundant storage (LRS)
- D. zone-redundant storage (ZRS)
Answer: A,B
NEW QUESTION 28
Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?
- A. columnar
- B. relational
- C. graph
- D. time series
Answer: D
Explanation:
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 total data size can grow rapidly.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
NEW QUESTION 29
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share
NEW QUESTION 30
Your company if 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. columnar
- C. graph
- D. document
Answer: A
Explanation:
A key/value store associates each data value with a unique key.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
NEW QUESTION 31
Your company is designing a data store that will contain student dat
a. The data has the following format.
Which type of data store should you use?
- A. key/value
- B. graph
- C. columnar
- D. object
Answer: C
NEW QUESTION 32
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. partition
- B. database
- C. container
- D. item
Answer: B,C
NEW QUESTION 33
Which storage solution supports role-based access control (RBAC) at the file and folder level?
- A. Azure Disk Storage
- B. Azure Data Lake Storage
- C. Azure Blob storage
- D. Azure Queue storage
Answer: B
NEW QUESTION 34
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 35
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. (Choose three.) NOTE: Each correct selection is worth one point.
- A. You must have SELECT access to the Products table.
- B. You must be assigned the Contributor role for the resource group that contains the database.
- C. You must be assigned the Reader role for the resource group that contains the database.
- D. Your IP address must be allowed to connect to the database.
- E. You must have a user in the database.
Answer: A,D,E
Explanation:
Explanation
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-data
NEW QUESTION 36
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?
- A. Graph
- B. columnar
- C. Document
- D. Key/value
Answer: A
Explanation:
Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.
A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB's Gremlin API supports the property graph model.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases
NEW QUESTION 37
......
Dumps Brief Outline Of The DP-900 Exam: https://www.test4cram.com/DP-900_real-exam-dumps.html
DP-900 Training & Certification Get Latest Microsoft Certified: Azure Data Fundamentals : https://drive.google.com/open?id=1zo-nnhSQ8I1cUL4BBtRJHiuTQXK9JiBH