• 8 hours
  • Medium

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Got it!

Last updated on 5/5/22

Analyze Your Data and Choose the Appropriate Type of Database

Evaluated skills

  • Analyze your data and choose the appropriate type of database

Description

All of the questions refer to this dataset, apart from questions 7 and 8.




  • Question 1

    What can you say about this dataset?

    • It is structured because it’s easy to represent with few empty cells in table format.

    • It is structured because it’s not text, an image, or a video.

    • It is semi-structured because all the values in the table cells are different.

  • Question 2

    Using only the name of these three fictional database management systems (DBMS) for guidance, select which one would be most appropriate to store this data.

    • NoSQLBigDataLake

    • PowerSQL

    • VideoStockDB

  • Question 3

    Let’s suppose that data is stored in an Excel or CSV type file, viewable using a spreadsheet application. However, you want several computer programs to be able to access and update this data for sharing between the programs. 

    Which would be the most practical technical solution for developing these programs?

    • Code the programs so that they can open the file and update it.

    • Make a separate copy of the data for each computer program to use its own copy independently.

    • Input the data into a relational database managed by an RDBMS.

Ever considered an OpenClassrooms diploma?
  • Up to 100% of your training program funded
  • Flexible start date
  • Career-focused projects
  • Individual mentoring
Find the training program and funding option that suits you best