Data Storage Options: 10 practice questions

Question 1 of 10

Which description correctly identifies the CSV file format?

1. AHierarchical objects use braces, collections, and name-value attributes.
2. BColumn data is grouped in row groups with metadata for locating chunks.
3. CPlain-text fields are separated by commas, and rows end with a new line.
4. DElements and attributes are defined by tags enclosed in angle brackets.

Question 2 of 10

Which file format represents hierarchical objects and can support structured or semi-structured data?

1. ABLOB
2. BCSV
3. CAvro
4. DJSON

Question 3 of 10

Which feature describes a relational database?

1. AIt stores structured entities in tables that can reference one another through keys.
2. BIt stores entities as nodes whose relationships are represented by connecting links.
3. CIt stores each record as one unique key with an associated value of any format.
4. DIt groups logically related columns into families without applying a relational schema.

Question 4 of 10

Which comparison between Parquet and Avro is correct?

1. AParquet uses XML tags for elements, while Avro uses comma-delimited text rows.
2. BParquet is row-based with a JSON header, while Avro stores columns in row groups.
3. CParquet stores raw media BLOBs, while Avro stores relational tables connected by keys.
4. DParquet is columnar, while Avro is row-based with a JSON header and binary records.

Question 5 of 10

What does Delta Lake add to Parquet files?

1. AA transaction log supporting ACID transactions, versioning, and reliable updates
2. BAn XML tag hierarchy that defines elements and attributes for every record
3. CA graph model that stores entities as nodes connected by relationship links
4. DA fixed-width text layout that allocates equal characters to each field

Question 6 of 10

Which nonrelational model directly represents highly connected data by recording the connections among entities?

1. AA relational database with entities organized in key-linked tables
2. BA graph database with entities as nodes and relationships as links
3. CA column-family database with related columns organized into groups
4. DA document database with each value stored as a JSON document

Question 7 of 10

Which rule correctly distinguishes a file store from a database?

1. AA file store manages relational records, while a database keeps files without querying them.
2. BA file store requires graph nodes, while a database requires comma-delimited text files.
3. CA file store applies table keys, while a database is limited to removable media.
4. DA file store keeps files directly, while a database manages and queries data records.

Question 8 of 10

A team must exchange structured rows with many applications, and people must be able to inspect the files in a text editor. Which format best fits the requirement?

1. AParquet, because its column chunks are intended primarily for direct human editing
2. BCSV, because it provides broadly accessible and human-readable delimited text
3. CAvro, because its binary records are designed to display as readable text rows
4. DBLOB, because raw binary media is the standard readable form for tabular fields

Question 9 of 10

An order system must store structured customers and orders, give each entity a unique identifier, and connect each order to its customer without repeating all customer details. Which datastore design fits?

1. AA column-family database that avoids the relational schema described in the requirement
2. BA relational database with tables connected by primary-key references
3. CA shared file store containing unrelated binary objects without managed records
4. DA graph database that replaces tables and keys with nodes and relationship links

Question 10 of 10

An Azure solution needs a central cloud location where several applications work directly with important data files. The requirement does not describe managed records or queries. Which datastore category should be identified first?

1. AA cloud-hosted shared file store for centrally managed files
2. BA relational database for structured records connected across tables by keys
3. CA graph database for entities represented as nodes joined through relationship links
4. DA document database for records whose values are parsed as JSON documents