DP-900 Test Questions with Correct Verified Solutions

DP-900 Test Questions with Correct Verified
Solutions
Normalization improves data integrity Y/N?

Y

Customer : {

adress : {

line1

social media : [

service



Which is which? of (nested array, nested object and root object)

for:

1. Customer

2. Address

3. Social media

1. Root object

2. Nested object

3. Nested array

__ is a object associated with a table that sorts and stores the data rows in the table based

on their key values



A FileTable

, A foreign key

A Clustered index

A stored procedure

A Clustered index (Clustered indexes sort and store the data rows in the table or view based on

their key values. These are the columns included in the index definition. There can be only one

clustered index per table, because the data rows themselves can be stored in only one order.

Nonclustered indexes have a structure separate from the data rows. A nonclustered index

contains the nonclustered index key values and each key value entry has a pointer to the data row

that contains the key value.)

A relational database is appropriate for scenarios that involve a high volume of ____

A. changes to relationships between entities

B. transactional writes

C. writes that have varying data structures

B. transactional (OLTP) is good with relational databases

All relational and non-relational PaaS database offerings in Azure can be paused to reduce

costs. Y/N?

No

Which statement is an example of Data Manipulation Language (DML)?

A. REVOKE

B. DISABLE

C. INSERT

D. GRANT