NEW
Font size
Worksheets#2 CIW Data Analyst - Certification Prep
Total questions: 54
Worksheet time: 2hrs 48mins
Which of the following steps involves discovering trends and patterns to illustrate new growth strategies for businesses in obtaining good data?
Analyzing data
Processing data
Using data
Capturing data
What is the purpose of using centralized data management in a Big Data company?
To reduce data integrity
To promote data redundancy
To eliminate data silos
To decrease data interpretation
As the company data analyst, you are asking the management team to consider a centralized database. Your argument for doing so is:
changes and updates to data will be reflected on the very next business day - thus improving turn around.
there will be lower data management costs since the database will reside on only one computer.
higher data accuracy and consistency, as well as lower data redundancy at a single location, means holding one main record of the data. This increases the ability to maintain data reliability.
it may not be convenient for all users, but it will be more convenient for you.
What are "data silos"?
They exist in "shadow" databases such as Microsoft Excel spreadsheets, emails and non-formal storage that make it difficult to manage data.
They are mainframe databases that contain the information required for analysis.
They are physical ledgers that contain important sales transactions. These ledgers must be put into databases to be relevant.
They refer to fixed data that is shared throughout a company.
Your organization wants to advertise its products. As a data analyst, what kind of data will you analyze to make the advertisement most effective?
Big data
Marketing data
Unstructured data
Accounting data
You are working as a data analyst in a company that provides a ride sharing service. Which source will provide the best information on a customer's physical location?
Mobile platform
E-commerce site
Social media platform
Customer data
What is the General Data Protection Regulation (GDPR)?
A provision to establish national standards for electronic health care transactions and national identifiers for health plans
An act that prohibits European firms from transferring personal data to overseas jurisdictions with privacy laws
A legal framework that sets guidelines for the collection and processing of personal data within the European Union (EU)
An act that contains descriptions of federal agency databases maintained on individuals, and the rules the agencies must follow to assist individuals
You are a data analyst and you need to review the format of printed bills going out to customers. You notice that some bills have been paid by credit card and show the full credit card number and other information of your clients. You recommend that this information be masked or truncated. Why would you give this recommendation?
To remind customers that they used a credit card
To simplify the display to customers
To prevent customers from paying the bill twice
To prevent theft of the information
As the company Data Analyst, you have been named in a lawsuit against your company. Other employees of the company are upset over the findings from a recent company network traffic usage report. Which of the following best describes the reason for this situation?
Failure to publish positive comments along with employee complaints
Capturing video of employees working using hidden cameras
Failure to keep personal information collected private
Publishing an incomplete list of employee suggestions for network improvements
John is an entrepreneur and owns an ice cream shop. He created a new website and wants to track where customers are going on his webpage and how much time they are spending on each page of his website. What would be the best approach for John to take?
Analyze a customer satisfaction survey on facebook
Have employees contact customers who visited the site and interview them with questions about the website
Give customers a promotion by completing a short survey after visiting each page on his new website
Analyze click-through rates from weblogs
Cody is reading comments on his company’s Instagram page to see if there are changes to the customer service that has been provided in the past year. What kind of data are customer comments?
Centralized Data
Web site traffic reports
Unstructured Data
Structured Data
HAZMAT PARTNERS LLC creates a new software for complying with government regulations regarding the management of hazardous materials. They sell their software to medium and large companies that manufacture products. Their brand managers are deciding if they should develop and release a new software line of products for complying with safety regulations. What kinds of internal data would help them make this decision?
Transaction data on sales of their current products
Surveys on the customers demographics, needs, and preferences
Sales leads from trade shows and magazine advertising
Company marketing expenses
Michael Jackson Jr. opened a pickleball supply company a month ago. After looking at his first month’s sales, he decides to stock twice as many pickleballs as pickleball racquets this month. This is an example of:
Reading Data
Using data
Organizing Data
Capturing Data
A clothing company just completed a major project update to their website using interactive and dynamic content. Now, they want to measure how effective the website is along with their customers' expectations for their website. Which of the following would be the best approach to collect this data?
A survey on Facebook
Have customer service representatives contact customers who have visited and interview them
Provide incentives to customers to complete a short usability survey after visiting the website
Analyze click through rates
What important information can be found by analyzing customer data?
Ways to make operating costs lower
A method to reach the right customers
Projected revenues for next year
Which types of customers buy certain products
What is an advantage to using centralized data?
A single location holding the main record to the data ensures consistency and accuracy
Small changes to a database do not affect centralized data
Duplicated data for back-up
Updates may take many days
What are some characteristics of Big Data?
It’s unstructured data
Huge amounts of data beyond the scope of old analytical tools
It’s being used to improve consumer’s shopping experience by analyzing preferences of millions of users
All of these
Why is Search Engine Optimization important to businesses?
It allows them to know their customer’s political opinions
It can maximize website traffic and use of their website through search engines
It creates a call to action
It allows them to search shadow databases
As the company Data Analyst, you have been named in a lawsuit against your company. Other employees of the company are upset over the findings from a recent company network traffic usage report. Which of the following best describes the reason for this situation?
Failure to publish positive comments along with employee complaints
Capturing video of employees working using hidden cameras
Failure to keep personal information collected private
Publishing an incomplete list of employee suggestions for network improvements
John is an entrepreneur and owns an ice cream shop. He created a new website and wants to track where customers are going on his webpage and how much time they are spending on each page of his website. What would be the best approach for John to take?
Analyze a customer satisfaction survey on facebook
Have employees contact customers who visited the site and interview them with questions about the website
Give customers a promotion by completing a short survey after visiting each page on his new website
Analyze click-through rates from weblogs
Cody is reading comments on his company’s Instagram page to see if there are changes to the customer service that has been provided in the past year. What kind of data are customer comments?
Centralized Data
Web site traffic reports
Unstructured Data
Structured Data
HAZMAT PARTNERS LLC creates a new software for complying with government regulations regarding the management of hazardous materials. They sell their software to medium and large companies that manufacture products. Their brand managers are deciding if they should develop and release a new software line of products for complying with safety regulations. What kinds of internal data would help them make this decision?
Transaction data on sales of their current products
Surveys on the customers demographics, needs, and preferences
Sales leads from trade shows and magazine advertising
Company marketing expenses
Michael Jackson Jr. opened a pickleball supply company a month ago. After looking at his first month’s sales, he decides to stock twice as many pickleballs as pickleball racquets this month. This is an example of:
Reading Data
Using data
Organizing Data
Capturing Data
A clothing company just completed a major project update to their website using interactive and dynamic content. Now, they want to measure how effective the website is along with their customers' expectations for their website. Which of the following would be the best approach to collect this data?
A survey on Facebook
Have customer service representatives contact customers who have visited and interview them
Provide incentives to customers to complete a short usability survey after visiting the website
Analyze click through rates
What important information can be found by analyzing customer data?
Ways to make operating costs lower
A method to reach the right customers
Projected revenues for next year
Which types of customers buy certain products
What is an advantage to using centralized data?
A single location holding the main record to the data ensures consistency and accuracy
Small changes to a database do not affect centralized data
Duplicated data for back-up
Updates may take many days
What are some characteristics of Big Data?
It’s unstructured data
Huge amounts of data beyond the scope of old analytical tools
It’s being used to improve consumer’s shopping experience by analyzing preferences of millions of users
All of these
Why is Search Engine Optimization important to businesses?
It allows them to know their customer’s political opinions
It can maximize website traffic and use of their website through search engines
It creates a call to action
It allows them to search shadow databases
You were just hired as a data analyst for a large corporation. The first thing you do is to schedule a meeting with the sales and marketing departments. Why would you do this?
You will need to retrain both departments on how to do their jobs so that you can easily gather the data that you require from their departments.
Often, sales and marketing data are not synchronized and it is the role of the data analyst to try and harmonize this gap by merging them together.
You want to meet all the employees in the corporation so that you may find with whom you can work with to gather data.
These two departments often work against each other and in order to increase sales, you want to increase the competition between the two departments.
As the marketing head of the company, you started the process of identifying and targeting customers for more effective marketing campaigns. What is this process commonly known as?
Segmentation
Up-selling
Clustering
Cross-selling
Which of the following operations does OpenRefine perform with General Refine Expression Language?
Enhanced cloud hosting capabilities
Advanced data operations
Distributed processing
Original entry of transactions
Which feature of OpenRefine helps to get an overview of the Big Data as well as to maintain consistency between data?
Facet
Jsoup
Parse
Clustering
OpenRefine allows a user to take disorganized data and transform it from one format to another. Why is this important?
Because not all browsers support all formats of text
Because it allows a user to gather data regardless of formats
Because databases require the data to be in one specific format
Because datasets cannot be extracted unless they are of the same format
Which language would you want to be familiar with in order to perform advanced data operations in OpenRefine?
SQL
VBA
General Refine Expression Language
JavaScript
You are working in an organization where the need for data storage is increasing with every passing second. Which of the following will fulfill your requirements with a limited budget?
Hadoop
Supercomputer
Tableau Public
OpenRefine
How does Hadoop process huge amounts of data?
By leveraging dozens, hundreds or even thousands of computers
By using a supercomputer
By simplifying the format of the data
By breaking the data into datasets
PostgreSQL has developed strong features to boost performance. Which of the following is NOT one of those features?
Rule-based optimizer
Checkpoint support
Asynchronous commit
Value-based optimizer
Yahoo!, Facebook, eBay, and other social networking companies use Hadoop to:
display graphical interpretations of their data.
store and process a large amount of data.
edit and display documents in real-time.
generate XML site maps and metadata.
Hadoop Core refers to:
a resource management platform responsible for managing the other Hadoop resources.
a file system that stores large files across many different machines.
the collection of common utilities that support the other Hadoop modules.
a programming model for the parallel processing of large datasets.
In the Hadoop Environment, HDFS refers to:
a resource management platform responsible for managing the other Hadoop resources.
a file system that stores large files across many different machines.
the collection of common utilities that support the other Hadoop modules.
a programming model for the parallel processing of large datasets.
Hadoop YARN can be described as:
a resource management platform responsible for managing the other Hadoop resources.
a programming model for the parallel processing of large datasets.
the collection of common utilities that support the other Hadoop modules.
a file system that stores large files across many different machines.
In the Hadoop Environment, MapReduce is:
a file system that stores large files across many different machines.
a resource management platform responsible for managing the other Hadoop resources.
a programming model for the parallel processing of large datasets.
the collection of common utilities that support the other Hadoop modules.
These days, organizations are busy advertising, sending out press releases, and conducting various efforts to reach customers. How do they know these things work?
By using SQL queries
By analyzing Web logs
By asking customers to provide feedback
By analyzing network traffic
As a senior data analyst, you asked customer service representatives to track the next 100 calls they receive. They ask if you only want to track the positive calls or the negative ones as well. What would you reply and why?
Just the positive calls, as I would like to verify what we are doing right.
Just the negative calls, as these are the only ones on which we may improve
All calls, as every contact with a customer, is an opportunity for improvement
All calls, so that we may verify that protocol is being followed 100 percent of the time.
As a data analyst, one of the things you do on a daily basis is to seek opportunities. Information on a new product that your competitor is creating was recently obtained illegally and given to you. What should you do with that information?
You contact your competitor and let them know that you have this information and you ask them if the information is correct; you then decide on what to do next.
You think it is wrong to use this newly acquired data but instead of making that call, you give the information to your boss and let him make the call.
You rush your company to create a new product similar to the competitor's product and release it to the public first.
You remind yourself that being a good data analyst means remaining ethical and doing the right thing even if it means bypassing an opportunity.
Why data integration is important?
It provides a complete picture of KPIs, customers, production and supply chain activities, and so on.
It offers users the ability to enhance data using various displays and visuals
It ensures that the data which is loaded from the source to the destination after business transformation is correct.
It identifies key information related to an individual's or business's operation.
KMM, an automobile manufacturer, wanted to identify and fix defects in several lines of its cars. Traditional methods such as querying data or monitoring were too complicated and sluggish to determine the causes of problems. So, the company identified and fixed defects by mining data from several databases. Which method did the company use to accomplish the task?
Data protection
Data modeling
Data integration
Data life cycle management
Which of the following is not a building block used to construct a program?
Sequence
Segmentation
Iteration
Selection
What is a program?
A sequence of instructions constructed by using common building blocks
A process of how data is loaded from the source system to the data warehouse
A set of routines, protocols, and tools for building software and other applications
A pool of cloud infrastructure resources that offer enhanced cloud hosting capabilities
"The work that employees and representatives of an organization accomplish on a product, a project, and/or related assignments on a daily, weekly, and annual basis" is the definition of which of the following terms?
Outcome
Performance
Effort
Goal
Which of the following best describes this scenario?A sales representative works hard every day making phone calls, sending out emails, and scheduling appointments. However, the appointments are getting canceled at the last minute and there's no response to the emails.
The employee's performance is aligned with the company's outcomes.
The effort and outcomes are at acceptable levels.
The effort is there but the outcome is not.
Goals should be adjusted to create a feeling of success.
Which of the following statements is an outcome-based result?
Trying to meet the weekly goals for better work output
Asking customers if they are happy with the services
Making eye contact and expressing a friendly demeanor to customers
Processing orders to the customers with 100 percent customer satisfaction
You want to display the average distribution of an item and how several variables can affect it. Which of the following would you use for this analysis?
Capsa Free
Network traffic
Bell curve
Indicator
You are working as a sales manager in a company. One of your team members is working hard every day making phone calls, sending out emails, and scheduling appointments. However, the appointments are getting canceled at the last minute and there are no responses to the emails. In such a case, what method would you apply to track his progress?
Target process
Social media reach
Effort-to-outcome
Self-review
