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

Questions 16–20

1. 16foundation · easy

   What is a key characteristic of semi-structured data?

   • AIt always has the same fields in every record.
   • BIt allows for flexibility in the data model, so different records can have different attributes.
   • CIt cannot be queried using any standard query language.
   • DIt is stored in a relational database with predefined tables.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   A company wants to store transactional data from its point-of-sale system for reporting. Which type of data is this?

   • AUnstructured data, because the data is generated by a machine.
   • BSemi-structured data, because transactions may have optional fields like discount codes.
   • CStructured data, because each transaction has the same fields: date, amount, product ID, and store ID.
   • DUnstructured data, because the data is stored in a database.
   Reveal Solution Discussion Select an answer first
4. 18application · easy

   A software company is designing a configuration file for a new application. The file needs to store nested settings, such as database connection details and feature flags, and must be human-readable and easily parsed by multiple programming languages. Which format should they choose?

   • AFixed-width text
   • BJSON
   • CBinary serialization
   • DCSV
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A manufacturing company collects machine logs from sensors. The logs are stored as plain text files with varying formats. The company wants to detect anomalies in machine behavior by analyzing the logs. They have limited budget and need a solution that can process the logs without manual data entry. What is the most practical approach?

   • AUse Azure Data Factory to copy the logs into a data lake and then use Azure Databricks to parse and analyze them.
   • BUse Azure Cognitive Search to index the logs and then use search queries to find anomalies.
   • CStore the logs in Azure SQL Database and use SQL queries to analyze them.
   • DUse Azure Stream Analytics to parse and analyze the log files in real time.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company uses a relational database to store employee records. They need to add a new attribute, 'Department', to all existing and future records. What is the most efficient way to accomplish this?

   • ACreate a new table for each department and insert existing records.
   • BModify each row individually to include the new attribute.
   • CStore the department information in a separate JSON file.
   • DAlter the table to add a new column with a default value.
   Reveal Solution Discussion Select an answer first