Which statement is true about database querying?

An analyst at a supermarket chain has been asked to extract data from multiple data sources to complete a study on customer spending habits. The analyst is going to query data from various databases.

Which statement is true about database querying?
A . Querying can be used to create predictive data models
B . Irrespective of the querying language used, data results retrieved are always in a tabular format
C . A querying language is independent of the type of database being used
D . Querying is a structured way of searching, manipulating and managing data

View Answer

Answer: D

Explanation:

Querying is a technique that allows analysts to access, filter, join, aggregate, and transform data from various databases using a specific syntax and logic1. Querying can be used for different purposes, such as data exploration, data preparation, data analysis, and data visualization2. Querying is not limited to creating predictive data models, nor does it always produce tabular results. Moreover, querying languages may vary depending on the type and structure of the database, such as relational, hierarchical, or document-based3.

Reference: 1: Guide to Business Data Analytics, IIBA, 2020, p. 552: Data Analysis Using SQL and Excel, Gordon S. Linoff, 2016, p. 33: Database Systems: Design, Implementation, and Management, Carlos Coronel and Steven Morris, 2019, p. 17.