- 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 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 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 types of charts should be considered?
A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available: Which of the following types of charts...
Which of the following query optimization techniques would effectively prevent SQL Injection attacks?
A web developer wants to ensure that malicious users can't type SQL statements when they asked for input, like their username/userid. Which of the following query optimization techniques would effectively prevent SQL Injection attacks?A . Indexing.B . Subset of records.C . Temporary table in the query set.D . Parametrization.View AnswerAnswer:...
Which of the following are reasons to create and maintain a data dictionary? (Choose two.)
Which of the following are reasons to create and maintain a data dictionary? (Choose two.)A . To improve data acquisitionB . To remember specifics about data fieldsC . To specify user groups for databasesD . To provide continuity through personnel turnoverE . To confine breaches of PHI dataF . To...
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...
What does he have to make sure he checks for in his ELT process?
Jhon is working on an ELT process that sources data from six different source systems. Looking at the source data, he finds that data about the sample people exists in two of six systems. What does he have to make sure he checks for in his ELT process? Choose the...
Which one of the following is a common data warehouse schema?
Which one of the following is a common data warehouse schema?A . Snowflake.B . Square.C . Spiral.D . Sphere.View AnswerAnswer: A Explanation: Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. The Snowflake data platform is not built...
What kind of issues is Angela facing?
Angela is aggregating data from CRM system with data from an employee system. While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system. What kind of issues is Angela facing? Choose the best answer.A . ETL process.B ....
