Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Microsoft DP-900 Exam - Topic 7 Question 64 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 64
Topic #: 7

[All DP-900 Questions]

What is a characteristic of a non-relational database?

Aa fixed schema

Bself-describing entities

Cfull support for Transact-SQL

Show Suggested Answer

Suggested Answer: C

by My at May 29, 2023, 09:58 AM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Merrilee

9 months ago

Full support for Transact-SQL? Nope, that's not it!

upvoted 0 times

...

Tamra

9 months ago

Yup, no fixed schema in non-relational!

upvoted 0 times

...

Noah

10 months ago

Wait, are you sure about that? I thought they had fixed schemas.

upvoted 0 times

...

Paola

10 months ago

Totally agree, that's a key feature!

upvoted 0 times

...

Misty

10 months ago

Non-relational databases have self-describing entities.

upvoted 0 times

...

Eleonore

10 months ago

I don’t recall non-relational databases using Transact-SQL, so I’m leaning towards option B being correct.

upvoted 0 times

...

Makeda

10 months ago

I feel like we practiced a question similar to this, and I think the answer was related to how data is stored without a fixed structure.

upvoted 0 times

...

Corrie

11 months ago

I remember something about self-describing entities being a feature of non-relational databases, but I’m not completely confident.

upvoted 0 times

...

Louvenia

11 months ago

I think non-relational databases are supposed to have a flexible schema, so I’m not sure about option A.

upvoted 0 times

...

Mari

11 months ago

This question seems pretty straightforward. The key is to focus on the keywords like "collaboration" and "risk taking" - that points me towards the "People" answer.

upvoted 0 times

...

Lili

11 months ago

This is a good test of our knowledge on extended data types. I'll carefully review each option and make sure I select the three properties that can be modified. Paying close attention to the details will be key here.

upvoted 0 times

...

Glory

1 year ago

Wait, is this a trick question? If it's a non-relational database, it definitely doesn't have full support for Transact-SQL. I'm picturing the developer who wrote that option laughing maniacally.

upvoted 0 times

Ronnie

1 year ago

I agree, C is definitely a red herring in this question.

upvoted 0 times

...

Rickie

1 year ago

Yeah, it's definitely not C. Non-relational databases don't use Transact-SQL.

upvoted 0 times

...

Fernanda

1 year ago

Definitely not C, that's a trick option.

upvoted 0 times

...

Gail

1 year ago

C) full support for Transact-SQL

upvoted 0 times

...

Thersa

1 year ago

B) self-describing entities

upvoted 0 times

...

Lang

1 year ago

A) a fixed schema

upvoted 0 times

...

...

Francoise

1 year ago

A fixed schema? That's more like a relational database, isn't it? I'm going with option B, self-describing entities.

upvoted 0 times

Gaston

1 year ago

I'm going with option B, self-describing entities.

upvoted 0 times

...

Doretha

1 year ago

A fixed schema? That's more like a relational database, isn't it?

upvoted 0 times

...

Vicente

1 year ago

I'm going with option B, self-describing entities.

upvoted 0 times

...

Shaunna

1 year ago

A fixed schema? That's more like a relational database, isn't it?

upvoted 0 times

...

...

Nan

1 year ago

That makes sense, non-relational databases like NoSQL can handle unstructured data better with self-describing entities.

upvoted 0 times

...

Annice

1 year ago

I disagree, I believe it is self-describing entities because they can store data without a predefined structure.

upvoted 0 times

...

Carmen

1 year ago

Full support for Transact-SQL? In a non-relational database? I think the exam writer needs to brush up on their database knowledge.

upvoted 0 times

Cherry

1 year ago

B) self-describing entities

upvoted 0 times

...

Malcom

1 year ago

A) a fixed schema

upvoted 0 times

...

...

Nan

1 year ago

I think a characteristic of a non-relational database is a fixed schema.

upvoted 0 times

...

Lou

1 year ago

I believe non-relational databases do not have a fixed schema, so option A is not correct.

upvoted 0 times

...

Yuki

1 year ago

Hmm, a non-relational database, that's gotta be option B. Those self-describing entities sound like a unique feature.

upvoted 0 times

...

Tiffiny

1 year ago

I agree with Ronnie, non-relational databases do have self-describing entities.

upvoted 0 times

...

Ronnie

1 year ago

I think a characteristic of a non-relational database is self-describing entities.

upvoted 0 times

...