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