1) Which type of data analytics did Tim perform at the end of 2018?

Select one: a. Prescriptive b. Predictive c. Descriptive d. Both A and C

2) The Cincinnati Reds is looking to hire a new Minor League Director of Pitching Initiatives. When Kyle Boddy filled out the job application for this position, he had to answer questions about past job employment. In doing so, after he selected United States, he could only select from a dropdown list including the fifty states as the location of employment. Which type of edit test is this?

Select one: a. Valid codes b. Consistency c. Completeness d. Alphanumeric field content

3) Warehouse operations have shut down at SHXCX Manufacturing suddenly due to a power outage. Warehouse managers are still able to communicate with their home office and their data servers, but unfortunately have no prepared solution to restoring operations. Which of the following controls would be best suited to combat this problem? Select one: a. Validity test b. Business Continuity Plan (BCP) c. Disaster Recovery Plan (DRP) d. Both B and C Derwin Schlecker is chair of the Gold Panda Society, which maintains a database of all panda bears across the globe. Note the following information about a relational database comprising two tables. The first table stores the name, birth date, and other characteristics of panda bears parents that have been registered. In this table, each panda bear parent is uniquely identified by a registration number. The second table stores the name, birth date, and other characteristics of panda bear kids that have been registered. In this table, each panda bear is also uniquely identified by a registration number. This second table also includes information about both the male and female parent registration numbers of each kids parents. The panda bear kids in the second table are linked to their parents in the first table by means of the registration numbers of both their male and female parents. What is the primary key in the first table?

Select one: a. Name b. Birth date c. Kid registration number d. The foreign key(s) in the second table

4) How many primary keys and foreign keys are in this relational database?

Select one: a. One primary key, one foreign key b. One primary key, two foreign keys c. Two primary keys, one foreign key d. Two primary keys, two foreign keys

5)

Nate Duncan is currently involved in Step 3 of REA modeling, and as such he is trying to determine the proper relationship for sales orders to salespersons. Which relationship should he select?

Select one:

a. One-to-one (1:1)

b. One-to-many (1:N)

c. Many-to-many (N:N) (H)

d. There is not enough information to determine the appropriate category for this relationship