Objective 2.3 Merge and Load Data Sets CERTIFIED-DATA-SCIENCE-PRACTITIONER Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which of the following is a popular data visualization tool that can connect directly to a cleaned dataset to create interactive dashboards?

   • ATableau
   • BApache Spark
   • CPostgreSQL
   • DJupyter Notebook
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which file format is preferred for storing a large cleaned dataset that will be used for repeated analytical queries, because it stores data in a columnar layout and preserves schema?

   • ACSV
   • BParquet
   • CTXT
   • DJSON
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Before loading a cleaned dataset into a database, what should be defined to ensure data integrity?

   • AThe color scheme of the database dashboard
   • BThe file format of the source data
   • CThe number of rows to load
   • DSchema and constraints (e.g., primary key, foreign key, NOT NULL)
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   During a merge, you discover that some key values in one dataset are formatted as integers (e.g., 123) while the same keys in the other dataset are strings (e.g., '123'). What is the appropriate action?

   • ARename the columns to be identical
   • BDrop the rows with integer keys
   • CConvert both key columns to a common data type before merging
   • DProceed with the merge; the database will handle the type difference
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which file format is best suited for sharing a cleaned dataset with a colleague who will use it in a spreadsheet application?

   • AAvro
   • BParquet
   • CCSV
   • DPickle
   Reveal Solution Discussion Select an answer first