Ultimate Guide to Prepare DP-900 Certification Exam for Microsoft Certified: Azure Data Fundamentals in 2021
Use Real DP-900 Dumps - Microsoft Correct Answers updated on 2021
NEW QUESTION 32
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?
- A. an index
- B. a view
- C. a table
- D. a scalar function
Answer: B
Explanation:
Section: Describe core data concepts
Explanation:
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
NEW QUESTION 33
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 34
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
- A. stream processing
- B. batch processing
- C. Online Analytical Processing (OLAP)
- D. Online Transaction Processing (OLTP)
Answer: D
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing
NEW QUESTION 35
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:
NEW QUESTION 36
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. table
- C. blob
- D. file
Answer: C
NEW QUESTION 37
To complete the sentence select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 38
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.
Answer:
Explanation:
NEW QUESTION 39
Which Azure Data Factory component provides the compute environment for activities?
- A. a control flow
- B. an integration runtime
- C. a linked service
- D. a pipeline
Answer: B
Explanation:
Section: Describe an analytics workload on Azure
Explanation:
The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:
* Data Flow
* Data movement
* Activity dispatch
* SSIS package execution
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime
NEW QUESTION 40
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://mrpaulandrew.com/2019/09/25/azure-data-factory-pipeline-hierarchies-generation-control/
NEW QUESTION 41
Which storage solution supports access control lists (ACLs) at the file and folder level?
- A. Azure Data Lake Storage
- B. Azure Blob storage
- C. Azure Cosmos DB
- D. Azure Queue storage
Answer: A
NEW QUESTION 42
Which setting can only be configured during the creation of an Azure Cosmos DB account?
- A. API
- B. multi-region writes
- C. production or non-reduction account type
- D. geo-redundancy
Answer: C
NEW QUESTION 43
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
NEW QUESTION 44
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 be assigned the Contributor role for the resource group that contains the database.
- B. You must have SELECT access to the Products table.
- 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: C,D,E
Explanation:
Section: Describe how to work with relational data on Azure
NEW QUESTION 45
For each of the following statements, select yes if the statement is true, Otherwise, select No.
Note: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 46
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 47
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 48
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
- A. stream processing
- B. batch processing
- C. Online Analytical Processing (OLAP)
- D. Online Transaction Processing (OLTP)
Answer: D
Explanation:
Explanation
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
NEW QUESTION 49
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
- A. streaming
- B. batch
- C. massively parallel processing (MPP)
- D. Online Transaction Processing (OLTP)
Answer: A
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-in/azure/azure-monitor/overview
NEW QUESTION 50
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 HDinsight
- B. Azure Log Analytics
- C. Azure Databricks
- D. Azure Time Series Insights
Answer: A,B
NEW QUESTION 51
When you create an Azure SQL database, which account can always connect to the database ?
- A. the sa account
- B. the Azure Active Directly Azure AD) administrator account
- C. the server admin login account of the logical server
- D. the Azure Active director/ (Azure AO) account that created the database
Answer: B
NEW QUESTION 52
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 53
......
Microsoft Certified: Azure Data Fundamentals -DP-900 Exam-Practice-Dumps: https://www.validtorrent.com/DP-900-valid-exam-torrent.html
DP-900 Premium Files Test pdf - Free Dumps Collection: https://drive.google.com/open?id=1SICLjXfnFxff7iRYCcW_6tnWxRjFmDGX