Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

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

glass
pen
clip
papers
heaphones

Questions

Questions

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:

 

True

 

False

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:

 

True

 

False

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:

 

True

 

False

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

 

Maddy

 

Reggi

 

Zora

 

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.