- All Exams Instant Download
Which of the following should be the total number of datapoints on the next day?
An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was...
Which of the following issues will MOST likely arise with this data?
Different people manually type a series of handwritten surveys into an online database. Which of the following issues will MOST likely arise with this data? (Choose two.)A . Data accuracyB . Data constraintsC . Data attribute limitationsD . Data biasE . Data consistencyF . Data manipulationView AnswerAnswer: A, E Explanation:...
Which of the following types of charts should be considered to BEST display the data?
An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available: Which of the following types of charts should be considered to BEST display the data?A ....
A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:
A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:A . transactional schema.B . star schema.C . non-relational schema.D . snowflake schema.View AnswerAnswer:...
Which of the following must be done to the Genre column before this task can be completed?
A data analyst for a media company needs to determine the most popular movie genre. Given the table below: Which of the following must be done to the Genre column before this task can be completed?A . AppendB . MergeC . ConcatenateD . DelimitView AnswerAnswer: D Explanation: Delimiting is the...
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 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...
