Arcitura Education Exam C90.02 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%

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

7 months ago

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

upvoted 0 times

...

Brandee

8 months ago

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

upvoted 0 times

...

Merissa

8 months ago

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

upvoted 0 times

...

Juliann

8 months ago

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

upvoted 0 times

...

Annice

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

8 months ago

Yeah, that could explain the increase in size.

upvoted 0 times

...

Gary

9 months ago

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

upvoted 0 times

...