Home / IIBA / CBDA

IIBA CBDA Practice Test - Questions Answers, Page 6

Question list

List of questions

Question 51

(0)

While sourcing data, an analyst runs into a situation where different business units are using different names to refer to the same data element. This lack of standardization is resulting in confusi

Question 52

(0)

A dataset contains 10 measures of workplace sustainability. The analytics team is in need of producing a single score of sustainability. Which of the following techniques if used would achieve this

Question 53

(0)

An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use

Question 54

(0)

A software company launched a new product in late 2016. The product manager is reviewing a Box and Whisker plot used to compare year-over-year sales, from 2017 to 2018. What is the conclusion he can

Question 55

(0)

The interplay between enterprise systems and data analytics can be envisioned at various layers. The layer that connects the business processes to data analytics is the:

Question 56

(0)

The team has completed their analysis on a vast amount of collected data and agree on their recommendations for action. However, they are having difficulty in developing the appropriate messages to

Question 57

(0)

A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?

Question 58

(0)

A professional association is funded by membership fees. The membership renewal occurs every 5 years. Although, they have a strong subscription rate each year, their renewal rate is low. They are wo

Question 59

(0)

Which attributes from the Order entity will need to be normalized to avoid redundancies? . Orderld . OrderDate . Itemld . ItemName . Quantity . ItemPrice

Question 60

(0)

The architecture team puts forth a solution architecture that integrates multiple data sources from within and outside the organization. The architecture provides the foundation to source a new anal

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:

Question 51

While sourcing data, an analyst runs into a situation where different business units are using different names to refer to the same data element. This lack of standardization is resulting in confusion and additional time required to properly prepare data for analysis. Which practice, if implemented would address this situation and mature the organization's business analytics practice?

Data quality management

Database operations management

Data warehousing

Meta data management

Show Answer Comment (0)

Question 52

A dataset contains 10 measures of workplace sustainability. The analytics team is in need of producing a single score of sustainability. Which of the following techniques if used would achieve this objective?

Logistic regression

Linkage algorithms

Factor analysis

K means clustering

Show Answer Comment (0)

Question 53

An analyst is looking at a particular dataset that includes the scores across all 8th grade students, across three schools. The analyst is trying to determine which type of statistics average to use to best represent the results. On looking through the dataset, the analyst has identified a few extreme outliers. As a result, the analyst was led to use the following type of average:

Median

Range

Mean

Mode

Show Answer Comment (0)

Question 54

A software company launched a new product in late 2016. The product manager is reviewing a Box and Whisker plot used to compare year-over-year sales, from 2017 to 2018. What is the conclusion he can make from this chart?

2017 minimum and maximum sales are higher than 2018, and the 2017 median result is higher than the 2018 median result

2017 minimum and maximum sales are higher than 2018, but the 2017 median result is lower than 2018 1st quartile result

2018 minimum and maximum sales are higher than 2017, and the 2018 quartile results are higher than 2017 quartile results

2018 minimum and maximum sales are higher than 2017, and the 2018 1st quartile is higher than 2017 median result

Show Answer Comment (0)

Question 55

The interplay between enterprise systems and data analytics can be envisioned at various layers. The layer that connects the business processes to data analytics is the:

information layer

physical layer

technical layer

infrastructure layer

Show Answer Comment (0)

Question 56

The team has completed their analysis on a vast amount of collected data and agree on their recommendations for action.

However, they are having difficulty in developing the appropriate messages to support their recommendations. The business analysis professional suggests which technique to assist the team?

T-Testing

Simulation

Visioning

Storyboarding

Show Answer Comment (0)

Question 57

A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?

The layer of views created to summarize data or provide another perspective of certain data

A model that depicts the actual design of the relational database

An abstraction of the conceptual data model that includes rules of normalization

Modelling that involves objects being defined at the schema level

Show Answer Comment (0)

Question 58

A professional association is funded by membership fees. The membership renewal occurs every 5 years. Although, they have a strong subscription rate each year, their renewal rate is low. They are working with an external firm specializing in Business Analytics to identify the groups of customers that have a high likelihood of cancelling their subscription after their first 5-year term ends. This type of study is called:

Untrained learning

Supervised learning

Trained learning

Unsupervised learning

Show Answer Comment (0)

Question 59

Which attributes from the Order entity will need to be normalized to avoid redundancies?

. Orderld

. OrderDate

. Itemld

. ItemName

. Quantity

. ItemPrice

OrderDate ItemPrice

ItemName ItemPrice

OrderDate ItemName

Item Name Quantity

Show Answer Comment (0)

Question 60

The architecture team puts forth a solution architecture that integrates multiple data sources from within and outside the organization. The architecture provides the foundation to source a new analytics program. If one of the objectives of the analytics team was to provide 'one source of the truth', this objective would be referring to which of the following?

Identifying one key stakeholder, who can make final decisions about which sources to relate/merge

Evaluating the completeness, validity, and reliability of the data from source systems

Ensuring stakeholders always have clear insight into the final requirements at all times

Enforcing master data management principles and practices

Show Answer Comment (0)

Total 152 questions

4 5 6 7 8

Go to page: of 16