Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 121:

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 122:

  DRAG DROP

  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.

  Select and Place:

  

  Correct Answer:

  

  Box 1: Microsoft SQL Server Management Studio (SSMS)

  SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.

  Box 2: Microsoft Visual Studio Code

  Visual Studio Code is a streamlined code editor with support for development operations like debugging, task running, and version control. It aims to provide just the tools a developer needs for a quick code-build-debug cycle and leaves more

  complex workflows to fuller featured IDEs, such as Visual Studio IDE.

  Box 3: Azure Data Studio

  Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets,

  code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object

  browsing experience.

  Box 4: Microsoft SQL Server Data Tools (SSDT)

  SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS)

  reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

  Reference:

  https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

  https://code.visualstudio.com/docs/supporting/FAQ

  https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

  https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

• Question 123:

  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.

  Select and Place:

  

  Correct Answer:

  

• Question 124:

  Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

  A. WHERE

  B. SELECT

  C. JOIN

  Correct Answer: B

• Question 125:

  What is a characteristic of non-relational data?

  A. a well-defined schema

  B. no indexes

  C. self-describing entities

  D. no unique key values

  Correct Answer: D

• Question 126:

  Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates, backups, and maintenance tasks?

  A. Azure SQL Managed Instance

  B. SQL Server on Azure Virtual Machines

  C. Azure SQL Edge

  D. Azure SQL Database

  Correct Answer: A

• Question 127:

  A data engineer is responsible for which task?

  A. Design and build analytical models.

  B. Design and implement data stores for analytical workloads.

  C. Explore data to identify trends.

  D. Implement policies, tools. and processes for backup and recovery plans.

  Correct Answer: B

  A data engineer collaborates with stakeholders to design and implement data-related workloads, including data ingestion pipelines, cleansing and transformation activities, and data stores for analytical workloads. They use a wide range of data platform technologies, including relational and non-relational databases, file stores, and data streams. https://learn.microsoft.com/en-us/training/modules/explore-roles-responsibilities-world-of-data/2-explore-job-roles

• Question 128:

  Which type of Azure resource supports the serverless configuration of an Azure SQL database?

  A. Azure SQL Managed Instance

  B. SQL Server on Azure Virtual Machines

  C. a single database in Azure SQL Database

  D. an Azure SQL Database elastic pool

  Correct Answer: C

  Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.

• Question 129:

  What is a primary characteristic of a relational database?

  A. data is queried and manipulated by using a variant of the SQL language

  B. a flexible data structure

  C. a lack of dependencies between tables

  D. a large amount of duplicate data

  Correct Answer: A

• Question 130:

  Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

  A. isolation

  B. durability

  C. atomicity

  D. consistency

  Correct Answer: C