While reviewing survey data, an analyst notices respondents entered "Jan," "January," and "01" as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

• A.Delete any of the responses that do not have "January" written out.
• B.Replace any of the responses that have "01".
• C.Filter on any of the responses that do not say "January" and update them to "January".
• D.Sort any of the responses that say "Jan" and update them to "01".

Comment: *

Name: *

Email: *

Verification: *

Which of the following is a domain-specific language used in programming that is designed for managing data that is held in a relational data stream management system?

• A.SAS
• B.Python
• C.SQL
• D.R

Comment: *

Name: *

Email: *

Verification: *

Andy is a pricing analyst for a retailer. Using a hypothesis test, he wants to assess whether people who receive electronic coupons spend more on average.
What should Andy's null hypothesis be?

• A.People who receive electronic coupons spend more on average.
• B.People who receive electronic coupons spend less on average.
• C.People who receive electronic coupons do not spend more on average.
• D.People who do not receive electronic coupons spend more on average.

Comment: *

Name: *

Email: *

Verification: *

Given the diagram below:

Which of the following data schemas shown?

• A.Key-value pairs
• B.Online transactional processing
• C.Data Lake
• D.Relational database

Comment: *

Name: *

Email: *

Verification: *

An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

• A.In Germany, the increase in conversion from the new layout was not significant.
• B.In France, the increase in conversion from the new layout was not significant.
• C.In general, users who visit the new website are more likely to make a purchase.
• D.The new layout has the lowest conversion rates in the United Kingdom.

Comment: *

Name: *

Email: *

Verification: *