Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 11:

  Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network. Which type of data store should you use?

  A. Key/value

  B. Graph

  C. Document

  D. Columnar

  Correct Answer: B

• Question 12:

  Which type of database contains nodes and edges?

  A. graph

  B. columnar

  C. key/value

  D. time series

  Correct Answer: A

• Question 13:

  You have structured data in tabular format.

  What represents an individual instance of a data entity?

  A. a column

  B. a cell

  C. a row

  D. a table

  Correct Answer: C

• Question 14:

  A bank has a system that manages financial transactions.

  When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.

  Of which ACID semantic is this an example?

  A. atomicity

  B. isolation

  C. durability

  D. consistency

  Correct Answer: B

• Question 15:

  HOTSPOT

  For each of the following statements. select Yes if the statement is true. Otherwise, select No.

  NOTE Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 16:

  HOTSPOT

  Select the answer that correctly completes the sentence.

  Hot Area:

  

  Correct Answer:

  

  An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:

  1.

  APPROX_COUNT_DISTINCT

  2.

  AVG

  3.

  CHECKSUM_AGG

  4.

  COUNT

  5.

  COUNT_BIG

  6.

  GROUPING

  7.

  GROUPING_ID

  8.

  MAX

  9.

  MIN 10.STDEV 11.STDEVP 12.STRING_AGG 13.SUM 14.VAR 15.VARP

  Reference: https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15

• Question 17:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Yes Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.

  Box 2: Yes

  Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.

  Box 3: No

  Reference:

  https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/

• Question 18:

  HOTSPOT

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

  

  Hot Area:

  

  Correct Answer:

  

  

  Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords. You can process one media file or multiple media files in a batch.

• Question 19:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Yes 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).

  Box 2: No

  Box 3: Yes Box 4: Yes Azure Cosmos DB supports multi-region writes.

• Question 20:

  HOTSPOT

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

  Hot Area:

  

  Correct Answer:

  

  Reference: https://teachcomputerscience.com/relational-databases/