- All Exams Instant Download
Which of the following should be included in the report?
A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO). Which of the following should be included in the report?A . The sales representatives' home addresses.B . Line-item SKU numbers.C . YTD total sales.D . The customers' first and last names.View AnswerAnswer:...
Which of the following is the MOST likely cause of the issue?
A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?A . The...
Which of the following functions did the analyst use to generate the data in the Sales_indicator column?
An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000: Which of the following functions did the analyst use to generate the data in the Sales_indicator column?A . AggregateB . LogicalC . DateD . SortView AnswerAnswer: B...
Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)
Which of the following actions should be taken when transmitting data to mitigate the chance of a data leak occurring? (Choose two.)A . Data identificationB . Data processingC . Data ReportingD . Data encryptionE . Data maskingF . Fata removalView AnswerAnswer: DE Explanation: Data encryption and data masking are two...
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 data sampling methods involves dividing a population into subgroups by similar characteristics?
Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?A . SystematicB . Simple randomC . ConvenienceD . StratifiedView AnswerAnswer: D Explanation: Stratified sampling is a data sampling method that involves dividing a population into subgroups by similar characteristics, such as age, gender, income,...
Which of the following data manipulation techniques is an example of a logical function?
Which of the following data manipulation techniques is an example of a logical function?A . WHEREB . AGGREGATEC . BOOLEAND . IFView AnswerAnswer: D Explanation: This is because an IF function is a type of logical function that returns a value based on a condition or a set of conditions....
Which of the following is the correct data type for text?
Which of the following is the correct data type for text?A . BooleanB . StringC . IntegerD . FloatView AnswerAnswer: B Explanation: A string is a data type that represents a sequence of characters, such as text, symbols, numbers, or punctuation marks. Strings are enclosed in quotation marks, such as...
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 should be accomplished NEXT after understanding a business requirement for a data analysis report?
Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?A . Rephrase the business requirement.B . Determine the data necessary for the analysis.C . Build a mock dashboard/presentation layout.D . Perform exploratory data analysis.View AnswerAnswer: B Explanation: Exploratory data analysis (EDA) is...
