Home / IIBA / CBDA

Question list

List of questions

Question 1

(0)

A Data Dictionary is being developed for an employee database. When reviewing the data dictionary, the analyst recommends adding another primitive data element. Which element would be suggested?

Question 2

(0)

Collaborative games are used by a business analyst to identify the research questions to be explored within an analytics system. Participants are asked to write down a research question on a sticky

Question 3

(0)

An analytics system is being developed by relying entirely on research questions that are framed using the results from benchmarking. Which research question is being asked?

Question 4

(0)

Based on the financial analysis that's been completed by the analytics team, the business analysis professional reminds the team that the most financially feasible option is the one with the:

Question 5

(0)

A consumer goods manufacturer has recently completed an analytics study to understand how to improve its operational excellence. From the top highlights, online sales outperformed other channels in

Question 6

(0)

A real estate broker is tracking monthly sales between two of its teams. The results have been visualized. What insights can be drawn from the chart?

Question 7

(0)

The analytics team has been asked to assess sales data from their company's website with the hopes of providing insights to help increase online sales. It's the first time the team is looking at thi

Question 8

(0)

Operation managers are concerned about the increasing attrition rates in the call center. A series of interviews is being conducted with call center agents to collect information to better understan

Question 9

(0)

The research question prompting the use of analytics is well-defined. The team obtains the results and determines that the source data did not provide reliable results. As a result of this finding,

Question 10

(0)

An online retailer of men's athletic apparel is seeking to become the market leader in the industry. To deliver on this strategy, the analytics team continuously collects data on the prices of compe

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 74 - CBDA discussion

A data scientist at a consumer goods company, has been asked to do a detailed analysis on customer profiles. The Data Scientist has identified an external data source that carries valuable additional information on their customers. The data scientist also identifies the address column as the most reliable column to join the internal data source with the external data source. Addresses may appear in different formats for example:

File A = '13 Smith St'

File B = 'Unit 7, 13 Smith Street'

Which of the following techniques would be useful in this situation?

Deterministic linkage

Probabilistic linkage

Genetic linkage

Cuff linkage

Suggested answer: B

Explanation:

Probabilistic linkage is a technique that uses statistical methods to match records from different data sources based on the similarity of key variables, such as name, address, date of birth, etc1.Probabilistic linkage can handle variations, errors, or missing values in the data, and assign a score or probability to each potential match2. Probabilistic linkage would be useful in this situation, as the address column may have different formats, spellings, or abbreviations in the internal and external data sources, and a deterministic linkage (which requires exact matches) might miss some valid matches or create false matches.

Deterministic linkage is a technique that uses predefined rules or criteria to match records from different data sources based on the exact agreement of key variables, such as identifiers, codes, or hashes3. Deterministic linkage would not be useful in this situation, as the address column may not have consistent or unique values in the internal and external data sources, and a probabilistic linkage (which allows for some variation or uncertainty) might find more accurate matches or avoid false matches.

Genetic linkage is a term used in genetics to describe the tendency of genes or DNA sequences that are located close together on a chromosome to be inherited together4. Genetic linkage is not relevant to this situation, as it has nothing to do with matching records from different data sources based on the address column.

Cuff linkage is a term used in sewing to describe the process of attaching a cuff to a sleeve by stitching or fastening.Cuff linkage is not relevant to this situation, as it has nothing to do with matching records from different data sources based on the address column.

Show Answer

asked 18/09/2024

Danilo Paolucci

42 questions

Your answer: A B C D

0 comments

Sorted by