11. As a data analyst, you are working for a national pizza restaurant chain. You have a dataset with monthly order totals for each branch over the past year. With only this data, what questions can you answer?
- Which region had the highest sales over the last two years?
- Which branch will be the most profitable over the next year?
- What was the most popular item on the menu?
- Which branch had the most orders in the last month of last year?
12. 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.
June 2014 Invoices - Sheet1
The data analyst is asked to find the average estimate for Symteco over the past three years. What limitation of the data makes this impossible?
- The data uses the wrong currency.
- The data is all from a single year.
- The data does not include Symteco.
- The data does not include estimates.
13. 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 outdated data.
- It is geographically limited data.
- It is data that keeps updating.
- It is data from only one source.
14. A restaurant gathers data about a new dish by providing free samples to parties of six or more diners. What does this scenario describe?
- Random sampling
- Unbiased sampling
- Geographically limited sampling
- Sampling bias
15. Which of the following processes helps ensure a close alignment of data and business objectives?
- Completing data replication
- Transferring data multiple times
- Maintaining data integrity
- Having data update automatically during analysis
16. What can jeopardize data integrity throughout its lifecycle? Select all that apply.
- Insufficient data
- Human error
- Malware
- System failures
17. 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 gathering
- Data manipulation
- Data transfer
- Data replication
18. 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?
- Which country had the smallest population in 2017?
- Which country had the greatest population in 2015?
- What was the reason for the population increase in a certain country?
- What was the population of a certain country in 2020?
Shuffle Q/A 2
19. 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.
June 2014 Invoices - Sheet1
Which of the following are limitations of this dataset?
- Identifying the most profitable clients between January and November of 2014
- Identifying the least profitable clients between January and November of 2014
- Identifying the worst paying client between March and December of 2014
- Identifying the best paying client between January and November of 2014
20. 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 owners
- The entire population of electric car owners
- A sample of car owners who have owned more than one electric car
- A sample of car owners who most recently bought an electric car
