Data Analytics Foundations Assessment Drill with Answers

Combining the definitions of three words describes a data analyst. What are the three words?

Answer: data, analysis, and analyze

If you are joining data with queries, what must you know in order to validate your dataset?

Answer: the record counts

You are starting a new data project. What is one of the best sources to help you begin?

Answer: existing reports

What is the biggest advantage of working with reusable datasets?

Answer: It saves time.

Why is it important to note where your source data comes from?

Answer: so, you have a path to follow if something is off in your data

When using queries to model your data, what else will you leverage to create the datasets you need?

Answer: joins and join types

On the Home tab in Power Query, what should you select if you want to merge your two datasets into one?

Answer: Merge Queries

What is an example of cleaning data?

Answer: removing unnecessary columns

What is the biggest advantage of working with reusable datasets?

Answer: It saves time.

When you connect directly to the data, when does the data in your file get updated?

Answer: when the data and the source system are updated

Which tool in Excel lets you import or connect to external data, and then shape and analyze that data in ways that meet your needs?

Answer: Power Query

If your company says that you are not allowed to access existing data, what should you do?

Answer: Follow company rules.

When you edit and clean a macro in Excel, you can also learn more about which programming language?

Answer: VBA

Which data has a type?

Answer: all data

ETL, a critical process of data warehousing, stands for which three words?

Answer: extract, transform, and load

Where can you go for assistance and examples regarding a program's syntax?

Answer: The Help menu

If you learn Power Query in Excel, in which another platform will you also know how to use it?

Answer: Power BI

Which function in Excel determines what happens if a condition is true or false?

Answer: IF

What is a benefit of maintaining your original data?

Answer: you are provided with an audit trail

Which function is used to create aggregated datasets in Power Query?

Answer: The Group By function

Why should you only request access to the data you need?

Answer: to protect yourself and your organization

What is the primary purpose of data visualization?

Answer: to communicate information clearly and efficiently

Which SQL statement is used to retrieve data from a database?

Answer: SELECT

What is the purpose of a data warehouse?

Answer: to store and manage large volumes of data for analysis

What is a common tool used for data analysis?

Answer: Excel

What does data cleaning involve?

Answer: removing inaccuracies and inconsistencies from data

What is the role of a data engineer?

Answer: to design and maintain data systems and architecture

What is a key benefit of using data analytics in business?

Answer: to make informed decisions based on data insights

What is the function of a pivot table in Excel?

Answer: to summarize and analyze data

What is the purpose of data governance?

Answer: to ensure data quality, security, and compliance

Why is it important to document your data sources?

Answer: to maintain data integrity and traceability

What is the main goal of data mining?

Answer: to discover patterns and insights from large datasets