Describe Ways to Represent Data DP-900 Practice Questions (Page 6)

Questions 26–30

1. 26foundation · easy

   Which statement best describes semi-structured data?

   • AData that has some organizational properties, such as tags or key-value pairs, but does not conform to a rigid schema.
   • BData that has no structure at all, such as images and audio files.
   • CData that is stored in a binary format and requires special software to read.
   • DData that has a fixed schema with a strict hierarchy of tables and columns.
   Reveal Solution Discussion Select an answer first
2. 27application · medium

   An e-commerce platform sends order confirmation messages to customers. Each message includes a fixed header (order ID, customer email, timestamp) and a variable body that may contain different promotional offers. The platform needs to store these messages for auditing and later analysis. Which format is most suitable?

   • AFixed-width text
   • BPlain text
   • CJSON
   • DCSV
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A marketing team collects customer feedback from social media posts, emails, and call center transcripts. They want to analyze sentiment and identify common themes. What is the first step they should take to make this data analyzable?

   • AExtract text and metadata from the various sources
   • BConvert all data to XML format
   • CLoad all data into a single SQL table
   • DStore the data in Azure Blob Storage without any processing
   Reveal Solution Discussion Select an answer first
5. 29application · medium

   A marketing team receives customer feedback from multiple channels: emails, social media posts, and survey responses. Each channel provides different fields; for example, emails have subject and body, social media posts have likes and shares, and surveys have ratings. The team wants to store all feedback in a single repository for analysis. Which approach is most appropriate?

   • ACreate a single relational table with columns for all possible fields from all channels.
   • BStore each channel's feedback in a separate relational database and merge them manually.
   • CStore each feedback item as a JSON document with a 'type' field and channel-specific attributes.
   • DStore all feedback as plain text files and use full-text search.
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   What is a key characteristic of structured data?

   • AIt uses a hierarchical tag-based format to store nested elements.
   • BIt is stored as a collection of files with no common format.
   • CIt requires a NoSQL database to store because of its varying attributes.
   • DIt can be stored in a relational database with a fixed schema.
   Reveal Solution Discussion Select an answer first