exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 93 discussion

Actual exam question from Microsoft's DP-900
Question #: 93
Topic #: 1
[All DP-900 Questions]

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
ANath
Highly Voted 3 years, 6 months ago
correct
upvoted 46 times
...
jasu
Highly Voted 4 years, 1 month ago
Reference Reading: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15#:~:text=Clustered%20indexes%20sort%20and%20store,stored%20in%20only%20one%20order.
upvoted 19 times
...
AGTraining
Most Recent 8 months ago
option D
upvoted 2 times
...
globy118
1 year, 4 months ago
Was on exam 24/6/2023
upvoted 3 times
...
Ejake
1 year, 6 months ago
Correct
upvoted 2 times
...
chiiiweiii
1 year, 7 months ago
Correct Answer
upvoted 2 times
...
SAIVEENA
1 year, 11 months ago
4th Option is correct. 1.Relational databases are static schema so option A is wrong. 2.data stored as key/value pairs is JSON (semi-structured data)relationalDB are structured data. Option B is wrong 3. Storing large images and videos is unstructured data.Option c is wrong.
upvoted 12 times
...
ria97
2 years, 2 months ago
Was in exam 11/08. Correct answer
upvoted 4 times
...
Breeze21
2 years, 3 months ago
Exam: 19.07.22
upvoted 3 times
...
passenger
2 years, 5 months ago
For this question I would select the 4th option however, I would only do that because this is the most correct out of all offered. The correct answer here is in fact incorrect because you do not have to resort to a relational database if you want to enforce ACID. There are many tools that can enforce ACID in other NoSQL databases, it does not makes relational databases the only way.
upvoted 5 times
...
print_HelloWorld
2 years, 5 months ago
Correct
upvoted 2 times
...
roshanazMaster
2 years, 6 months ago
ACID so correct
upvoted 2 times
...
RichMelbourne
2 years, 6 months ago
Shown on test 15/04/2022
upvoted 6 times
...
Teamdev
2 years, 6 months ago
It's correct !!
upvoted 2 times
...
SiDoCiOuS
2 years, 7 months ago
Appeared on the exam on 03/22/2022 Answer is correct! Strong Consistency
upvoted 3 times
...
RajeshAzure
2 years, 7 months ago
ACID rules, where C is for consistency
upvoted 3 times
...
WigglyPork
2 years, 8 months ago
correct, basic things in a relational database
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago