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 ....
Which of the following would BEST fulfill the analyst’s goal?
An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst’s goal?A . MedianB . MeanC...
Which one of the following tools is least likely to meet her needs?
Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders. Which one of the following tools is least likely to meet her needs?A . QuickSight.B . Tableau.C . Power BI.D . SPSS Modeler.View AnswerAnswer: D Explanation: SPSS Modeler. QuickSight,...
Which of the following report types should the data analyst create?
A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business’s performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types...