What is the best way to store and manage a dataset that consists of two million records?

IT Exam Items RepositoryCategory: Data Analytics EssentialsWhat is the best way to store and manage a dataset that consists of two million records?

What is the best way to store and manage a dataset that consists of two million records?

  • a relational database
  • a spreadsheet
  • a Python data analysis program
  • a single flat database

Explanation: Spreadsheets typically have a maximum data record limit of much less than two million. A Python data analysis program does not store any data records within the program. Managing two million records in a flat data base would be unwieldly and complex.

Related exam: Module 10.3.2 Quiz - Take the Next Steps