Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 141:

  You have data saved in the following format.

  

  \

  Which format was used?

  A. XML

  B. yaml

  C. JSON

  D. HTML

  Correct Answer: C

• Question 142:

  You have data saved in the following format:

  

  Which format was used?

  A. YAML

  B. HTML

  C. XML

  D. JSON

  Correct Answer: C

• Question 143:

  What is a characteristic of batch processing?

  A. The data ingested during batch processing must be processed as soon as the data is received.

  B. Large datasets must be split into batches of less than 1 GB before the data can be processed.

  C. There is a noticeable time delay between ingesting data and obtaining the data processing results.

  D. Batch processing can only process data that is structured.

  Correct Answer: C

• Question 144:

  Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

  A. SET

  B. VALUES

  C. KEY

  D. JOIN

  Correct Answer: D

  Reference: https://www.tutorialspoint.com/sql/sql-using-joins.htm

• Question 145:

  Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.

  What should you use?

  A. Azure Application Gateway

  B. Azure Traffic Manager

  C. Azure DNS

  D. Azure Private Link

  Correct Answer: D

  Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.

  Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary

  Reference: https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

• Question 146:

  Which three actions are used when performing diagnostic analytics?

  A. 1. Identify data anomalies

  2.

  Collect anomaly-related data

  3.

  Discover relationships and trends that explain anomalies.

  B. 1. Identify data anomalies

  2.

  Predict when anomalies are likely to recur

  3.

  Use analytical tools such as decision trees and regression.

  C. 1. Apply serf-learning loops to draw inferences from anomalies.

  2.

  Predict when anomalies are likely to recur

  3.

  Use analytical tools such as decision trees and regression.

  D. 1. Identify data anomalies

  2.

  Use machine learning to find patterns in large datasets.

  3.

  Discover relationships and trends that explain anomalies.

  Correct Answer: A

• Question 147:

  You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

  

  What should you create in Power BI Desktop?

  A. a waterfall chart

  B. a ribbon chart

  C. a bar chart

  D. a decomposition tree

  Correct Answer: A

  Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

• Question 148:

  Which type of database is Azure Database for PostgreSQL?

  A. Platform as a service (PaaS)

  B. Infrastructure as a service (IaaS)

  C. Microsoft SQL Server

  D. on-premises

  Correct Answer: A

  Reference: https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options

• Question 149:

  Which storage solution supports access control lists (ACLs) at the file and folder level?

  A. Azure Data Lake Storage

  B. Azure Queue storage

  C. Azure Blob storage

  D. Azure Cosmos DB

  Correct Answer: A

  Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).

  Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

• Question 150:

  Your company is 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. columnar

  B. key/value

  C. document

  D. graph

  Correct Answer: B

  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.

  Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview