Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Question 1 0 / 3.125 points

The key components of information systems are hardware, software, network, database, and users.

Incorrect Response

True

Correct Answer

False

Question 2 6.25 / 6.25 points

Please match the following choices to benefits or risks of upgrading the operating system for Zara.

__1__

Ongoing support from software vendors

__1__

Cross-store sales and improve customer services

__2__

Change the human-centered culture and DNA

__2__

Transition to the new system leading to disruption

__1__

Platform for future growth to online and global sales

__2__

Investments and ongoing spending on the upgrade

1.

Benefits

2.

Risks

Question 3 6.25 / 6.25 points

Which of the following options accurately describe the role or value of IT at a stock exchange?

Leasing technology services and selling data solutions to other companies

Enabling stock transactions

Limiting the liquidity of the financial market

Providing market information to individuals and institutions

Ensuring high speed and lower cost of the financial market

Question 4 3.125 / 3.125 points

Fill in the blank: The ___structure___ of Zara can be characterized by decentralized decision-making, vertical integration, and human-centered culture.

Question 5 6.25 / 6.25 points

In a newly launched video game, called "Pawfect Pals", users can raise their very own virtual pet. In the game, each virtual pet is unique and can only be assigned to a single owner. Although Basic users can only raise one pet, Premium users can raise up to five pets. If we were to represent this video game with an ER model, what would be the cardinality between the "pets" and "Basic users" and between the "pets" and "Premium users"?

1:1 / M;N

1:1 / N:1

1:N / 1:1

N:1 / M:N

1:N / M:N

Question 6 6.25 / 6.25 points

What is the primary key in the table representing a relationship in the ER model when the relationship has M:N cardinality?

Primary key from the N side

Primary key from the M side

Attributes in the relationship table

Combination of the primary keys from each side

Question 7 6.25 / 6.25 points

The following SQL statements were run on the below "Employee" table.

Employees

Fill in the blanks in the following view table after executing the provided SQL query on the "Employees" table.

Answer for blank # 1: AverageSalary (50 %)

Answer for blank # 2: 2000 (50 %)

Answer for blank # 3: Incorrect Response

(AverageSalary, 2000)

All the correct answers are not displayed for this Multi-Short Answer question.

Question 8 6.25 / 6.25 points

Match the following components for a computer with its descriptions.

__2__

Temporary data storage for keeping the data and applications while the computer is running.

__1__

The actual hardware that interprets and executes software instructions and coordinates how all the other hardware devices work together.

__3__

Permanent data storage for storing information for use at a later time

__5__

A tool we use to see, hear, or otherwise receive the results of information-processing requests.

__4__

A tool used to capture information and commands from the environment.

1.

CPU

2.

RAM

3.

Storage

4.

Input device

5.

Output device

Question 9 6.25 / 6.25 points

Which of the following action plans should be considered immediately after a crash occurring after an IPO? Select all that applies.

Implement ongoing upgrades and testing of the system

Rethink the the culture of the organization

Improve the backup system

Consult with external resources with more expertise

Seek a technical fix in-house

Question 10 3.125 / 6.25 points

A book store is considering two methods to store their book sales data: storing them in a single table and using a relational database. They have a total of 500 books, 100 customers, and 1000 transactions in their sales data.

The first method to store data in a single table will result in a table like the following:

The second method to store data as a relational database will result in three tables like the following:

Please calculate the total number of cells (excluding the row with column names) for each method.

Answer for blank # 1: 35,000,000 Incorrect Response

Answer for blank # 2: 5700 (50 %)

(7000, 5700)

Question 11 3.125 / 3.125 points

Moore's law has been remarkably accurate over the decades due to the empirical observation that the number of transistors in a chip doubles approximately every two years.

True

False

Question 12 0 / 6.25 points

Convert the given sound wave into binary representation. The sample rate is 1Hz, and each time sample should be represented using 4 bits. Skip time=0.

Answer for blank # 1: 10000011011001010001 Incorrect Response

Answer for blank # 2: Incorrect Response

Answer for blank # 3: Incorrect Response

(010100110111011001110011)

All the correct answers are not displayed for this Multi-Short Answer question.

Question 13 6.25 / 6.25 points

How much hard drive memory (in Bytes) is required to store "Cruella" movie? We assume the following.

Resolution: 1960 x 1080 pixels

24 fps

2h 13 minutes long

Color Depth: 30 bit

Choose the answer closest to your calculation.

2.5 x 1011

1.2 x 1012

1.5 x 1012

1.2 x 1013

2.0 x 1012

Question 14 6.25 / 6.25 points

What would be the number of cells in the view of the following queries in the database?

Original data

Song Title

Singer

Album

Hours of streaming

Weeks on Billboard Hot 100

Last Night

Morgan Wallen

One Thing at a Time

340

17

Flowers

Miley Cyrus

Endless Summer Vacation

400

19

Kill Bill

SZA

SOS

454

24

Calm Down

Rema & Selena Gomez

Single

1000

38

Favorite Song

Toosii

NAUJOUR

236

14

Ella Baila Sola

Eslabon Armado X Peso Pluma

Single

98

10

All My Life

Lil Durk feat. J. Cole

Almost Healed

36

2

Query

Select songs that were on the Billboard Hot 100 for less than 15 weeks and project 'Song Title', 'Singer', and 'Hours of streaming'

Answer: 12

Question 15 6.25 / 6.25 points

Finish the following SQL query that retrieves the total number of sales for each product category, sorted in descending order by the sales count, and display the sales count as "TotalSales" in the result. Write in the order of (A), (B), and (C).

Sales

product_id product_name category sale_amount

1 Laptop Electronics 1500

2 Phone Electronics 800

3 TV Electronics 2000

4 Shirt Apparel 500

5 Jeans Apparel 700

6 Shoes Apparel 900

Query:

Answer for blank # 1: AS TotalSales (33.33 %)

Answer for blank # 2: GROUP BY (33.33 %)

Answer for blank # 3: DESC (33.33 %)

Question 16 3.125 / 3.125 points

Fill in the blank:  ___vertical___ software is a type of software that can be used for a specific industry, such as a patient scheduling software and a film studio project management software.

Question 17 6.25 / 6.25 points

Imagine you are the owner of a popular ice cream shop called "Scoop & Joy." Your shop offers a variety of ice cream flavors to customers. Each customer can place multiple orders, but each order is associated with only one customer. Customers can buy more than one ice cream at a time.

If we were to represent this with an Entity-Relationship model, what would be the cardinalities between "Customers" and "Orders" and between "Orders" and "Ice cream flavors"?

Answer for blank # 1: 1:N (50 %)

Answer for blank # 2: M:N (50 %)

Question 18 0 / 6.25 points

A local book store is adopting a ERP (enterprise resource planning) system to better manage various aspects of a business, including inventory, track sales, process online orders, and maintain customer databases. The book store is known and loved for its unique book selections which are carefully hand-picked by its staffs every month.

Where would you place the ERP of this bookstore in the IT strategic grid?

Correct Answer

Factory

Strategic

Support   Turnaround