WorksheetsData Types and Formats Quiz
Total questions: 38
Worksheet time: 19mins
Charlotte is organizing data for a school project. Which of the following is an example of structured data?
A video file
A handwritten letter
A database table of employee records
A PDF resume
A social media post
Anika is working on a project that involves analyzing various types of data. Which of the following is true about the unstructured data she might encounter?
It can always be stored in a relational database.
It does not exist in the real world.
It includes only text-based data.
It often includes videos, images, and audio files.
It cannot be analyzed.
Arjun is working on a project where he needs to organize customer feedback data. He notices that the data includes tags and attributes but isn't fully organized in tables. How is this type of data best described?
Completely organized data in table format.
Unreadable data.
Data with tags and attributes but not fully organized in tables.
Raw data that hasn’t been processed.
Data exclusively stored in relational databases.
Mia is working on a project where she needs to save a list of contacts in a file format that can be easily opened in spreadsheet applications. Which file format should she use for delimited files?
.HTML
.CSV
.JSON
.XML
.VBS
James is working on a project where he needs to organize data in a CSV file. What typically separates the data fields in this type of file?
Commas
Tabs
Spaces
Pipes
Semicolons
Rohan is working on a project that involves different types of data. Which of the following is an example of semi-structured data?
A handwritten document
An XML file
A flat file
A video file
A database table
Benjamin is working on a project where he needs to choose a data format for exchanging information between a web server and a client. He is considering using JSON or XML. What is the main advantage of JSON over XML?
JSON cannot be read by programming languages.
JSON uses a simplified syntax with fewer requirements.
JSON is a markup language.
JSON cannot represent arrays.
JSON requires more storage space than XML.
Avery is working on a project that involves storing a large amount of unstructured data, such as images and videos. Which type of data storage should Avery consider using?
Relational databases
BLOB storage
SQL servers
Excel spreadsheets
Flat file databases
James is working on a project where he needs to ensure that data can be easily shared between different systems. What technology should he use to achieve this?
Displaying web pages in a browser.
Transferring data.
Running scripts on a server.
Managing relational databases.
Converting unstructured data into JSON.
Grace is learning web development and wants to create a webpage. Which of the following statements about HTML is true?
HTML is used to transfer data between servers and web applications.
HTML is a markup language used to display information in a browser.
HTML uses object-oriented syntax.
HTML replaces the need for CSS in web design.
HTML is primarily used for data analysis.
Grace is working on a project to manage her school's library data. She needs a system that can:
Organize data into tables with relationships between them.
Store videos and images.
Handle unstructured data exclusively.
Use JSON files for all queries.
Replace flat file databases.
Aria is working on a data analysis project and needs to choose the correct file format for her data. Which of the following is NOT a delimited file extension?
.CSV
.TAB
.TXT
.JSON
.TSV
Liam is working on a project where he needs to export data from Excel to another system. Which file format should he most commonly use?
.HTML
.CSV
.JSON
.SQL
Mia is learning SQL and wants to retrieve data from specific columns in a database table containing student records. What SQL keyword should she use?
Retrieves data from specified columns in a database table.
Deletes rows from a database.
Imports data into a database.
Sorts data by a specific column.
Changes the structure of a database table.
Maya is organizing data for her school project. Which of the following are examples of structured data that she can use? (Select all that apply)
A database table
An Excel spreadsheet
A SharePoint list
A PDF document
A video file
Henry is creating a JSON file to store information about his favorite books. What types of values can he use for the key-value pairs in his JSON file?
Only a string.
Only a number.
A string, number, object, array, Boolean, or null.
A script.
A file extension.
Michael is designing a webpage for his school project and needs to organize some data in a structured format. Which HTML tag should he use to define a table structure for this data?
Display images on a web page.
Create hyperlinks.
Define a table structure for data.
Transfer data between systems.
Write CSS.
Liam is working on a project where he needs to choose between using a flat file database and a relational database. He learns that flat file databases differ from relational databases because:
Flat files lack relationships between data.
Flat files are more flexible.
Flat files update in real-time.
Flat files cannot store tabular data.
Flat files require SQL to function.
Nora is working on a database project and needs to sort the list of students by their grades. Which of the following is a key word she should use in her SQL query?
SELECT
WHERE
FILTER
ORDER BY
INSERT
Grace is working on a project that involves storing a large amount of unstructured data from various sources. Which of the following best describes the type of storage system she should consider using?
A type of relational database.
A storage system for large amounts of unstructured data.
A software tool for working with CSV files.
A system for live-streaming data.
A programming language.
David is working on a data analysis project and needs to save his data in a format that uses a specific delimiter. What delimiter is typically used in a TSV file?
Comma
Tab
Pipe
Space
Semi-colon
Luna is working on a project where she needs to differentiate between structured and unstructured data. What is the main difference?
Structured data is less valuable.
Unstructured data is always textual.
Structured data is organized into tables, while unstructured data is not.
Only structured data can be visualized.
Unstructured data cannot have any metadata.
Grace and Priya are working on a web development project. They need to choose the right tools for structuring and presenting their data. Which of the following are examples of markup languages? (Select all that apply)
HTML
XML
JSON
SQL
Python
Grace is learning about JSON and wants to know how JSON arrays are enclosed. Can you help her?
Curly brackets {}
Square brackets []
Parentheses ()
Angle brackets <>
Double quotes ""
Priya is exporting data from Excel and saves it with a .TXT file extension. What does this indicate about the format of the exported data?
Comma-separated data
JSON data format
Tab-delimited data
Image data
Script file
Aiden is working on a project that involves analyzing customer feedback data. What is an advantage of using structured data for this task?
It is easier to visualize.
It requires less storage space.
It is more compatible with HTML.
It is easier to query and analyze.
It is always more accurate.
Priya is working on a project that involves transferring large amounts of unstructured data between different systems. Which of the following file formats should she use?
.CSV
.TAB
.XML
.SQL
.TXT
Abigail is working on a web-based application that processes CSV files containing user data from around the world. Why is UTF encoding important for these CSV files?
It ensures numerical accuracy.
It prevents corruption of database records.
It supports special characters and international text.
It compresses the file size.
It enhances readability in plain text editors.
Maya is working on a project to analyze social media reactions to a recent event. Which storage system is most likely to be used for this analysis?
Relational database
Data lake
SQL server
Flat file database
Local storage
Benjamin is working on a project where the data doesn't need to update dynamically. When would he use a flat file instead of a relational database?
When the data doesn’t need to update dynamically.
When the data must be highly structured and relational.
When the data is primarily unstructured.
When SQL syntax is required.
When tags are used for organization.
Jackson is working on a project where he needs to organize data in a structured format. What is the primary role of tags in XML for his project?
To define and describe the data they contain.
To create tables in web applications.
To replace relational database schemas.
To interact with SQL queries.
To improve compression of unstructured data.
Abigail is organizing her digital photo album. Which of the following are examples of metadata she might encounter? (Select all that apply)
File creation date
Image resolution
Number of rows in a table
The actual text in a document
Audio file duration
Ava is working on a project where she needs to analyze a large dataset stored in a CSV file. Which tool can she use to automatically interpret the data and open it in a readable format?
Excel
SQL Server
SharePoint
JSON Viewer
HTML Editor
Abigail is working on a project where she needs to export data from a database to share with her team. Which of the following is true about the flat files she might use for this purpose?
They dynamically update with the database.
They cannot store tabular data.
They are static and require re-exporting to reflect changes.
They are compatible only with XML.
They are optimized for unstructured data storage.
Why does Olivia prefer using relational databases for managing her structured data in her school project?
They are faster than all other database systems.
They require less maintenance.
They allow for relationships between tables to manage data efficiently.
They store data in JSON format.
They automatically process unstructured data.
Benjamin is working on a project where he needs to exchange data between a server and a web application. Which of the following is true about JSON, the format he is considering using?
It uses predefined tags for structure.
It is primarily used to display data in browsers.
It uses key-value pairs for data interchange.
It replaces the need for relational databases.
It does not support arrays.
Abigail is working on a project where she needs to export data from a database to share with her team. What is a key characteristic of the delimited files she might use?
They require manual entry of metadata.
They are exclusive to Excel.
They dynamically update with live data connections.
They use characters like commas or tabs to separate data fields.
They can only store unstructured data.
Oliver is working on a project that involves analyzing customer feedback from various social media platforms. What is a significant challenge he might face when dealing with this unstructured data?
It often requires more storage space.
It cannot be analyzed.
It lacks any form of metadata.
It cannot be stored in BLOB storage.
It is rarely encountered in real-world applications.
