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

List of questions
Question 51

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

HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Reference:
https://teachcomputerscience.com/relational-databases/
Question 53

HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
Question 54

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.
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
Question 55

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.
Reference:
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview
https://azure.microsoft.com/en-us/pricing/details/bandwidth/
Question 56

HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console
Question 57

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.
Question 58

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

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

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.
Question