Online Access Free CBDA Practice Test

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.Customerld
  OrderDate
• B.ProductName
  ProductQuantity
• C.Orderld
  ProductName
• D.CustomerPhone
  ProductName

A government agency is conducting a study on the performance of 12th grade students' in mathematics across the country. In particular, they want to understand if there is a relationship between intelligence and scores, as well as the difference in performance between various locations. Which combination of inferential statistics procedures should be used?

• A.Range, standard deviation
• B.Correlation co-efficient, analysis of variance
• C.Mean, median
• D.Frequency distribution, time-series

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:

• A.physical layer
• B.information layer
• C.technical layer
• D.infrastructure layer

A consumer products company gained popularity with increased growth and brand recognition with one of its products. Although they have a loyal customer base and past year's performance results have shown steady growth, the Senior Leadership team wants to keep product leadership as their primary strategic priority.What would be their primary goal?

• A.Maintain operational efficiencies so that their products can continue to be competitively priced
• B.Focus on providing value to customers by offering innovative and leading edge products
• C.Focus on their other products/product lines so that they gain momentum in popularity as well
• D.Ensure that their top product continues to gain market share and maintain high standards

A large number of text messages are received by Twitter each year making Twitter one example of Big Data.
What data characteristic represents this large number of text messages?

• A.Veracity
• B.Value
• C.Velocity
• D.Variety