When Marco returned from a vacation in Hawaii, he uploaded several pictures and video clips that he took at the beach. After editing some of the pictures using photo editing software, he opened a video-maker program to edit footage. Shortly after he opened the video-maker, the program stopped responding.

Which tool or method is best for Marco to use to solve this issue?

13/15  that’s 87%

RETAKE

13 questions were answered correctly.

2 questions were answered incorrectly.

1

Which of the following correctly describes a record?

• A record is a flat file.

• A record consists of one field.

• A record is a set of data organized in columns and rows.

• A record appears as a row in a table.

RATIONALE

A record appears as a row in a table. An attribute or a field appears as a column in a table.

CONCEPT

 Introduction to Databases

Report an issue with this question

2

When Marco returned from a vacation in Hawaii, he uploaded several pictures and video clips that he took at the beach. After editing some of the pictures using photo editing software, he opened a video-maker program to edit footage. Shortly after he opened the video-maker, the program stopped responding.

Which tool or method is best for Marco to use to solve this issue?

• Safe Mode

• System Restore

• Task Manager

• Help System

RATIONALE

Task Manager is the best option for Marco because it enables users to view currently-running tasks, and to shut down any program that isn’t working properly. Marco does not need to restore his computer to a previous setting, or to turn on Safe Mode to protect his computer from harm.

CONCEPT

 Troubleshooting with Microsoft Windows

Report an issue with this question

3

Luis has an organized system of icons, files, and folders on his computer’s home screen.

Which element of the Microsoft Windows operating system is Luis using?

• Device Manager

• Control Panel

• Desktop

• Start Menu

RATIONALE

The description refers to the Desktop of the Microsoft Windows operating system on Luis’ computer.

CONCEPT

 The Microsoft Windows Operating System

Report an issue with this question

4

Which of the following is NOT a challenge of data warehousing?

• Testing

• Scheduling data pulls

• Communicating requirements

• Cost

RATIONALE

Cost, communicating requirements, and testing are challenges of data warehousing. Scheduling data pulls is not a challenge. Scheduling data pulls is an operational process that uses the data warehouse.

CONCEPT

 Trends and Challenges with Data Warehousing

Report an issue with this question

5

Merle cannot open documents created by one program on a machine that does not have the program installed.

Merle is dealing with a __________.

• hardware problem

• network connectivity problem

• file management issue

• software productivity issue

RATIONALE

Merle’s problem is a file management issue. A common file management issue is the inability to open a Microsoft Word document on a Mac computer.

CONCEPT

 Troubleshooting with Microsoft Windows

Report an issue with this question

6

An enrollment counselor queries the following database table to identify undergraduate accounting majors. 

How many records are displayed in the query?

Student_ID	Student_Name	State	Birth_Year	Degree	Major
44352	Anderson, Tiffany	IL	1994	Graduate	Economics
98425	Avendano, Marco	MN	1994	Graduate	Accounting
67512	Barrett, Eliza	IL	1992	Graduate	Mathematics
97156	Brown, Amy	MN	1994	Undergraduate	Pre-Medicine
36401	Elissa, Jose	WI	1997	Undergraduate	Accounting
97315	Grey, Nicole	VT	1999	Undergraduate	Theatre
54074	Harris, Blake	IL	1992	Undergraduate	Accounting
64782	Jensen, Allan	MN	1990	Graduate	Economics

• 1

• 2

• 3

• 4

RATIONALE

The query will display only the records that fit the criteria of undergraduate degree and an accounting major. Only two records fit both criteria (Jose Elissa and Blake Harris).

CONCEPT

 Managing Data in a Database

Report an issue with this question

7

Which data type should be classified as a date/time?

• 04-15-12 15:25

• 0.01

• € 20

• $10.59

RATIONALE

“04-15-12 15:25” is a date and time (in a 24-hour format). “0.01” is a number. “$10.59” and € 20 are currency data types.

CONCEPT

 Designing a Database

Report an issue with this question

8

Which productivity software is used to create written memos or reports?

• PowerPoint

• Excel

• Word

• Access

RATIONALE

Word is the most common productivity software used to create a written memo or report.

CONCEPT

 Productivity Application Software

Report an issue with this question

9

Because a computer typically runs a variety of programs simultaneously, the role of the operating system is to ensure that all programs have access to the __________.

• power supply

• keyboard

• CPU

• monitor

RATIONALE

The CPU manages the commands it receives from the computer software. When a computer is multitasking, the software must access the CPU so that it gets the resources it needs to execute tasks and instructions.

CONCEPT

 Operating Systems

Report an issue with this question

10

Identify the statement about Windows tasks that is FALSE.

• The boot process is the process for powering off a computer.

• Users log into their accounts on the Welcome screen, before Windows is ready to use.

• To launch an application, click the Windows icon, select “All Programs,” and then click an application.

• A common way to shut down the computer’s operating system is by using the Start menu.

RATIONALE

A common way to shut down the computer’s operating system is by using the power icon in the Start menu. Clicking on the Windows icon, and then selecting “All Programs” will launch an application. The Welcome screen prompts users to log into their accounts before accessing Windows. However, the boot process is NOT the process for powering off a computer. The boot process is used to power on a computer.

CONCEPT

 Using the Microsoft Windows Operating System

Report an issue with this question

11

Select the scenario that describes a top-down approach to data warehouse design.

• Cathy’s Cards and Gifts, which has three stores, creates data marts for its sales, marketing, and delivery departments to study the possibility of establishing a new store.

• Cynthia’s Florals, which is dealing with debt, creates new data marts for the service, delivery, and sales departments to develop a strategy to stay in business.

• Crawford’s Fabrics, which wants to expand its operations, combines data from the purchasing and sales departments into a central database, to be divided into new data marts as needed.

• Connor’s Meat Market, which just opened, creates data marts to track the sale of each of the following meats: beef, pork, lamb, and fish.

RATIONALE

Crawford’s Fabrics uses a top-down data warehouse design. It began collecting data, then divided what it collected into data marts, as needed. The other answer involve a bottom-up data warehouse design. Bottom-up design builds data marts from different departments, then merges the data marts into a single data warehouse. 

CONCEPT

 Data Warehousing

Report an issue with this question

12

Paul wants to present information about a new product at the upcoming national sales meeting.

Which productivity software should Paul use?

• Microsoft Excel

• OpenOffice Impress

• IBM DB2

• Google Docs

RATIONALE

OpenOffice Impress is presentation software from Apache that Paul can use for the meeting.

CONCEPT

 Productivity Application Software

Report an issue with this question

13

__________, developed by Apple, can be used to calculate and organize financial information.

• Keynote

• Calc

• Excel

• Numbers

RATIONALE

Numbers, developed by Apple, can be used to calculate and organize financial information. Numbers is a spreadsheet application that is part of the iWork productivity suite, along with Keynote and Pages. Numbers is available for iOS and Mac OS.

CONCEPT

 Selecting Software

Report an issue with this question

14

Which of the following is the FIELD in a database table?

• Name

• 6/5/1985

• Emily Walker

• beextraordinary@email.com

RATIONALE

6/5/1985, beextraordinary@email.com, and Emily Walker should appear in rows in a database table because they are parts of specific records. Name should appear as a column heading in a table, because it represents a field and indicates the type of information collected in the column.

CONCEPT

 Introduction to Databases

Report an issue with this question

15

Sarah is creating custom reports from her company’s database. 

Select the set of file types that Sarah will use to create these reports.

• .txt and .dat

• .csv and .pptx

• .tif and .db

• .sql and .xml

RATIONALE

The set of file types that Sarah will use to create these reports is .sql and .xml. 

CONCEPT

 Application Software File Types and Formats

Report an issue with this question