Arcitura Education C90.02 Exam - Topic 4 Question 97 Discussion

Actual exam question for Arcitura Education's C90.02 exam

Question #: 97
Topic #: 4

We exported data from our on-premise relational database to a cloud-based non-relational database. After the export, we noticed that the size of the cloud-based database was significantly larger than our on-premise database. What is the likely reason that the database size increased?

Select the correct answer.

AThe transmission of the data over a wide area network resulted in the accumulation of additional meta data from HTTP headers that was stored in the non-relational database, resulting in the increase in data received by the cloud.

BThe data in the relational database was normalized and became denormalized after being exported into a non-relational database.

CIn order to support higher levels of scalability, the cloud-based database is required to add state data to the non-relational data it stores. This state data is used to synchronize instances of the database tables during runtime usage, but also increases the size of the overall database.

DAll of the above.

Show Suggested Answer

Suggested Answer: B

by Portia at Sep 17, 2024, 06:13 AM

Limited Time Offer

25%

Off

Get Premium C90.02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Kristian

4 months ago

A seems unlikely to me. HTTP headers shouldn't make a huge difference in size.

upvoted 0 times

...

Aleisha

4 months ago

I doubt C is a factor. State data doesn't usually add that much size.

upvoted 0 times

...

Salina

4 months ago

Wait, isn't it possible that all of them contribute? D could be the answer too!

upvoted 0 times

...

Kayleigh

4 months ago

Totally agree with B! Non-relational databases usually denormalize data.

upvoted 0 times

...

Emile

4 months ago

I think B is the right answer. Normalization vs. denormalization makes sense.

upvoted 0 times

...

Rose

5 months ago

I wonder if all of these factors combined could be the reason for the size increase. Option D sounds plausible, but I need to think more about it.

upvoted 0 times

...

Novella

5 months ago

I practiced a similar question where denormalization was mentioned, and it seems like that could definitely lead to increased size.

upvoted 0 times

...

Kristine

5 months ago

I'm not entirely sure, but I feel like the additional metadata from the transmission could also play a role. Maybe option A is relevant too?

upvoted 0 times

...

Cherrie

5 months ago

I remember discussing how normalization affects database size, so I think option B might be the right answer.

upvoted 0 times

...

Ernie

5 months ago

This seems straightforward. The data was transmitted over a network, so the increase in size is probably due to additional metadata from the HTTP headers being stored in the non-relational database. I'll select option A.

upvoted 0 times

...

Fausto

5 months ago

Hmm, I think I know the answer to this one. The non-relational database likely needs to store additional state data to support higher scalability, which would increase the overall database size. I'll go with option C.

upvoted 0 times

...

Abel

5 months ago

I'm a bit confused on this one. Is it something to do with the normalization/denormalization of the data? Or maybe the cloud database needs to store additional metadata for scalability? I'll have to review my notes on database concepts.

upvoted 0 times

...

Gilma

5 months ago

Okay, let me see. The question mentions that the data was exported from a relational database to a non-relational database. That's a key clue - the data structure and storage format must have changed.

upvoted 0 times

...

Kristine

5 months ago

Hmm, this is an interesting one. I'll need to think through the key differences between relational and non-relational databases to figure out the likely reason for the size increase.

upvoted 0 times

...

Julieta

6 months ago

The key is to focus on the core principles of API security, like authentication, authorization, and data protection. I think options A and C are the way to go.

upvoted 0 times

...

Daniel

1 year ago

I agree with both of you. The state data added for scalability in the cloud-based database could also contribute to the increase in size.

upvoted 0 times

...

Eleonore

1 year ago

I believe it could also be because of the additional meta data accumulated during data transmission over the network.

upvoted 0 times

...

Desmond

1 year ago

I think the increase in database size is due to the normalization of data from the relational database.

upvoted 0 times

...

Tamra

2 years ago

Haha, all of the above? That's the easy way out! I bet the correct answer is more specific than that.

upvoted 0 times

...

Avery

2 years ago

I'm going with C. The cloud database needs to add extra state data to handle the scalability, which makes sense to me.

upvoted 0 times

Vincenza

1 year ago

C seems to be the most logical choice. The state data for synchronization would explain the increase in size.

upvoted 0 times

...

Brandee

1 year ago

Yeah, C sounds right. The extra state data for scalability is necessary for cloud databases.

upvoted 0 times

...

Merissa

1 year ago

I agree, C makes the most sense. The state data for synchronization would definitely increase the size.

upvoted 0 times

...

Juliann

1 year ago

I think the answer is C. The cloud database needs to add extra state data for scalability.

upvoted 0 times

...

Annice

2 years ago

Hmm, I think it's option B. The normalization in the relational database probably got denormalized in the non-relational one, leading to the size increase.

upvoted 0 times

Elvis

1 year ago

Yeah, that could explain the increase in size.

upvoted 0 times

...

Gary

2 years ago

I think you're right, option B does make sense.

upvoted 0 times

...