Microsoft DP-900 Practice Test - Questions Answers, Page 21

Reference:

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

You must create a separate account for each API.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account

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

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

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

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

Box 1: Yes Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

Box 2: No

An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.

Box 3: Yes

A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described

https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15

Reference:

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