Free DP-900 Exam Braindumps (page: 13)

Page 12 of 78

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

  1. Azure Data Lake Storage
  2. Azure Queue storage
  3. Azure Blob storage
  4. Azure Cosmos DB

Answer(s): A

Explanation:

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



HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.


Reference:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15



What is a characteristic of batch processing?

  1. The data ingested during batch processing must be processed as soon as the data is received.
  2. Large datasets must be split into batches of less than 1 GB before the data can be processed.
  3. There is a noticeable time delay between ingesting data and obtaining the data processing results.
  4. Batch processing can only process data that is structured.

Answer(s): C



HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:
-APPROX_COUNT_DISTINCT
-AVG
-CHECKSUM_AGG
-COUNT
-COUNT_BIG

GROUPING
-GROUPING_ID
-MAX
-MIN
-STDEV
-STDEVP
-STRING_AGG
-SUM
-VAR
-VARP


Reference:

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






Post your Comments and Discuss Microsoft DP-900 exam with other Community members:

DP-900 Exam Discussions & Posts