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.
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)- A3% (1)
- B3% (1)
- C94% (29)
Why each option
SQL (Structured Query Language) is specifically designed and optimized for querying and retrieving data from relational database management systems.
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.
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.
SQL (Structured Query Language) is the standard and most efficient language specifically designed for managing and retrieving data from relational database management systems.
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
Community Discussion
No community discussion yet for this question.