An e-commerce organization is reviewing their cloud data storage. What type of raw data can they store in a relational database without any processing?
Product inventory data, such as product names, descriptions, pricing, and inventory levels, can be stored in a relational database without any processing. This type of structured data is commonly stored in a database to track and manage the organization's product inventory.
Product photographs are typically large files in image format (JPEG, PNG, etc.) and are considered unstructured data. Storing these files directly in a relational database is not efficient or recommended.
Similar to product photographs, instructional videos are typically large files in video format (MP4, AVI, etc.) and are considered unstructured data. Storing videos directly in a relational database is not efficient.
Customer chat history often consists of unstructured text data, including messages, timestamps, and metadata. Relational databases are designed for structured data, and storing unstructured text data directly in a database is not optimal.
B + C: images and videos could only be saved in BLOB columns, and those have size limits of course. In any case, it would be far from optimal to store them in a relational DB.
D: The chat history itself is semi-structured at best. Also, chat texts probably are longer strings, which a relational DB is also not optimized for.
A: Product inventory probably references to data points such as product ID, stock etc., and is a typical use case for relational DB.
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.
cookieMr
Highly Voted 1 year, 1 month agoaTTager
Most Recent 4 months agochai_gpt
8 months, 1 week ago__rajan__
8 months, 3 weeks agomdsarfraz69
9 months, 3 weeks agoPreeetii
11 months, 1 week agohireshgupta
11 months, 3 weeks agoKC_go_reply
1 year, 3 months agoatoledo
1 year, 9 months agoAshish_01
1 year, 10 months agoVin1975
1 year, 10 months ago