Introduction to Data Analytics for Business
Week 2 Quiz Answers
Q1) What type of file normally stores two dimensional data with column and row breaks, identified using special characters?
Refer to the following video for a refresher: video 1.
- XML File
- Log File
- Delimited Text File
- Excel File
Q2) What term best describes data storage that is optimized for handling front-end business operations?
Refer to the following video for a refresher: video 1.
- Online Analytical Processing ( OLAP )
- Document Store
- Online Transactional Processing ( OLTP )
- Hadoop Distributed File System ( HDFS )
Q3) Suppose you are a software developer looking for an online environment to help you rapidly build and scale applications. Which of the following services would best accommodate your needs?
Refer to the following video for a refresher: video 2.
- Software as a Service ( SaaS )
- Infrastructure as a Service ( IaaS )
- Development as a Service ( DaaS )
- Platform as a Service ( PaaS )
Q4) Which of the following statements about Cloud computing are true? (select all that apply)
Refer to the following video for a refresher: video 2.
- Cloud computing is more secure than a company’s data center
- Cloud computing is needed for handling Big Data
- Cloud computing can allow cheaper and more scalable operations
- Cloud computing outsources all of a company’s data operations
- Cloud computing speaks to where data is stored or manipulated
Q5) Suppose your objective is to build a predictive model that can be used to recommend products to customers in real-time based on their navigation on your web site. Which of these technologies would be most critical in helping you achieve this objective?
Refer to the following video for a refresher: video 3.
- Hadoop Distributed File System ( HDFS )
- In-Database Analytics
- In-Memory Computing
- Data Federation
- Data Virtualization
Q6) Suppose you are a data analyst working on a project to show why sales in a particular region are down relative to other regions. Your job is to figure out what’s going on, find a good way to show the data, and produce a report that can be automated to go out weekly to track progress on any actions that are taken. You anticipate that only descriptive analytics will be needed for this project, and you’re working from a data set that has been prepared by your partners in IT.
Which of the following classes of tools are you most likely to use directly in this project? (select all that apply)
Refer to the following video for a refresher: video 5.
- Standard reporting
- Data visualization & exploration
- Database systems
- Dashboarding
- Statistical modeling
Q7) Suppose you’re a data analyst and you’re traveling to a conference. There’s a straightforward but critical ad-hoc analysis you need to accomplish, but you’re not certain how much internet connectivity you’ll have during your trip. You also haven’t decided which of your desktop tools you’ll use in the analysis.
Which of the following process methodologies would work best for your situation?
Refer to the following video for a refresher: video 6.
- Downstream Integration Approach
- Intermediate File Approach
- Direct Connection Approach
Q8) For the following 9 questions, consider the set of relational database tables below, illustrated using the shorthand we introduced in the module.
For simplicity, assume that a phone number is a permanent attribute of the subscriber and that subscribers on both the “to” and “from” sides of calls are included in the database.
What kind of key best describes the primary key of the PLANS table ?
Refer to the following video for a refresher: video 4.
- Natural
- Surrogate
- Composite
Q9) Which table, if any, has a Composite Primary Key?
- SUBSCRIBERS
- PLANS
- CALLS
- DEVICES
Q10) Select all the fields which COULD have foreign key relationships in THIS model:
- Device_SN
- Device_Type
- Phone_Number
- From_Number
- End_Time
- Plan_ID
- Model
- Manufacturer
- To_Number
Q11) In the next 6 questions, define the relationship between the tables.
Refer to the following video for a refresher: video 4.
SUBSCRIBERS to PLANS
- One to One
- One to Many
- Many to One
- Many to Many
- No direct relationship
Q12) CALLS to SUBSCRIBERS
- One to One
- One to Many
- Many to One
- Many to Many
- No direct relationship
Q13) DEVICES to SUBSCRIBERS
- One to One
- One to Many
- Many to One
- Many to Many
- No direct relationship
Q14) CALLS to DEVICES
- One to One
- One to Many
- Many to One
- Many to Many
- No direct relationship
Q15) PLANS to CALLS
- One to One
- One to Many
- Many to One
- Many to Many
- No direct relationship
Q16) DEVICES TO PLANS
- One to One
- One to Many
- Many to One
- Many to Many
- No direct relationship
Q17) Is this data model in third normal form?
Refer to the following video for a refresher: video 4.
- Yes
- No
0 Comments