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
Which of the following visualizations would BEST illustrate this information?
An analyst has been tracking company intranet usage and has been asked to create a chat to show the most-used/most-clicked portions of a homepage that contains more than 30 links. Which of the following visualizations would BEST illustrate this information?A . Scatter plotB . Heat mapC . Pie chartD ....
Which of the following would be used to store unstructured data from different sources?
Which of the following would be used to store unstructured data from different sources?A . A data lakeB . A database management systemC . A databaseD . A data warehouseView AnswerAnswer: A Explanation: This is because a data lake is a type of storage system that stores unstructured data from...
Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?
A development company is constructing a new unit in its apartment complex. The complex has the following floor plans: Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?A . $640,900B . $690,000C . $705,200D ....