NEW
Font size
Worksheets#3 CIW Data Analyst - Certification Prep
Total questions: 54
Worksheet time: 2hrs 48mins
Which of the following data protection policies are not defined in the GDPR?
Right to process the data at any time
Right to access everyone's data
Right to file complaints about the data loss
Right to get the copy of the stored data
What is the goal of a data analyst?
To help detect errors, connectivity, security threats, and so on
To help create more systematic processes
To help manage large-scale emergency issues and small-scale issues
To help retain long-term customers and knowing their value
What kind of database is governed by the idea of independent collections of data created by employees using spreadsheets, word processing applications, or email contact lists?
Shadow
Centralized
Customer
Marketing
The first step in obtaining good data, in order to make more optimal business decisions, is:
analyzing data
using data
processing data
capturing data
Which data structure elements are referred to as fields or members?
Record
Hash table/map
Queue
Tree
As a data analyst, your feelings toward "data silos" are:
they make it difficult to manage data.
as long as there is a database manager for each, they are acceptable.
they are good at providing a "snapshot" as to how each department is doing.
they are an excellent way to back up data.
Examples of structured data are
Last name, email address
phone number, address
zip code, birthdate
all of these
As a newly hired data analyst, you are reading about Big Data which is often defined in terms of three V's: volume, __________, and variety.
volatility
value
velocity
Visibility
Which approach is applied by an organization under unpredictable situations when they face security issues with their datasets?
Reactive
Data consolidation
Data propagation
Proactive
You make a proposition asking your manager to move the company's database from a local server to a cloud-based server. Which of the following will you use to support your proposition?
Cloud-based applications are difficult for adapting business needs.
Cloud-based applications increase ownership costs.
Cloud-based applications provide more infrastructure flexibility and scalability.
Cloud-based applications offer less delay in latency than a close proximity local server.
Working as a senior data analyst, a co-worker approaches you and asks you about the main difference in working with cloud-based data. How would you most likely respond?
It is simply a server that is located in another part of the world.
When you talk about the cloud you are not talking about physical computers at all.
The cloud means accessing a computer from the Internet and there is no advantage to doing that.
It is a distributed model of Internet-based computing, where computers and other devices use shared resources, data, and information.
Your boss asks you if there are any reasons why a company would not move their data to the cloud and you respond:
While the security on cloud servers is better than those of an in-house data facility, they require too many policies for access to be documented by the acquiring company.
The physical proximity of a local server will offer less delay and the split-second advantage of the local server may be a competitive advantage to some companies.
It is much costlier to keep data in the cloud as several people need to be paid to watch over the servers for inclement weather that may affect their power source.
Cloud servers and migration are so standardized that it is actually very difficult to move data to the cloud and for this reason, alone most companies do not do it.
In which vendor lock-in type will proprietary software only work in a particular vendor's cloud environment?
Tools
Platform
Data
Software
Which of the following correctly describes Hadoop?
It is a term used to describe the explosive growth in various types of data in our everyday lives.
It is a software tool used for distributed processing
It is a programming language useful in statistical computing and graphics
It is a popular delivery model for a range of business applications.
You would like to analyze data by using the most reliable and scalable software available. Which of the following will you select and why?
MySQL, because it has the most extensive support network
Apache Hadoop, because it is open-source, reliable, and scalable
Oracle, because it has been around the longest
Microsoft Access, because it is the database with which you are most familiar
What are the challenges faced by an organization while processing and managing large datasets?
Data architecture and data relationships
Data modeling and data organization
Data security and data integrity
Data accuracy and data consistency
You are asked to analyze the preferences and purchasing habits of millions of customers. What is the most likely reason to need this analysis?
To meet shareholder expectations
To improve the consumer's shopping experience
To build a better workplace
To develop new products
Why is there a need to change procedures to deal with Big Data?
Big Data only consists of large storage files hence managing them requires better technology.
All Big Data are data silos and need special methods to be extracted.
The only resource for this type of data is social sites so we need enhanced technology to extract data from there.
The vast scale of Big Data requires the development of new technologies and methods that we did not need for smaller datasets.
Which of the following will be the next stage in the data life cycle after the data extraction and data aggregation?
Data integration
Data reporting
Data analysis
Data normalization
Which of the following will help in measuring the average number of days that the company will take to collect revenue after a sale?
Days Sales Outstanding (DSO)
Days Inventory Outstanding (DIO)
Days Sales of Inventory (DSI)
Days Payable Outstanding (DPO)
What is the objective behind obtaining sales data?
To know the source of the data and authenticity of the data
To make projections of revenue
To determine who has ownership of data in a given department
To gain hands-on knowledge of the data
During which phase of data analysis is data gathered from various sources?
Discovery
Customer service
Delivery
Execution
The third step in obtaining data is to gain hands-on knowledge of the data. This can best be accomplished by which of the following?
Building a database to capture the information you want to understand
Hiring an outside company to relay the knowledge of the data
Conducting one-on-one interviews with owners of data
Sending out questionnaires to customers
As a business supplier, you strive to create and maintain an excellent ongoing relationship with your customers. Which of the following is a measure of the success of this activity?
Customer loyalty
Customer satisfaction
Customer retention
Customer inertia
As a data analyst, your responsibility to the company is to identify areas for improvement, mitigate risks, and better engagement with buyers. For this, you need to have a proper understanding of the organization's customers. Which aspect of a Customer Relationship Management (CRM) system will help you accomplish this objective?
Improvement in the sales and marketing processes
Gathering customer insights
Segmentation of customers for better targeting
Improvement in customer service
While looking for a product on your company's Website, the customer also gets suggestions for similar products on the basis of their purchase history, preferences, and other activities. Which of the following terms correctly relates to this process?
Up-selling
Cross-selling
Pain point
Segmentation
As a data analyst, what would be the next strategy that you would suggest to your company after completing the marketing strategy for attracting customers through campaigns and generating leads from databases?
Generating sales reports
Fulfilling orders
Delivering products
Training customers
As a junior data analyst, you want to select the CRM system that will help increase customer loyalty and retention. What are the points that you will explain to your senior officer about CRM and its importance?
It helps you motivate the staff of the company so that they work with more dedication and determination.
It provides an effective way to send out mass mailings to the general public about the discounts your company is going to offer.
It accesses the customer data, such as addresses, so that you can send coupons to all the customers every month.
It helps improve the quality of services rendered and tailor services to meet customers' personal needs.
During a meeting, you explain to your co-workers that the goal of a CRM should be to minimize the churn rate. It can be defined as:
the rate at which customers and clients of your company cut ties in a given time period.
the amount of money spent to acquire new customers in a given time period.
the number of new customers acquired per month or another specified time period.
the turn-over rate for the customer acquisition team in a given time period.
With CRM, customer information will be stored and made available in a centralized repository that is constantly monitored and updated. How does this affect the sales and marketing departments?
The lines between these two departments are blurred as all salespeople become marketing employees.
Access to customer records is simplified, making things more efficient.
The individual sales and marketing people must share their information with their coworkers.
Sales departments are further distanced from marketing departments.
As a data analyst at a large company, one of your co-workers asks you how Hadoop can store large files across many different machines. You reply:
MapReduce stores large files across many different machines.
HDFS, which stands for Hadoop Distributed File System, stores large files across many different machines.
Hadoop Common, also known as Hadoop Core, stores large files across many different machines.
Hadoop YARN stores large files across many different machines.
Hadoop takes data, processes it using the input format and then:
loads data from its source
computes splits for each file.
arranges data as per key-value pair.
converts data into key-value pairs.
What is a computer environment?
A combination of data from multiple sources
A combination of hardware and software used to perform functions
An environment where users get free access to a software's code
A model for the visual representation of data
What is the R Project's greatest asset?
Its flexibility to be a fully comprehensive language that can run any type of data analysis that is required in a few lines of code.
Its ability to "scrub" data and change file formats.
Its ability to link databases across the globe via the Internet.
It is relatively cheap compared to other software programs.
The R Project is not only a programming language but an "environment" as well. What is an "environment"?
It encompasses the fact that it is a unified and coherent system, rather than an unplanned combination of tools.
It is comparable to an operating system.
It is the same as a graphical user interface - it is a screen, more or less, on which to work.
It can be compared to a suite of different products that work together.
As a data analyst, you understand that the R Project is different than OpenRefine and Tableau Public because:
the R Project requires HTML or C++ to run.
the R Project can run statistical analysis but cannot produce graphs.
the R Project is a programming language and software environment.
the R Project uses VBA and the others use SQL.
Because R is a programming language, a data analyst can write scripts that make data analysis:
transferable to other programs.
programmed in JavaScript.
customizable, replicable, and updatable.
Time-sensitive.
Your boss asks you how will you share the charts you created in Graph-R with your co-workers. What will you inform him?
The charts can't be shared with the co-workers but you can write a description of the graph.
Graph-R will display the charts on the Internet and you will give the URL to your co-workers.
Everyone can download Graph-R and then they will be able to open your graph.
The charts created in Graph-R can be saved as a .PNG, .JPEG, .BMP, .GIF, or copied and pasted into other programs.
Since R is an open-source project, so we do not have to worry about any:
Security.
Updates.
customer support.
monthly charges.
After creating a Graph-R, you want to keep a copy of it on your desktop for later use. Which of the following processes is required to accomplish the task?
Creating a copy on the centralized database
Uploading it to the cloud
Writing a script to save it
Copying it to the clipboard
High-level graphing commands, which can be executed in R, produce a new plot possibly with:
additional points and lines.
labels, axes, and titles.
additional labels.
information from an existing graph in real-time.
You are modifying R's source code to meet the requirements of your company. Which of the following regulates the extent of your modifications?
Federal Information Security Management Act
Federal Trade Commission
General Public License Rules
General Refine Expression Language
A sales improvement meeting is held at your company. Your manager has included the customer service team. What is the reason for inviting them?
All the departments will get to know each other which will enhance their professional relationships.
The customer service team has direct contact with customers which can help in providing important data.
In a successful company, there is no need for a dedicated customer service department and all other departments will provide customer service.
All the departments will now do sales for the company.
A sales representative at your company is making phone calls, sending out emails, and scheduling appointments. However, appointments are getting canceled at the last moment. Which of the following will effectively increase the outcome as it relates to the effort?
Send customers notifications of the specials that the company is offering.
Ask customers again and again to buy the products.
Ask for a penalty on the next cancellation.
Block the customer so they can't access the company's site.
As a senior manager, you want to keep track of the short-term and long-term goals of your employees. Which of the following would you use for this analysis?
Indicators
Bell curve
Outcome
Effort
During a review with a salesperson, you provide a statistical report that shows he is not doing well. The salesperson is confused, as all the customers he meets say that he is a very nice person, even though they do not buy anything. What is the problem?
The salesperson is simply not performing as he should.
The company is looking at a different time period than the salesperson.
The salesperson is looking at performance-based results and the company is looking at outcome-based results.
The salesperson is disillusioned; the customers are clearly not happy with him.
As a data analyst at your company, you ask the customer service representatives to start recording their calls with customers. Why you want to do that?
To review these calls to analyze the interactions with customers
To call the customers who did not make a purchase back and offer them a better deal
To call the customers who made a purchase and thank them
To make sure protocol is being followed 100 percent of the time
You are a data analyst for a small company and one day you take an iPad and interview customers who come in and out of a local grocery store, about what they are buying. What type of research are you conducting?
Tertiary
Secondary
Primary
Customer service
The purpose of giving "instant incentives" to people who visit your site is to:
show them some things in life are free.
meet daily sales goals.
gather data about the customers.
differentiate your brand from your competitor's site.
Which of the following is an example of secondary data?
An interview with a customer buying the product
Statistics from a Website
A survey from the customers
The recording of customer opinions by a company's employees
As a data analyst, you are preparing a presentation report. You want to add the statistics showing the profit that the company will make after completing the proposed project successfully. Which of the following is the correct way to help the investors understand all aspects of the topic you are presenting?
By using a line chart to present the statistics report
By highlighting the images with the help of animations
By discussing the team members who are going to work on the project
By presenting statistics with both positive and negative impact
As a data analyst, you need to collect accurate, unbiased data in order to establish a benchmark of the services provided by the company. Which technique should you use?
Contacting every customer through phone call
Conducting online/mobile surveys
Analyzing Web logs
Analyzing the sales report
Which of the following examples can you use to help your team understand secondary data
Third-party Websites
Interviews
Polls
Surveys
Which of the following statements explains the difference between primary research and secondary data?
Primary research is obtained by gathering the data in-house, whereas secondary data can be found by accessing third-party tools and Websites.
Primary research is gathered in the initial phase of a project, whereas secondary data is obtained later, to confirm the primary research.
Primary research is obtained from licensed databases, whereas secondary data is available for free.
