Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

100% Original, Plagiarism Free, Customized to Your instructions!




Question 1 (2 points)

You are asked to organize a meeting on the topic of developing a marketing database to support the company’s business objectives. Which of the following topics should be on the agenda for the meeting?

Question 1 options:


All of these items


Legal considerations about what is permissible or not permissible about the data


Technical considerations such as hardware and software.


None of these items


Competitive considerations such as comparisons vs. peer companies

Question 2 (2 points)

Your CMO is an expert in database marketing and asks you to make sure that the company has high-quality House data to use in database marketing. House data refers to:

Question 2 options:


Data about the homes of your customers


Economic data about trends in real-estate


All of these


None of these


A way to differentiate customers that own vs. rent homes

Question 3 (2 points)

Imagine that you work in the airline industry and are analyzing customer data. Which of the following would be a useful new variable for identifying customers for a “Valued Frequent Flyers” loyalty program?

Question 3 options:


A ratio variable that calculates the dollar amount per trip


None of these


A logic-counter variable that counts the number of different airports a customer has flown to/from


A variable that measures the average number of days between trips


All of these

Question 4 (2 points)

You want to conduct an analysis to see if response rates by Age Groups (coded as <20, 20-30, 30-50, 50+) also differ by Gender (coded as M, F in the database). The appropriate analytic technique to examine this is:

Question 4 options:


None of these


A cross tabulation of response rates by Age x Gender


All of these


A ratio variable created from Gender and Age


A logic counter variable involving the number of Males in the database

Question 5 (2 points)

Your database analyst asks you why there are decoy records in the database. Which of the following reasons should be part of your explanation?

Question 5 options:


None of these


For monitoring and tracking how those records are used


To always have at least one record in the database


All of these


To protect privacy information, so that real records need not be extracted or revealed

Question 6 (2 points)

A match-code could be used as a value for a Primary Key field in a relational database table

Question 6 options:





Question 7 (2 points)

You have been asked to take over an existing relational database, so you examine one of the tables. You notice that one of the fields contains the same value for all records. Which of the following might you note in terms of the database design

Question 7 options:


Repetition and redundancy of information within a table is a poor design choice because it is an inefficient use of space


Repetition and redundancy of information within a table is a good design choice because it prevents information loss


As long as SQL code can be written against the database, the table structures don’t matter.


All of these


None of these

Question 8 (2 points)

You are asked to expand the design of an existing relational database system by incorporating a new table of additional information. You notice that in this new table, none of the existing fields contain unique values and so none of the fields can be used as a primary key. A good design decision would be to

Question 8 options:


All of these


Leave the table alone and do not relate it to any other tables


Break up this and all other tables so that primary keys can “emerge” and redo the relationships among tables


None of these


Add a new field to this table to serve as the primary key for the table

Question 9 (2 points)

Which of the following is not a valid SQL statement?

Question 9 options:


SELECT * FROM jobs_table;


None of these


All of these


PROC REG table=jobs (value=’Vice President’, salary=Y);


SELECT title SUM(salary) FROM jobs_table GROUP BY title;

Question 10 (2 points)

SnowSQL is the SQL language used for what database platform?

Question 10 options:


Microsoft database


None of these


Hive database


Snowflake database


Any of these

Question 12 (2 points)

Which of the following characteristics are true about MapReduce analytics?

Question 12 options:


It is a mapping technique that converts Geographic/Spatial coordinates to their geographic areas on a map


It is an analytic approach where data and processing are distributed across many computer nodes running in parallel


It is a way to reduce several records of multiple customers if they have the same household address


All of these


None of these

Question 14 (2 points)
A random sample and a representative sample are equivalent to each other

Question 14 options:





Question 17 (2 points)

You have built a simple regression model, and during a presentation of the model, the Chief Analytics Officer asks what is the model’s “coefficient of determination”?

Question 17 options:


He is asking for the R-squared value


None of these


All of these


He is trying to determine if the model is a good fit


He is asking for the amount variance explained by the model

Question 18 (2 points)

If there is a low or very weak correlation between Customer Satisfaction (Y), and Amount Spent (X), then a simple regression model using amount spent to predict customer satisfaction will not have much explanatory power.

Question 18 options:





Question 19 (2 points)

The difference between multiple regression and simple regression is:

Question 19 options:


In simple regression, there is a single predictor variable (X), but in multiple regression there can be more than one predictor (X’s)


In simple regression, there is a single Y variable that you are trying to predict, but in multiple regression there can be multiple measures (Y’s)


All of the above


In simple regression, there is only one equation to summarize the relationship, but a multiple regression model is can have more than one equation.


None of the above

Question 21 (2 points)

Imagine that you are looking at a table summarizing the results of a multiple regression model. The largest coefficient value of a predictor means that variable is the most important predictor for Y

Question 21 options:


True, because it will have the largest effect on the predicted value, Y.


False because the coefficient has no effect on the calculation of the predicted value, Y


True, but only if the coefficients for the predictors are standardized coefficients


All of these


None of these

Question 22 (2 points)

You run a snack shop at the beach and you find a perfect positive correlation between the weather (TEMPERATURE) and the revenue you receive from sales of drinks (REVBEV). So based on the weather forecast for the upcoming week you can predict how much revenue you’ll get. Does this mean that you can also look at revenues from the past week and know (predict) what were the temperatures?

Question 22 options:


Yes, if you convert TEMPERATURE and REVBEV to their z-score values, then you can use the same simple regression equation both ways.


None of these


All of these


Yes, but only if the values of TEMPERATURE and REVBEV in your regression equation use values within the range that you calculated the correlation from


Yes, if you have two separate simple regression models to predict TEMPERATURE from REVBEV, and to predict REVBEV from TEMPERATURE

Question 24 (2 points)

You can hire one database analyst, and you are interviewing three candidates for the position. Each has said they had experience handling missing data and you ask candidates what they did. Candidate Zora says she plugged missing values with 0’s. Candidate Maddy says she plugged missing values with the Median. Candidate Reggi says she used multiple regression to impute values that were missing. On the basis of their answers, who is the best candidate?

Question 24 options:


None of these. Keep interviewing








Any one of these, they’re all equally good.

Question 25 (3 points)

Please rate this exam (Free points, as any answer is correct)

Question 25 options:


Much easier than expected


Easier than I expected


About what I expected


More difficult that I expected


Much more difficult than I expected

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.