MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Overall MCQs for Reference

Which of the following is the most commonly used file format for tabular data in data science?
a. CSV
b. XML
c. MP3
d. GIF
Answer: a. CSVgeeksforgeeks+2
What does CSV stand for?
a. Column Separated Values
b. Comma Separated Values
c. Character Separated Values
d. Common Separated Values
Answer: b. Comma Separated Valuesaigents+2
Which of the following file formats is known for its efficient storage of large, structured, and complex data, especially in scientific computing?
a. PDF
b. HDF5
c. TXT
d. BMP
Answer: b. HDF5aaltoscicomp.github+2
Which data format is a lightweight, human-readable, and commonly used for API responses?
a. XLS
b. JSON
c. DOCX
d. MPEG
Answer: b. JSONquadratichq+2
Which file format is primarily column-oriented and optimized for analytical queries in big data?
a. CSV
b. Parquet
c. TXT
d. PNG
Answer: b. Parquettowardsdatascience+2
What is the main disadvantage of using XML for big datasets?
a. Lack of schema support
b. Not human-readable
c. Not compact, inefficient for large data
d. Lacks structure
Answer: c. Not compact, inefficient for large datawesmckinney+1
Which file format is specifically designed for high-performance serialization of structured data, often used with Hadoop?
a. Avro
b. GIF
c. HTML
d. SVG
Answer: a. Avrotowardsdatascience+1
What is a key advantage of using Parquet over CSV for big data?
a. Simpler syntax
b. Columnar storage leading to efficient queries and compression
c. No need for schema
d. Supports only text
Answer: b. Columnar storage leading to efficient queries and compressionmilvus+2
Which file format provides a binary serialization format for storing complex data in Python, but has security concerns?
a. Pickle (.pkl)
b. CSV
c. TIFF
d. XLSX
Answer: a. Pickle (.pkl)stackoverflow+1
Which file format is optimized for high-performance write operations in data warehouses?
a. ORC
b. CSV
c. WAV
d. MP4
Answer: a. ORCquadratichq+1
Which file extension is most commonly associated with Microsoft Excel spreadsheets?
a. .docx
b. .xlsx
c. .jpg
d. .mdb
Answer: b. .xlsxgeeksforgeeks+1
Which of the following formats is best for storing and sharing datasets that must be both human- and machine-readable?
a. JSON
b. MPEG
c. RAR
d. PSD
Answer: a. JSONtowardsdatascience+2
Which data file format is particularly used for array data and efficient scientific computation?
a. .npy
b. .svg
c. .psd
d. .exe
Answer: a. .npyaaltoscicomp.github+1
What does the “H” in HDF5 stand for?
a. Hierarchical
b. Hyperbolic
c. Hashed
d. Heuristic
Answer: a. Hierarchicalwesmckinney+2
Which file format is NOT widely used for data science?
a. CSV
b. JPEG
c. Parquet
d. JSON
Answer: b. JPEGaigents+2
For exchanging configuration settings in many applications, which format is often used?
a. XLSX
b. JSON
c. EPS
d. DOC
Answer: b. JSONaigents+1
Which format is characterized as strictly row-based, with fast binary serialization, and often used in streaming data architectures?
a. ORC
b. CSV
c. Avro
d. Parquet
Answer: c. Avrotowardsdatascience+1
What is the standard file extension for a plain text file?
a. .bin
b. .txt
c. .pkl
d. .gz
Answer: b. .txtlearningds+2
YAML is often used for:
a. Video encoding
b. Configuration files
c. Audio storage
d. Spreadsheet formulas
Answer: b. Configuration filesquadratichq
Which file format is best for storing a dataset with mixed data types, such as numbers and strings, efficiently in Python?
a. .npy
b. .xlsx
c. .tar
d. .iso
Answer: b. .xlsxtowardsdatascience+2
Which format is well-supported for handling semi-structured or nested data?
a. CSV
b. JSON
c. BMP
d. PDF
Answer: b. JSONmilvus+2
What is the main limitation of a CSV file?
a. Can’t store tables
b. No support for hierarchical data or rich metadata
c. Not human-readable
d. Cannot be used by Python
Answer: b. No support for hierarchical data or rich metadatageeksforgeeks+2
Which format offers ACID transaction support and is popular in big data?
a. Avro
b. ORC
c. CSV
d. PNG
Answer: b. ORCtowardsdatascience+1
Which data file format is best for single-purpose storage of Numpy arrays?
a. .npy
b. .csv
c. .ppt
d. .rar
Answer: a. .npystackoverflow+1
What is the main benefit of using Pickle in Python?
a. Cross-language compatibility
b. Serializing arbitrary Python objects
c. Data compression
d. Web scraping
Answer: b. Serializing arbitrary Python objectsstackoverflow+1
Which format is strongly typed, row-based, and widely used with Hadoop and Spark?
a. Avro
b. ORC
c. JSON
d. CSV
Answer: a. Avroquadratichq+1
The .npz file extension is used for:
a. Storing a single array
b. Storing multiple Numpy arrays
c. Storing images
d. Storing databases
Answer: b. Storing multiple Numpy arraysaaltoscicomp.github+1
Which big data file format is best for analytical querying on large columnar data?
a. JPEG
b. Parquet
c. YAML
d. TXT
Answer: b. Parquetmilvus+2
Which text-based markup language is often used for data interchange, supporting strict schema definition?
a. CSV
b. XML
c. Parquet
d. BIN
Answer: b. XMLaigents+1
Which file format is NOT suitable for relational data storage?
a. Parquet
b. CSV
c. GIF
d. XLSX
Answer: c. GIFgeeksforgeeks+1
What is the main advantage of binary file formats like Parquet and Avro over text formats?
a. Faster loading, better compression, supports schema
b. Human readability
c. Easier for manual editing
d. Less secure
Answer: a. Faster loading, better compression, supports schematowardsdatascience+2
Which format can Python pandas natively read and write for quick loading of structured data?
a. .csv
b. .zip
c. .mp3
d. .mov
Answer: a. .csvw3schools+1
Which file format is commonly used for data sharing and compatibility across applications and platforms?
a. JSON
b. .dll
c. .exe
d. .bat
Answer: a. JSONmilvus+2
What format would be most appropriate for very large datasets consisting of numerous, repeating columns for analysis?
a. CSV
b. Parquet
c. TXT
d. HTML
Answer: b. Parquettowardsdatascience+1
For statistical data archival and sharing, which format is most robust and versatile?
a. HDF5
b. .log
c. .bak
d. .tmp
Answer: a. HDF5wesmckinney+2
Which file extension is used for compressed tabular data files that can be opened by Excel?
a. .xls
b. .zip
c. .xlsx
d. .gz
Answer: c. .xlsxgeeksforgeeks+1
Which tabular format does NOT support data types natively and treats everything as plain text?
a. CSV
b. Parquet
c. Avro
d. ORC
Answer: a. CSVaigents+2
In TensorFlow, which file format is commonly used to save trained models?
a. .txt
b. .ckpt
c. .gif
d. .rtf
Answer: b. .ckptstackoverflow
Which file format can be used in pandas for storing Python objects as DataFrames with random access?
a. HDF5
b. .tar
c. .xml
d. .ini
Answer: a. HDF5aaltoscicomp.github+2
Which file format is best for plain, simple logs or sequential data?
a. .txt
b. .gif
c. .cdr
d. .xlsx
Answer: a. .txtlearningds+2
NDJSON (Newline Delimited JSON) is ideal for:
a. Audio processing
b. Stream processing large JSON datasets line by line
c. Image editing
d. Plotting graphs
Answer: b. Stream processing large JSON datasets line by linequadratichq
Which compressed format is often used to package multiple files together in UNIX systems?
a. .tar
b. .csv
c. .xml
d. .json
Answer: a. .targeeksforgeeks+1
Which file format is used to store and exchange hierarchical tabular datasets between various analytical software, such as R and Python?
a. HDF5
b. TXT
c. DOC
d. PNG
Answer: a. HDF5wesmckinney+1
Which data file format is most suited for dataframes with millions of rows and repeated pattern data for space efficiency?
a. Parquet
b. JSON
c. .mp4
d. .docx
Answer: a. Parquettowardsdatascience+2
Which of these is NOT a binary file format?
a. Parquet
b. Avro
c. CSV
d. ORC
Answer: c. CSVtowardsdatascience+2
Which one of these file types is not native to Python and is more associated with general text editing?
a. .docx
b. .csv
c. .json
d. .npy
Answer: a. .docxstackoverflow+2
Delta Lake format is used primarily for:
a. Real-time streaming and big data lakes
b. Gaming
c. Writing PDFs
d. Image compression
Answer: a. Real-time streaming and big data lakestowardsdatascience
Which is the preferred format for storing structured, tabular experimental results with units and column descriptions?
a. CSV
b. HDF5
c. MP4
d. GIF
Answer: b. HDF5aaltoscicomp.github+2
Feather file format is notable for:
a. Speed and efficient data exchange between R and Python
b. Audio processing
c. Serving web pages
d. Video encoding
Answer: a. Speed and efficient data exchange between R and Pythontowardsdatascience
Which is NOT a commonly used file format in data science?
a. CSV
b. Parquet
c. TIFF
d. JSON
Answer: c. TIFFaigents+2

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info