DP-900 : Microsoft Azure Data Fundamentals : Part 02

DP-900 : Microsoft Azure Data Fundamentals : Part 02

1. DRAG DROP

   Match the types of data to the appropriate Azure data services.

   To answer, drag the appropriate data type from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.

   NOTE: Each correct match is worth one point.

   

   

   Explanation:

   Box 1: Image files
   Azure Blob storage is suitable for image files.

   Box 2:Key/value pairs
   Azure CosmosDB table API is a key-value storage hosted in the cloud.

   Box 3: Relationship between employees
   One-to-many relationships between business domain objects occur frequently: for example, one department has many employees. There are several ways to implement one-to-many relationships in the Azure Table service.

2. DRAG DROP

   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.

   

   

   Explanation:

   Box 1: Azure Storage account
   Azure file shares are deployed into storage accounts, which are top-level objects that represent a shared pool of storage.

   Box 2: File share

3. What are two characteristics of real-time data processing? Each correct answer presents a complete solution.

   NOTE: Each correct selection is worth one point.

   • Data is processed periodically
   • Low latency is expected
   • High latency is acceptable
   • Data is processed as it is created
   Explanation:
   Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.

4. DRAG DROP

   Match the Azure Data Factory components to the appropriate descriptions.

   To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.

   NOTE: Each correct match is worth one point.

   

   

   Explanation:

   Box 1: Dataset
   Datasets must be created from paths in Azure datastores or public web URLs, for the data to be accessible by Azure Machine Learning.

   Box 2: Linked service
   Linked services are much like connection strings, which define the connection information needed for Data Factory to connect to external resources.

   Box 3: Pipeline
   A pipeline is a logical grouping of activities that together perform a task.

5. DRAG DROP

   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.

   

   

   Explanation:

   Box 1: Batch
   Batch processing refers to the processing of blocks of data that have already been stored over a period of time.

   Box 2: Streaming
   Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results.

   Box 3: Batch

6. HOTSPOT

   To complete the sentence, select the appropriate option in the answer area.

   

   

7. You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.

   Which type of authentication should you use?

   • service principal authentication
   • Azure Active Directory (Azure AD) authentication
   • SQL authentication
   • certificate authentication

8. What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

   • built-in high availability
   • native support for cross-database queries and transactions
   • system-initiated automatic backups
   • support for encryption at rest

9. HOTSPOT

   To complete the sentence, select the appropriate option in the answer area.

   

   

   Explanation:

   When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysql server, for example, a server-level firewall blocks all access to the public endpoint for the server

10. You need to design and model a database by using a graphical tool that supports project-oriented offline database development.

    What should you use?

    • Microsoft SQL Server Data Tools (SSDT)
    • Microsoft SQL Server Management Studio (SSMS)
    • Azure Databricks
    • Azure Data Studio

11. DRAG DROP

    Match the security components to the appropriate scenarios.

    To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.

    NOTE: Each correct match is worth one point.

    

    

12. You have a transactional application that stores data in an Azure SQL managed instance.

    When should you implement a read-only database replica?

    • You need to generate reports without affecting the transactional workload.
    • You need to audit the transactional application.
    • You need to implement high availability in the event of a regional outage.
    • You need to improve the recovery point objective (RPO).
    Explanation:
    Use read-only replicas to offload read-only query workloads.

13. HOTSPOT

    To complete the sentence, select the appropriate option in the answer area.

    

    

14. HOTSPOT

    To complete the sentence, select the appropriate option in the answer area.

    

    

15. HOTSPOT

    To complete the sentence, select the appropriate option in the answer area.

    

    

16. 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.

    • You must be assigned the Reader role for the resource group that contains the database.
    • You must have SELECT access to the Products table.
    • You must have a user in the database.
    • You must be assigned the Contributor role for the resource group that contains the database.
    • Your IP address must be allowed to connect to the database.
    Explanation:
    Incorrect Answers:
    A, D: Resource group permissions is not required to query an Azure SQL database table.

17. You have an inventory management database that contains the following table.

    

    Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

    • INSERT

    • MERGE

    • UPDATE

    • CREATE

18. Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.

    Which Azure service should you use?

    • Azure HDInsight
    • Azure SQL Database
    • Azure Cosmos DB
    • SQL Server on Azure virtual machines

19. You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

    You need to embed documents and query results into a SQL notebook.

    What should you use?

    • Microsoft SQL Server Management Studio (SSMS)
    • Azure Data Studio
    • Azure CLI
    • Azure PowerShell

20. DRAG DROP

    Match the terms to the appropriate descriptions.

    To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.

    NOTE: Each correct match is worth one point.