Google Data Analytics Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 40

Fill in the blank: Data _____ refers to the accuracy, completeness, consistency, and trustworthiness of data throughout its life cycle.

IntegrityCorrect Answer

analysis

sampling

replication

Explanation:

Data integrity is the accuracy, completeness, consistency, and trustworthiness of data throughout its life cycle.

QUESTION 2 OF 40

A healthcare company keeps copies of their data at several locations across the country. The data becomes compromised because each location creates a copy of the original at different times of day. Which of the following processes caused the compromise?

Data manipulation

Data transfer

Data gathering

Data replicationCorrect Answer

Explanation:

Data replication caused the compromise. Data replication is the process of storing data in multiple locations. If not done properly, replication can compromise integrity and cause inconsistencies.

QUESTION 3 OF 40

A data analyst is given a dataset for analysis. It includes data about the total population of every country in the previous 20 years. Based on the available data, an analyst would be able to determine the reasons behind a certain country's population increase from 2016 to 2017.

True

FalseCorrect Answer

Explanation:

Based on the available data, the analyst would need more data to determine the reasons behind the population increase.

QUESTION 4 OF 40

A data analyst is given a dataset for analysis. To use the template for this dataset, click the link below and select “Use Template.” Link to template: June 2014 Invoices OR If you don’t have a Google account, download the CSV file directly from the attachment below. The analyst notices a limitation with the data in rows 8 and 9. What is the limitation?

Row 8 is not in the correct format.

Row 9 is a duplicate of row 8.Correct Answer

Row 8 and row 9 show the wrong currency.

Row 9 needs more data.

Explanation:

Row 9 is a duplicate of row 8. Duplicate data is a limitation because it will lead to faulty analysis.

QUESTION 5 OF 40

A data analyst at a nonprofit organization is working with a dataset about a summer fundraiser. Although they have a lot of useful data by the end of the month, they recognize that the data is insufficient. So, they decide to wait until the end of the season to begin working with the dataset. Which type of insufficient data does this example describe?

Data that keeps updatingCorrect Answer

Outdated data

Geographically limited data

Data from only one source

Explanation:

This example describes insufficient data that keeps updating. If a dataset keeps updating, that means the data is still incoming and might be incomplete.

QUESTION 6 OF 40

In the data analysis process, how does a sample relate to a population?

A sample is an average of all the data that represents the population.

A sample is an ideal example taken from a population.

A sample is a part of a population that is representative of the population.Correct Answer

A sample is a duplicate selection of data that is taken from the population.

Explanation:

A sample relates to a population by representing a population at a smaller scale.

QUESTION 7 OF 40

Fill in the blank: Sampling bias in data collection happens when a sample isn’t representative of _____.

the population as a wholeCorrect Answer

the population most affected by the data

a dataset about the population

a subset of the population

Explanation:

Sampling bias in data collection happens when a sample isn’t representative of the population as a whole.

QUESTION 8 OF 40

Sometimes during analysis, an analyst discovers that it’s necessary to adjust the business objective. When this happens, the analyst should take the initiative to do so without involving others in order to be respectful of their time.

True

FalseCorrect Answer

Explanation:

If a data analyst believes the business objective should be adjusted, it’s important to first have a discussion with stakeholders.

QUESTION 9 OF 40

A data analyst is given a dataset for analysis. It includes data about the total population of every country in the previous 20 years. Which of the following questions would the analyst need more data to address?

What was the population of a certain country in 2020?

Which country had the greatest population in 2015?

Which country had the smallest population in 2017?

What was the reason for the population increase in a certain country?Correct Answer

Explanation:

The analyst would need more data to identify the reason for a population increase.

QUESTION 10 OF 40

A data analyst is working on a project about the global supply chain. They have a dataset with lots of relevant data from Europe and Asia. However, they decide to generate new data that represents all continents. What type of insufficient data does this scenario describe?

Data that's geographically limitedCorrect Answer

Data that's outdated

Data that keeps updating

Data from only one source

Explanation:

This example describes data that is insufficient because it’s geographically limited. If the analytics project has a global focus, the dataset should also be global.

QUESTION 11 OF 40

A restaurant wants to gather data about a new dish by giving out free samples and asking for feedback. Who should the restaurant give samples to?

All dinersCorrect Answer

80% of diners

Diners who spend the most money on their meal

Diners who are willing to pay for the samples

Explanation:

The restaurant should give samples to all diners.

QUESTION 12 OF 40

Which of the following conditions are necessary to ensure data integrity? Select all that apply.d)

Privacy

Statistical power

AccuracyCorrect Answer

CompletenessCorrect Answer

Explanation:

Accuracy and completeness are necessary to ensure data integrity.

QUESTION 13 OF 40

A data analyst is given a dataset for analysis. It includes data about the total population of every country in the previous 20 years. Which of the following questions can the analyst use this dataset to address? Select all that apply.

What was the reason for the population increase in a certain country?

What was the effect of migration on the population of a certain country?

What was the difference in population between two specific countries in 2018?Correct Answer

What was the average population of a certain country from 2015 through 2020?Correct Answer

Explanation:

The analyst could use the dataset to find the average population of a certain country from 2015 through 2020 and the difference in population between two specific countries in 2018.

QUESTION 14 OF 40

A data analyst at a software company wants to learn more about industry competitors. Because the software industry has more mergers than any other field, the companies and their products are constantly evolving. The analyst has a dataset from three years ago, and they notice that many of the companies and products in the dataset have changed. What makes the analyst decide that the data is insufficient, so they should generate fresh data instead?

It is geographically limited data

It is data from only one source

It is outdated dataCorrect Answer

It is data that keeps updating

Explanation:

This example describes outdated data, which is insufficient. If a dataset is outdated, that means the data is old and probably no longer relevant.

QUESTION 15 OF 40

Fill in the blank: If a data analyst is using data that has been _____, the data will lack integrity and the analy) sis will be faulty.

CompromisedCorrect Answer

clean

wide

public

Explanation:

If a data analyst is using data that has been compromised, the data will lack integrity and the analysis will be faulty.

QUESTION 16 OF 40

A financial analyst imports a dataset to their computer from a storage device. As it’s being imported, the connection is interrupted, which compromises the data. Which of the following processes caused the compromise?

Data analysis

Data manipulation

Data transferCorrect Answer

Data gathering

Explanation:

Data transfer caused the compromise. When a data transfer is interrupted, it can result in an incomplete dataset.

QUESTION 17 OF 40

A data analyst is given a dataset for analysis. To use the template for this dataset, click the link below and select “Use Template.” Link to template: June 2014 Invoices OR If you don’t have a Google account, download the CSV file directly from the attachment below. Rows 10 and 11 contain duplicate data.

True

FalseCorrect Answer

Explanation:

Rows 10 and 11 do not contain duplicate data.

QUESTION 18 OF 40

A restaurant gathers data about a new dish by providing free samples to parties of six or more diners. What does this scenario describe?

Unbiased sampling

Random sampling

Sampling biasCorrect Answer

Geographically limited sampling

Explanation:

This scenario describes sampling bias because parties of six or more are not representative of the population as a whole.

QUESTION 19 OF 40

Which of the following processes helps ensure a close alignment of data and business objectives?

Transferring data multiple times

Having data update automatically during analysis

Completing data replication

Maintaining data integrityCorrect Answer

Explanation:

Maintaining data integrity helps ensure a close alignment of data and business objectives because the data is likely to be accurate, complete, consistent, and trustworthy.

QUESTION 20 OF 40

When gathering data through a survey, companies can save money by surveying 100% of a population.

True

FalseCorrect Answer

Explanation:

Using 100% of a population is ideal, but it can be very expensive to gather data from an entire population.

QUESTION 21 OF 40

Data and business objectives might not align for a number of reasons. Which of the following issues can prevent alignment? Select all that apply.

Data visualization

Data integrity

Insufficient dataCorrect Answer

Sampling biasCorrect Answer

Explanation:

Insufficient data and sampling bias can prevent alignment.

QUESTION 22 OF 40

Fill in the blank: As a data analyst, you need to verify that your data is _____ to ensure your analysis and conclusions are accurate.

complete and validCorrect Answer

manipulated and replicated

private and valid

manipulated and valid

QUESTION 23 OF 40

A data analyst is given a dataset for analysis. To use the template for this dataset, click the link below and select “Use Template.” Link to template: June 2014 Invoices OR If you don’t have a Google account, download the CSV file directly from the attachment below. Which of the following has duplicate data?

Data for Symteco on 2/21/2014

Data for Symteco on 5/20/2014

Data for Valando on 1/1/2014

Data for Valando on 2/18/2014Correct Answer

QUESTION 24 OF 40

A clothing manufacturer wants to learn more about why their consumers have purchased the brand’s products. How should this manufacturer conduct their survey?

Send the survey to their least frequent customers

Send the survey to a representative sample of their customersCorrect Answer

Send the survey to customers who have purchased more than one product

Send the survey to random people who buy clothes

QUESTION 25 OF 40

A car dealership gathers data about their entire customer population. They decide to conduct a survey to understand why their customers chose their dealership. They send out an email to all customers who have purchased more than two vehicles in the past five years. What does this scenario describe?

Unbiased sampling

Random sampling

Sampling biasCorrect Answer

Geographically limited sampling

QUESTION 26 OF 40

What can jeopardize data integrity throughout its lifecycle? Select all that apply.

Insufficient data

MalwareCorrect Answer

System failuresCorrect Answer

Human errorCorrect Answer

QUESTION 27 OF 40

A data analyst needs to migrate data from a server located at their company's headquarters to a remote site. This can lead to what type of data integrity issue? Select all that apply.

Data cleaning

Data manipulation

Data replicationCorrect Answer

Data transferCorrect Answer

QUESTION 28 OF 40

A data analyst, working for a publishing company, gathers a dataset which includes all books sold in the United Kingdom over the last three years. However, they decide to generate new data that represents global book sales. What type of insufficient data does this scenario describe?

Data from only one source

Data that is outdated

Data that is geographically limitedCorrect Answer

Data that keeps updating

QUESTION 29 OF 40

A car manufacturer wants to learn more about the brand preferences of electric car owners. There are millions of electric car owners in the world. Who should the company survey?

A sample of all electric car ownersCorrect Answer

A sample of car owners who have owned more than one electric car

The entire population of electric car owners

A sample of car owners who most recently bought an electric car

QUESTION 30 OF 40

What best describes a sample size?

A subset of the population excluding outliers

A subset of the population between the 25th and 50th percentile

A random subset of the population

A subset that is representative of the population as a wholeCorrect Answer

QUESTION 31 OF 40

Fill in the blank: In order to have a strong and thorough analysis, a data analyst must verify _____.

data manipulation

data engineering

data integrityCorrect Answer

data replication

QUESTION 32 OF 40

You are working for a global technology company. You have a dataset with the company’s total cell phone sales by country from 2015 to present. Based on the data you have, what questions are you able to answer?

What was the effect on sales when a new phone model was launched?

What countries have the most cell phone sales in the past three years?Correct Answer

What was the effect on sales when new phone features were introduced?

What are the mean cell phone sales for each country since 2010?

QUESTION 33 OF 40

A data analyst is working on a project around a national supply chain. They have a dataset with lots of relevant data from about half of the country. However, they decide to generate new data that represents the entire nation. What type of insufficient data does this scenario describe?

Geographically limited dataCorrect Answer

Data that keeps updating

Outdated data

Data from only one source

QUESTION 34 OF 40

A company has multiple retail chain stores. Each store’s database is located onsite and used for various purposes. Which of the following processes could compromise data integrity?

Data transfer

Data gathering

Data replicationCorrect Answer

Data cleaning

QUESTION 35 OF 40

A data analyst is given a dataset for analysis. To use the template for this dataset, click the link below and select “Use Template.” Which of the following are limitations of this dataset? Select all that apply.

Identifying the best paying client between January and November of 2014

Identifying the most profitable clients between January and November of 2014Correct Answer

Identifying the worst paying client between March and December of 2014Correct Answer

Identifying the least profitable clients between January and November of 2014Correct Answer

QUESTION 36 OF 40

A high school principal is estimating the total number of students that will attend an upcoming event. She assumes that the older students are unlikely to attend and decides to only survey the first-year students. What issue will the principal face when calculating her estimation?

The sample is too small.

The sample should be the older students.

The sample exhibits sampling randomness.

The sample exhibits sampling bias.Correct Answer

QUESTION 37 OF 40

Fill in the blank: _____ is the process of changing data to make it more organized and easier to read.

Data replication

Data transfer

Data gathering

Data manipulationCorrect Answer

QUESTION 38 OF 40

A company is trying to learn more about their customer base. They would like to conduct a survey to understand why their customers chose their brand. How should the company survey its customers?

Conduct a survey with customers who have purchased more than five products

Conduct a survey with a representative sample of their customer populationCorrect Answer

Conduct a survey of customers who purchased a different brand

Conduct a survey of customers that live in high-income areas

QUESTION 39 OF 40

A candy manufacturer finds an even distribution of sales across all age ranges of customers who purchase their products. The manufacturer decides to conduct a survey to learn more about its customer base. Due to age requirements, they can only send the survey to customers who are 21 years or older. This scenario can be described as what?

Sampling biasCorrect Answer

Down sampling bias

Unbiased sampling

Upsampling bias

QUESTION 40 OF 40

A data analyst retrieves a sample of their data that is roughly representative of the population as a whole. They realize that there will be some error in their sample results because they didn’t sample the entire population. What is this error called?

Margin of error

Sampling error

Mean squared error

Population errorCorrect Answer

Ready to test your recall?

Fill in the blank: Data _____ refers to the accuracy, completeness, consistency, and trustworthiness of data throughout its life cycle.

Integrity

analysis

sampling

replication

How confident are you in this answer?