DP-900 Practice Exam Tests Latest Updated on Aug-2021
Pass DP-900 Exam in First Attempt Guaranteed Dumps!
NEW QUESTION 53
Match the types of workloads to the appropriate scenarios.
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 54
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://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview
https://azure.microsoft.com/en-us/pricing/details/bandwidth/
NEW QUESTION 55
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 56
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Answer:
Explanation:
NEW QUESTION 57
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
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget
NEW QUESTION 58
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:
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 59
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount day. The output must produce the following results.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql
NEW QUESTION 60
When you create an Azure SQL database, which account can always connect to the database?
- A. the Azure Active Directory (Azure AD) account that created the database
- B. the sa account
- C. the Azure Active Directory (Azure AD) administrator account
- D. the server admin login account of the logical server
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart
NEW QUESTION 61
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
NEW QUESTION 62
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 63
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. diagnostic
- C. prescription
- D. descriptive
Answer: C
NEW QUESTION 64
You have a transactional application that stem data in an Azure SQ1 managed instance. When should you implement a read-only database replica?
- A. You need to improve the recovery point objective (RPO).
- B. You need to implement high availability in the event of a regional outage
- C. You need to audit the transactional application.
- D. You need to generate reports without affecting the transactional workload.
Answer: D
NEW QUESTION 65
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://teachcomputerscience.com/relational-databases/
NEW QUESTION 66
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount day. The output must produce the following results.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.
Answer:
Explanation:
NEW QUESTION 67
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 68
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 69
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:
Explanation
Box 1: No
The API determines the type of account to create. Azure Cosmos DB provides five APIs: Core (SQL) and MongoDB for document data, Gremlin for graph data, Azure Table, and Cassandra. Currently, you must create a separate account for each API.
Box 2: Yes
Azure Cosmos DB uses partitioning to scale individual containers in a database to meet the performance needs of your application. In partitioning, the items in a container are divided into distinct subsets called logical partitions. Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
Box 3: No
Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
NEW QUESTION 70
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 71
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 72
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Box 1: simple lookups
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
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.
NEW QUESTION 73
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
Answer: C
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores
NEW QUESTION 74
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:
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.
NEW QUESTION 75
Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 76
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:
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.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
NEW QUESTION 77
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 78
......
Microsoft Certified: Azure Data Fundamentals Free Certification Exam Material from ExamsLabs with 143 Questions: https://www.examslabs.com/Microsoft/Microsoft-Certified-Azure-Data-Fundamentals/best-DP-900-exam-dumps.html
DP-900 Dumps Full Questions - Exam Study Guide: https://drive.google.com/open?id=1g8Eh9j7Y-f3b2Yggzp924OrIQ7N0VyBs