Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 151:

  You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.

  What should you use?

  A. Synapse pipelines

  B. a Synapse SQL pool

  C. Synapse Link

  D. Synapse Studio

  Correct Answer: C

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link

• Question 152:

  Which statement is an example of Data Manipulation Language (DML)?

  A. REVOKE

  B. DISABLE

  C. CREATE

  D. UPDATE

  Correct Answer: D

  Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.

  BULK INSERT DELETE INSERT SELECT UPDATE MERGE

  Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

• Question 153:

  Which statement is an example of Data Definition Language (DDL)?

  A. SELECT

  B. INSERT

  C. DELETE

  D. DROP

  Correct Answer: D

  Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:

  1.

  ALTER

  2.

  Collations

  3.

  CREATE

  4.

  DROP

  5.

  DISABLE TRIGGER

  6.

  ENABLE TRIGGER

  7.

  RENAME

  8.

  UPDATE STATISTICS

  9.

  TRUNCATE TABLE

  Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

• Question 154:

  You have a SQL query that combines customer data and order data. The query includes calculated columns.

  You need to create a database object that would allow other users to rerun the same SQL query.

  What should you create?

  A. an index

  B. a view

  C. a scalar function

  D. a table

  Correct Answer: B

  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

• Question 155:

  You need to create an Azure Storage account.

  Data in the account must replicate outside the Azure region automatically.

  Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. zone-redundant storage (ZRS)

  B. read-access geo-redundant storage (RA-GRS)

  C. locally-redundant storage (LRS)

  D. geo-redundant storage (GRS)

  Correct Answer: BD

  D: Azure Storage offers two options for copying your data to a secondary region:

  1.

  Geo-redundant storage (GRS)

  2.

  Geo-zone-redundant storage (GZRS)

  B: With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).

  Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region

• Question 156:

  A bar chart showing year-to-date sales by region is an example of which type of analytics?

  A. Predictive

  B. Prescriptive

  C. Diagnostic

  D. Descriptive

  Correct Answer: D

• Question 157:

  You need to create an Azure resource to store data in Azure Table storage. Which command should you run?

  A. az storage share create

  B. az storage container create

  C. az cosmosdb create

  D. az storage account create

  Correct Answer: D

• Question 158:

  You need to store data by using Azure Table storage.

  What should you create first?

  A. a table

  B. a blob container

  C. an Azure Cosmos DB instance

  D. a storage account

  Correct Answer: D

  First create an Azure storage account, then use Table service in the Azure portal to create a table.

  Note: An Azure storage account contains all of your Azure Storage data objects: blobs, files, queues, and tables.

  Reference: https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-quickstart-portal https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create

• Question 159:

  You need to recommend a data store service that meets the following requirements:

  1.

  Native SQL API access

  2.

  Configurable indexes What should you recommend?

  A. Azure Files

  B. Azure Cosmos DB

  C. Azure Blob storage

  D. Azure Table storage

  Correct Answer: B

  Azure Cosmos DB comes with native Core (SQL) API support.

  In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy.

  Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy

• Question 160:

  Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

  NOTE: Each correct selection is worth one point.

  A. Azure Time Series Insights

  B. Azure HDInsight

  C. Azure Databricks

  D. Azure Log Analytics

  Correct Answer: BC

  Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/