A data analyst is using a two-tailed, independent t-test to determine whether the type of stretching, dynamic or static, has any influence on a dancer's flexibility. Which of the following is the alternative hypothesis?

1. A. A dancer's flexibility is improved through static stretching.
2. B. The change in a dancer's flexibility is not equal to zero.
3. C. There is a difference in a dancer's flexibility between static and dynamic stretching.
4. D. The means of the static and dynamic stretching groups do not differ from each other.

Correct Answer: C

A business intelligence team wants to create a new dashboard in order to solve a problem statement. Which of the following is the correct order of steps the team should take?

1. A. Determine business needs, find data sources, validate the data, create a mock-up, and analyze the information.
2. B. Find data sources, determine business needs, validate the data, create a mock-u
3. C. and analyze the information.
4. D. Create a mock-up, validate the data, analyze the information, determine business needs, and find data sources.
5. E. Validate the data, find data sources, analyze the information, and determine business needs.

Correct Answer: C

Which of the following query statements would be used when filtering data in a relational database management system? (Select two).

1. A. ORDER BY
2. B. HAVING
3. C. WHERE
4. D. SELECT
5. E. INSERT
6. F. GROUP BY

Correct Answer: BC

An analyst needs to summarize the number of people in Chicago in 2022 using the following set of data:

Which of the following steps should the analyst use to provide results? (Select two).

1. A. Aggregation
2. B. Sorting
3. C. Filtering
4. D. Indexing
5. E. Cleaning
6. F. Replacing

Correct Answer: AC

Which of the following is the best description of the term "data governance"?

1. A. Data governance governs the development of a data visualization dashboard in an organization.
2. B. Data governance is the policy that protects against data breaches by cybercriminals.
3. C. Data governance is the process of analyzing, manipulating, and reporting data in an organization.
4. D. Data governance is the availability, usability, integrity, and security of data in an enterprise.

Correct Answer: D
Data governance refers to the overarching management of data??s availability, usability, integrity, and security within an organization. It involves setting policies and standards that govern data usage, determining data ownership, implementing data security measures, and ensuring that data is accessible for business insights while maintaining its quality. The goal of data governance is to ensure that data is consistent, trustworthy, and not misused, supporting compliance with data privacy regulations and enabling effective data analytics to optimize operations and drive business decision-making.
References:
✑ Understanding Data Governance and Its Importance1.
✑ The Role of Data Governance in Data Management2.
✑ Defining Data Governance and Its Business Value3.