nerdexam
CompTIA

DA0-001 · Question #233

Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?

The correct answer is C. SQL. SQL (Structured Query Language) is specifically designed and optimized for querying and retrieving data from relational database management systems.

Data Concepts and Environments

Question

Which of the following data analytics tools would be BEST to retrieve data from a relational database management system?

Options

  • AR
  • BPython
  • CSQL
  • DSAS

How the community answered

(31 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    94% (29)

Why each option

SQL (Structured Query Language) is specifically designed and optimized for querying and retrieving data from relational database management systems.

AR

R is a programming language primarily used for statistical computing and graphics, and while it can connect to databases, it's not the native language for data retrieval from an RDBMS.

BPython

Python is a general-purpose programming language with libraries for database connectivity, but SQL is the underlying language used for actual data retrieval from an RDBMS.

CSQLCorrect

SQL (Structured Query Language) is the standard and most efficient language specifically designed for managing and retrieving data from relational database management systems.

DSAS

SAS is a software suite for advanced analytics, business intelligence, and data management, but like R and Python, it uses SQL or its own proprietary language to interact with relational databases.

Concept tested: Querying relational databases

Source: https://learn.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation

Topics

#SQL#Relational Databases#Data Retrieval#Database Query Language

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice