Nov 23, 2024
HEP 456 Module 6 Section 14 Communication and Dissemination of The Findings Arizona State University
HEP 456 Module 6 Section 14 Communication and Dissemination of The Findings HEP 456: Health Promotion Program ā¦
Which of the following is a challenge of data war
ehousing?
Privacy concerns
Data originality
Cloud computing environments
A high reliance on data quantity
RATIONALE
It has become easy to collect data from a variety of sources and combine them to perform new forms of analysis. Some firms combine publicly-accessible data with information obtained from the government and other sources to create warehouses of data (about people and companies) for sale.
CONCEPT
Trends and Challenges with Data Warehousing 2
While saving a document to her hard drive, Connie’s computer screen suddenly changed to display an error message on a blue background. The error code indicated that there was a problem with her computer’s RAM.
Connie’s computer is affected by a(n) ______.
file compatibility issue
system performance issue
application error
hardware crash
RATIONALE
Connie’s computer is affected by a hardware crash. A computer can crash due to faulty hardware. Computer hardware can fail after long periods of use.
CONCEPT
Troubleshooting with Microsoft Windows 3
Select the scenario that describes a top-down approach to data warehouse design.
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.
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.
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.
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.
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
Identify the statement about Windows tasks that is FALSE.
The most common way to open an application is by using the Start menu.
You can view all files on a computer by using File Explorer (formerly known as Windows Explorer).
Clicking on the Internet Explorer icon is a shortcut way to display all Microsoft Office programs.
Pressing the power button begins the boot process.
RATIONALE
Pressing the power button begins the boot process. You can view all of the files on a computer by using File Explorer (formerly called Windows Explorer). The most common way to begin an application is by accessing the Start menu. However, clicking on the Internet Explorer icon is not a shortcut way to display all Microsoft Office programs. Clicking on that icon will open the Internet Explorer web browser.
CONCEPT
Using the Microsoft Windows Operating System 5
Select the data type that can only be classified as a number.
13:30
83.152
11/10/11
$1,253.12
RATIONALE
The appropriate type for “83.152” is number. The appropriate type for “$1,253.13” is currency. The appropriate type for both “13:30” and “11/10/11” is date/time.
CONCEPT
Which statement describes an example of database software?
Microsoft Word enables users to write and edit text documents.
Microsoft PowerPoint enables users to create animated presentations that can be projected on a screen.
Microsoft Excel enables users to perform calculations and statistical analyses.
Microsoft Access enables users to create, store, and retrieve records.
RATIONALE
Microsoft Access is a database management system used to store and retrieve records. It combines a relational database with a graphical user interface and software-development tools.
CONCEPT
Productivity Application Software
7
Jeremy wants to buy a horse. He is looking for a brown Tennessee Walker that is at least five years old AND at least 15 hands tall.
How many records will be displayed in response to his query?
COLOR BREED HANDS AGE
| Brown | Tennessee Walker 14.5 | 7 |
|---|---|---|
| Black | Tennessee Walker 16 | 5 |
| Brown | Thoroughbred 16.5 | 8 |
| Brown | Tennessee Walker 14 | 5 |
| Brown | Tennessee Walker 15.5 | 2 |
| Black | Thoroughbred 15 | 3 |
COLOR BREED HANDS AGE
Black Tennessee Walker 15 9
1
2
0
3
RATIONALE
The result of the query that returns data that matches COLOR = Brown, BREED = Tennessee Walker, HANDS >= 15, and AGE >= 5 is 0 records. It corresponds to the number of rows (records) that contain all of these criteria. Note that some rows meet some of these criteria, but none of the rows meet all of the criteria.
CONCEPT
Sarah is creating custom reports from her company’s database.
Select the set of file types that Sarah will use to create these reports.
.csv and .pptx
.tif and .db
.sql and .xml
.txt and .dat
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 9
Paul wants to present information about a new product at the upcoming national sales meeting.
Which productivity software should Paul use?
OpenOffice Impress
Microsoft Excel
Google Docs
IBM DB2
RATIONALE
OpenOffice Impress is presentation software from Apache that Paul can use for the meeting.
CONCEPT
Productivity Application Software 10
Which of the following correctly describes a record?
A record is a set of data organized in columns and rows.
A record appears as a row in a table.
A record is a flat file.
A record consists of one field.
RATIONALE
A record appears as a row in a table. An attribute or a field appears as a column in a table.
CONCEPT
Which of the following is the FIELD in a database table?
Account_Balance
$2,109.49
$969.78
$1,345.20
RATIONALE
“Account_Balance” is typically found in the column of a database table because it is a field in which there should be information for all clients. “$1345.20”, “$2,109.49”, and “$969.78” would be found in rows because they are specific data about a particular record.
CONCEPT
Brad launches a program in order to see all of his files, folders, and programs in one place.
Which element of the Microsoft Windows operating system is Brad using?
Taskbar
Windows Shell
File Explorer (formerly Windows Explorer)
Security and Maintenance
RATIONALE
Windows users can view and organize files and folders with the File Explorer application (called Windows Explorer in earlier versions of Windows).
CONCEPT
The Microsoft Windows Operating System 13
When Beth touches the screen of her smartphone to launch an application, the operating system’s ______ enables her to access her software and files.
welcome screen
user interface
memory
hardware
RATIONALE
When Beth touches the screen of her smartphone to launch an application, the operating system’s user interface enables her to access her software and files. User interfaces are how the user and a computer system interact.
CONCEPT
______, developed by Apple, can be used to calculate and organize financial information.
Excel
Keynote
Numbers
Calc
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
15
Brenda has a laptop that is more than six years old. Since she upgraded the Windows operating system to the latest version, her machine crashes when she starts it up.
To solve the issue, Brenda should try ______.
System Restore
Defragment
Disc Cleanup
System Configuration
RATIONALE
To possibly solve the issue, Brenda should use System Restore. System Restore is a feature in Microsoft
Windows that enables users to revert a computer’s state (including system files, installed applications, the Windows registry, and system settings) to a previous point in time. This method can be used to recover from system malfunctions and other problems.
CONCEPT
