AIS ACC

The value of information can best be determined by

• the benefits associated with obtaining the information minus the cost of producing it

Which of the options below are important components of effective data storytelling?

• Remembering the question that initiated the analytics process

• Consider the audience

•   Use data visualizations

In transaction processing, generally which activity comes first?

• capturing data on source documents

Which of the following are included in the ETL Process?

• A) Loading data

D) Extracting data

A marketing analyst reviews historical sales data to determine which product categories have performed best over the last five years. The analyst is performing what type of analytic?

Descriptive

._____ information reduces uncertainty, improves decision makers' ability to make predictions, or confirms expectations.

• Relevant

A set of individual user views of the database is called the

external-level schema

The following current asset accounts exist:

• 1010- Cash

1030 - Accounts Receivable

1050 - Inventory

• 1075 - Prepaid Insurance

Which would be the best account code for a new Prepaid Rent account?

1080 - Prepaid Rent

All of the following are advantages of an ERP system except

• it takes considerable experience and training to use an ERP system effectively.

The logical view of a database system refers to

how a user or programmer conceptually organizes and understands the data

TransactionID	CustomerID	StorelD	ItemsPurchased	PaymentMethod
5001	1001	201	Shoes, Jacket	Credit Card
5002	1002	202	Laptop	PayPal
5003	1003	203	Phone, Headphones	Cash

A retail company maintains a database to track customer transactions. Below is a poorly structured table used for recording sales:

What is the primary database design issue in this table?

• every column in a row must be single valued

The ____handles the link between the way data are physically stored and each user's logical view of that data.

database management software (DBMS)

• A delivery of inventory from a vendor, with whom a credit line is already established, would be initially recorded in which type of accounting record and as part of what transaction

purchases journal; expenditure cycle

John Pablo works in the accounting department of a multinational manufacturing company.

His job includes updating accounts payable based on purchase orders and checks. His responsibilities are part of the company's what the company owes

expenditure cycle

Data must be converted into information to be considered useful and meaningful for decision making. There are 14 characteristics that make information both useful and meaningful. If information is free from error or bias and correctly represents the events or activities of the organization, it is representative of the characteristic of

accuracy

The collection of employee time sheets is part of which transaction cycle?

the human resources cycle

Data must be collected about three facets of each business activity. What are they?

the business activity, the resources it affects, the people who participate

. A frantic agent lost a large sale because he could not access the information in the system to verify the inventory was in stock and ready to be shipped. Which of the following characteristics of useful information is absent in the situation described above?

• available

All of the following are benefits of the database approach except

decentralized management of data

The collection of customer payment is part of which transaction cycle?

the revenue cycle

Which type of chart would be best for representing the correlation between two items?

• Scatterplot

An airport captures and retains continuous security camera footage for two years. The stored digital video data would be categorized as:

• Unstructured data

An algorithm was developed to recommend target zip codes for distributing coupons for a new product. What type of analytics was most likely used?

• Prescriptive

If a question is amenable to data analysis because the inputs to answering the question are able to be assessed with data, it fulfills which of the following objectives?

• Measurable

An analytic that answers the question "what happened?" is an example of which type of analytic?

• Descriptive analytic

Identify the statement below that is not true with regards to the accounts receivable subsidiary ledger.

Debits and credits in the subsidiary ledger must always equal.

A payroll department stores employee payroll data, including salaries, tax rates, and hours worked. This represents what type of data?

Structured data

The type of journal that records large numbers of repetitive transactions such as sales, cash receipts, and cash disbursements is

• a specialized journal

A supply chain firm uses historical data, seasonal cycles, and market trends to estimate inventory requirements for the coming year. Which analytic category best describes this approach?

• Predictive analytic

In which transaction cycle would information for retiring long-term debt be most likely to pass between internal and external accounting information systems?

the financing cycle

A company wants to store information about inventory including quantities, prices, cost, photos, and social media reviews. What type of data repository should be used?

Data lake

Updating accounts payable is part of which transaction cycle?

expenditure