Free Access to IIBA.CBDA.v2024-07-29.q79 with Valid Practice Test (Page 13)

Question 56

When reviewing the results of their analysis, the team is determining if the data supports their hypothesis and can be presented to decision makers. They are reviewing measures of variation, sample size and statistical significance. They realize that the p-value of 0.02 is lower than the initial target.This clearly indicates the team can:

A.Accept the null hypothesis and accept the alternative
B.Accept the null hypothesis and reject the alternative
C.Reject the null hypothesis in favor of the alternative
D.Reject the null hypothesis and reject the alternative

Question 57

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 competitor products and uses this information to adjust the retailer's prices. What type of analytics is the retailer using to maintain their pricing structure?

A.Descriptive
B.Diagnostic
C.Predictive
D.Prescriptive

Question 58

The CustomerOrder entity will include information on all customer orders. Applying database normalization rules, which set of attributes will need to be normalized to avoid redundancies?
*Customerld
*CustomerPhone
*Orderld
*OrderDate
*ProductName
*ProductQuantity
*OrderTotal

A.CustomerPhone
ProductName
B.ProductName
ProductQuantity
C.Orderld
ProductName
D.Customerld
OrderDate

Correct Answer: B

Database normalization is the process of organizing the data in a database to reduce redundancy and improve integrity, consistency, and performance1. Database normalization rules are based on the concept of normal forms, which are levels of database design that meet certain criteria2. One of the most common normal forms is the third normal form (3NF), which states that a table should not have any transitive dependencies, meaning that a non-key attribute should not depend on another non-key attribute3. In the CustomerOrder entity, the set of attributes that will need to be normalized to avoid redundancies are ProductName and ProductQuantity, as they are non-key attributes that depend on another non-key attribute, Orderld. This means that the same product information may be repeated for different orders, which could lead to data inconsistency, duplication, or update anomalies. To normalize this set of attributes, a separate table should be created for the OrderDetails entity, which would have Orderld, ProductName, and ProductQuantity as its attributes, and Orderld and ProductName as its composite primary key.
The other sets of attributes do not need to be normalized to avoid redundancies, as they do not violate the 3NF.
CustomerPhone and ProductName are non-key attributes that depend on the primary key, Customerld and Orderld respectively, which is allowed by the 3NF. Orderld and ProductName are part of the composite primary key of the OrderDetails entity, which is also allowed by the 3NF. Customerld and OrderDate are both primary keys of the Customer and Order entities respectively, which are also allowed by the 3NF.
References:1: Guide to Business Data Analytics, IIBA, 2020, p. 442: Introduction to Business Data Analytics:
A Practitioner View, IIBA, 2019, p. 93: Database Normalization: The Definitive Guide, Tableau, . : Database Normalization: The Definitive Guide, Tableau, . : Guide to Business Data Analytics, IIBA, 2020, p. 44. :
Introduction to Business Data Analytics: A Practitioner View, IIBA, 2019, p. 9. : Database Normalization: The Definitive Guide, Tableau, . : Database Normalization: The Definitive Guide, Tableau, .

Question 59

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

A.The layer of views created to summarize data or provide another perspective of certain data
B.A model that depicts the actual design of the relational database
C.An abstraction of the conceptual data model that includes rules of normalization
D.Modelling that involves objects being defined at the schema level

Question 60

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:

A.Median
B.Range
C.Mean
D.Mode

Question 56

Question 57

Question 58

Question 59

Question 60

Download PDF File