ExamGecko
Search Search Login
Home Home / IIBA / CBDA
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

The finance manager has reported that customers are taking much longer to remit payments this year than last. They would like help in finding a solution to address the situation. One suggestion was to offer a 10% discount to entice customers to pay their invoices in full within the first 30 days. Before offering the discount, the finance manager would like the analytics team to do some research to determine if there is value in addressing the accounts receivable problem. Which of the following is a valid question to ask in this situation?
What type of data model describes the highest level of relationship between entities and represents how a business perceives its information?
The analytics team has been asked to determine if the organization should launch their highest revenue generating product into the North American market. To date, this has only been available in Eastern Europe. To answer this, the team formulates several research questions, including:
An analyst is doing a clinical study on the value of analyte among a large population of healthy people. The analyst is going to use a Gaussian Distribution to share the results. Which of the following represents a Gaussian Distribution?
A large retail chain has asked their analytics team to complete a study on their customers' purchasing patterns. The analyst assigned to the study has decided to draw further insight by grouping customers based on their purchasing habits. This clustering approach is an example of:
A pharmaceutical company is conducting research to determine whether a new medicine in development is more successful in reducing the pain associated with rheumatoid arthritis then their current drug in the market. A group of volunteers are selected for the research. One set of participants is provided the existing drug while a second set of participants is given the new drug. Which technique is being applied?
Which attributes from the Order entity will need to be normalized to avoid redundancies? . Orderld . OrderDate . Itemld . ItemName . Quantity . ItemPrice
A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?
Insights based on the data collected indicate that a multi-national company could increase its sales of a mature product by reducing its price by 20% which would result in increased revenues of 2% over a 6-month period. The team recommends this as an appropriate goal for its organization. This is considered a good goal because:
An analyst is doing a clinical study on the value of analyte among a large population of healthy people. The analyst is going to use a Gaussian Distribution to share the results. Which of the following represents a Gaussian Distribution? (IMAGE TAKEN)

Question 33 - CBDA discussion

Report
Export

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
Answers
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
Answers
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
Answers
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
Answers
D.
Querying is a structured way of searching, manipulating and managing data
Suggested 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.

Show Answer
asked 18/09/2024
Paramdeep Saini
39 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms