- All Exams Instant Download
Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the Quantity_sold column?
A data analyst has been asked to derive a new variable labeled “Promotion_flag” based on the total quantity sold by each salesperson. Given the table below: Which of the following functions would the analyst consider appropriate to flag “Yes” for every salesperson who has a number above 1,000,000 in the...
Which of the following is a process that is used during data integration to collect, blend, and load data?
Which of the following is a process that is used during data integration to collect, blend, and load data?A . MDMB . ETLC . OLTPD . BIView AnswerAnswer: B Explanation: ETL is a process that is used during data integration to collect, blend, and load data. ETL stands for extract,...
Which of the following sampling methods would MOST likely result in a representative sample?
A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?A . A stratified phone survey of 100 people that is conducted between 2:00...
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?
Given the following customer and order tables: Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?A . Five rows, eight columnsB . Seven rows, eight columnsC . Eight rows, seven columnsD . Nine rows,...
Which of the following statistical methods requires two or more categorical variables?
Which of the following statistical methods requires two or more categorical variables?A . Simple linear regressionB . Chi-squared testC . Z-testD . Two-sample t-testView AnswerAnswer: B Explanation: This is because a chi-squared test is a type of statistical method that tests the association or independence between two or more categorical...
Which of the following is used for calculations and pivot tables?
Which of the following is used for calculations and pivot tables?A . IBM SPSSB . SASC . Microsoft ExcelD . DomoView AnswerAnswer: C Explanation: This is because Microsoft Excel is a type of software application that allows users to create, edit, and analyze data in spreadsheets, which are composed of...
What command should he use?
Daniel is using the structured Query language to work with data stored in relational database. He would like to add several new rows to a database table. What command should he use?A . SELECT.B . ALTER.C . INSERT.D . UPDATE.View AnswerAnswer: C Explanation: INSERT The INSERT command is used to...
Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?
A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income". The "Income Categories" would be as follows: Income category 1: less than $1. Income category 2: more than $1 and less than $20,000. Income category 3: more than $20,001 and less than...
Which of the following date ranges should be on the report?
A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?A . January 1, 2020...
Which of the following is an example of a at flat file?
Which of the following is an example of a at flat file?A . CSV fileB . PDF fileC . JSON fileD . JPEG fileView AnswerAnswer: D
