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

Questions 16–18

1. 16foundation · easy

   Before merging two datasets on a common key, what is the most important verification step?

   • ASort both datasets by the key column
   • BConfirm that the key column exists in both datasets and has compatible data types
   • CRemove all missing values from the datasets
   • DEnsure the datasets have the same number of rows
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   When loading a cleaned dataset into Power BI for dashboard creation, which of the following is a common method?

   • ACopy and paste the data into a Power BI canvas
   • BImport the data from a CSV file using 'Get Data'
   • CUse the 'Load Data' SQL command
   • DRun a Python script to push data to Power BI
   Reveal Solution Discussion Select an answer first
3. 18foundation · easy

   What is the primary purpose of creating an API endpoint for a cleaned dataset?

   • ATo allow external applications to access the data programmatically
   • BTo permanently store the data in a database
   • CTo compress the data for storage
   • DTo visualize the data in a dashboard
   Reveal Solution Discussion Select an answer first