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

Questions 31–35

1. 31foundation · easy

   Which of the following is an example of structured data?

   • AA collection of email messages stored as text files.
   • BA JSON file containing product information with varying fields.
   • CA customer database table with columns for CustomerID, Name, and PhoneNumber.
   • DA video file stored in a blob storage container.
   Reveal Solution Discussion Select an answer first
2. 32expert · hard

   A news organization archives millions of articles, images, and video clips. They want to enable journalists to search for past content by topic, person, and location. The content is stored in Azure Blob Storage. They also need to handle new content as it is published. What is the most effective solution?

   • AUse Azure SQL Database with full-text indexing on the binary columns.
   • BUse Azure Cognitive Search to index text and metadata extracted from the content.
   • CStore all content in a relational database with a column for the binary data.
   • DCreate a custom file naming convention and use Azure Blob Storage metadata for search.
   Reveal Solution Discussion Select an answer first
4. 33application · medium

   A research organization has a large collection of interview recordings, handwritten notes, and photographs. They want to enable researchers to search for specific topics mentioned in the recordings and notes. What is the primary challenge they must address before searching the content?

   • AEnsuring the files are stored in a single Azure region
   • BExtracting text and metadata from the unstructured content
   • CStoring the files in a relational database
   • DConverting the files to a structured format such as CSV
   Reveal Solution Discussion Select an answer first
5. 34application · medium

   A media company stores video files, audio recordings, and images for their content library. They want to analyze the content to generate metadata like objects detected in images and speech-to-text transcripts. What is the primary challenge they face when processing this data?

   • AThe data must be converted to structured format before any processing.
   • BThe data cannot be stored in a database at all.
   • CThe data is too large to store in cloud storage.
   • DThe data has no inherent structure, so extracting meaningful information requires specialized processing like AI or machine learning.
   Reveal Solution Discussion Select an answer first
6. 35application · medium

   A financial institution maintains a ledger of transactions. Each transaction has a fixed schema: transaction ID, account ID, amount, and timestamp. The institution needs to support high-volume insertions and fast queries that aggregate daily totals per account. Which storage approach is most appropriate?

   • AA relational database table with indexes on account ID and timestamp
   • BA JSON document per transaction in Azure Cosmos DB
   • CA CSV file appended to Azure Blob Storage
   • DA key-value store with transaction ID as the key
   Reveal Solution Discussion Select an answer first