Online Access Free Microsoft.DP-900.v2023-02-21.q84 Practice Test (Page 8)

DP-900 Exam Question 31

You need to modify a view in a relational database by adding a new column.
Which statement should you use?

A.UPDATE

B.MERGE

C.INSERT

D.ALTER

DP-900 Exam Question 32

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

DP-900 Exam Question 33

Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

A.key/value

B.document

C.graph

D.columnar

DP-900 Exam Question 34

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

A.denormalized data

B.heavy writes and moderate reads

C.light writes and heavy reads

D.schema on write

E.schema on read

F.normalized data