BUAD 342 Exam 1 + 2

Which of the following describes the accuracy and usefulness of Big Data? A.Veracity B.Verifiability C.Velocity D.Volume E.None of the above

A.Veracity Veracity is differences in data accuracy/quality

A company keeps data about each completed purchase of inventory during the current month. What type of file is this data kept in? A.Master File B.Transaction File C.Suspense File D.History File E.Reference File

B.Transaction File a purchase requires a transaction

Your boss asks you about bar code readers, optical character recognition, and RFID. You explain that these are examples of A.Source Documents B.Business Events C.Source Data Automation D.Enterprise Resource Planning E.None of the above

C.Source Data Automation a process of collecting data at its point of origin in digital form

Which of the following best demonstrates the importance of data flows between processes and systems? a. The tasks associated with Customer Relationship Management (CRM) b. The tasks associated with Supply Chain Management (SCM) c. The tasks associated with the procure to pay process d. The tasks associated with the order to cash process e. Both A and B

b. The tasks associated with Supply Chain Management (SCM)

Query Logic Step 2 includes the "From" statement from a SQL code. What is the designer capturing in the "From" statement? A.) The table(s) that holds the data B.) The fields to be displayed in the output C.) The fields needed for calculation or expressions D.) The criteria used to filter the results E.) Both B and C

A.) The table(s) that holds the data Identify which table(s) or query view(s) are the sources of the desired fields/data items that you identified during Logic Step 1.

____________________ describes the blueprint or design of the components of some information system and their relationships A.Architecture B.DBMS C.Infrastructure D.Object E.None of the Above

A.Architecture Architecture describes the blueprint or design (or you could call it a conceptual model) of the components of some information system and their relationships. Infrastructure is a term used to denote the actual set of components (the physical hardware and software) that is used to build a physical information system

Which of the following are controlled by two standards (ANSI X12 and EDIFACT)? A.EDI (Electronic Data Interchange) B.SCM (Supply Chain Management) C.CRM (Customer Relationship Management) D.ERP (Enterprise Resource Planning) E.EFT (Electronic Funds Transfer)

A.EDI (Electronic Data Interchange) a method for exchanging business data between or within organizations in a structured, machine retrievable format

In my SELECT statement, I put the ______ that I want to see or use in my query. A.Fields B.Tables C.Cells D.None of the above

A.Fields fields - A data structure that contains a single piece of data Make a list of the fields you need to include in your query. The fields you will need tend to fall into the following categories:•Fields you want to display in your output•Fields you need to create calculations or expressions•Fields you need to use for logic purposes (e.g. in where criteria)

Which of the following business process is the most diverse? A.Order to Cash B.Conversion C.Negotiate Sales Order D.Procure to Pay E.Select and Inspect Goods

B.Conversion Conversion business processes across, or even within, organizations are very diverse and depend on the type of good or service being produced, the technology and resources utilized, restrictions of regulators, governments, society, or customers, and the preferences of customers and management.

To a computer, the value of TRUE and "TRUE" mean the same thing. A.True B.False

B.False To a computer, "1" is different than 1 (something you likely noticed when learning spreadsheets). "1" denotes text or string, 1 denotes a numeric value. "TRUE" denotes text or string, TRUE is a logical system value. Also be advised that computers are picky about spelling and can be case (uppercase, lowercase) sensitive. In some packages, like Access, the software tries to avoid these issues by helping the user.

Of the following events, which typically comes first in the P2P process? A. Negotiate a purchase order B. Pay vendor C. Identify a need D. Receive and inspect goods

C. Identify a need procure to pay business process: 1. Identify need and possibly internally request the purchase of goods or services by an authorized purchasing agent. 2. Negotiate a purchase order with a vendor. 3. Receive and inspect goods or services from a vendor. 4. Store and/or maintain goods. 5. Pay a vendor for goods or services. 6. Return goods to a vendor.

Extract, Transform, and Load describes the stages of: A.Source Data Automation B.Designing a relational database C.Building a data warehouse D.Scrubbing and cleaning data E.Both A and C

C.Building a data warehouse Extract refers to data capture. During the Transform stage, designers scrub and clean the data, transforming it and getting it ready for use by analysts. Finally, the data is Loaded and indexed (organized), ready for use.

Which of the following source documents could be used to document the Negotiate Sales Order event? A.Sales Invoice B.Bill of Lading C.Sales Order D.Receiving Report E.Both A and C

C.Sales Order Supports the NEGOTIATE SALES ORDER event by summarizing the who, what, when, where, and why of each sales order transaction.

Which of the following scenarios would most likely benefit from real time processing instead of batch processing? A.Customer Billing B.Payroll Processing C.Ticket Reservations (sports or airline) D.Both A and B E.Both B and C

C.Ticket Reservations (sports or airline) Real‐time denotes that rather than waiting a predetermined amount of time as you would with batch processing, transaction data are entered and processed to update the relevant master files as the business event occurs.

If I want to filter the data that I see in my query output, I should use which statement to do so? A.FROM B.SELECT C.WHERE D.PICK E.Either FROM or WHERE

C.WHERE Where - Criteria for selecting rows or tables/views, similar to filter on Excel; set constraints on the data

Which of the following describes WHAT a business does? A.Business Events B.Business Attributes C.Business Entities D.Business Processes E.Business Strategic Goals

D. Business Processes Think of business processes as a cookbook for running a business and reaching business goals defined in an organization's business strategy

Of the following events, which typically comes first in the Order to Cash Process? A. Prepare goods B. Receive Payment C. Negotiate a Sales Order D. Market goods or services

D. Market goods or services order to cash process: 1. Market goods or services to potential or returning customers (and/or perform support activities that help customers choose you as a vendor). 2. Negotiate (with a potential or returning customer) the terms of an order for goods or services. 3. Select and inspect goods or services to be delivered to the customer 4. Prepare goods or services for delivery to the customer. 5. Deliver goods or services to the customer. 6. Receive payment for goods or services from the customer. 7. Negotiate the terms of, and possibly accept, a customer return of goods.

Which of the following is not a typical event in the Procure to Pay process? A.Identify a need B.Receive and Inspect goods or services from a vendor. C.Return goods to a vendor. D.All of the above are typical Procure to Pay events. E.None of the above are typical Procure to pay events.

D.All of the above are typical Procure to Pay events. procure to pay business process: 1. Identify need and possibly internally request the purchase of goods or services by an authorized purchasing agent. 2. Negotiate a purchase order with a vendor. 3. Receive and inspect goods or services from a vendor. 4. Store and/or maintain goods. 5. Pay a vendor for goods or services. 6. Return goods to a vendor.

A __________________ describes record field names, the width of each field, and the type of data stored in each field (e.g., numeric, alphanumeric, date). A.Data Dictionary B.Primary Key C.Table D.Record Layout E.None of the Above

D.Record Layout One way of documenting the contents of a database is to look at the table structure, or record layout. A record layout details the record structure, including record field names, the width of each field, and the type of data stored in each field (e.g., numeric, alphanumeric, date).

Which of the following is not a source document related to Procure to Pay? A.Receiving Report B.Purchase Order C.Purchase Requisition D.Sales Invoice E.All of these are related to P2P

D.Sales Invoice Procure to Pay Source Documents: Purchase order, Purchase Request, Receiving Report, Vendor's Invoice

Queries do more than just answer questions about data. Which type of query can make changes to records from one or more tables?A.Select Query B.Make-Table Query C.Append Query D.Update Query E.None of the above

D.Update Query to make changes to records from one or more tables, including using a criteria to specify which rows should be updated

The reading discusses two resources that link the OTC and P2P process. Which of the following is a linking resource? A. Customers B. Cash C. Goods D. Both A and B E. Both B and C

E. Both B and C OTC sells goods and collects cash P2P buys goods and spends cash

No SQL is most often associated with A.Big Data B.Schema on Read databases C.Relational databases D.All of the Above E.Both A and B

E.Both A and B NoSQL database systems are a broad class of database management systems that differ from relational database management system

Your client needs to make sure that inventory master files are up to date as business events occur. Which of the following will provide useful in achieving this goal? A.Real Time Processing B.Batch Processing C.Use of an ERP system D.Using Source Data Automation E.Both A and D

E.Both A and D Source Data Automation describes a process of collecting data at its point of origin in digital form. Real‐time denotes that rather than waiting a predetermined amount of time as you would with batch processing, transaction data are entered and processed to update the relevant master files as the business event occurs

Your boss asks you about ANSI X12 and EDIFACT. You explain to her that these concepts are standards for A.Database Design B.Business Events C.Source Data Automation D.Enterprise Resource Planning E.None of the Above

E.None of the Above EDI (Electronic Data Interchange) 3, a method for exchanging business data between or within organizations in a structured, machine retrievable format.

Which of the following is not true regarding relational databases? A.Designers make every effort to eliminate all data duplication B.They combine data and computer instructions into a single unit C.They are schema on read databases D.All of the above are true E.None of the above are true

E.None of the above are true Relational databases, are based on the theory of relational math (set theory) and they use a method of data recording and access called the schema‐on‐write approach. A schema is a fancy word for a model of the data.

____________contain data awaiting some action to complete their processing. A.Transaction Files B.Master Files C.Reference Files D.History Files E.Suspense Files

E.Suspense Files Suspense means awaiting for something - suspenseful -

Which type of join will provide a designer with the records that match from both tables? A.Right Join B.Inner Join C.Full Outer Join D.Left Join E.Equi-join F.Both B & E

F.Both B & E *equi-join is the term Access calls inner join* An inner join matches up records between two tables based on designated values. The result set that you get contains the rows from the table on the left that match the table on the right. If there are rows in either table that don't match, they aren't returned in the result set

What kind of processing would be most likely used for a small town bank with one branch, just starting out? a. Batch processing b. Realtime processing c. Online realtime processing d. B and C would likely be used for a small town bank e. None of these would likely be used for a small town bank

a. Batch processing Batch processing accumulates transaction data for a period of time to collect a group (called a batch) of transaction data before proceeding with processing. Then the batch of transactions is posted to the master file in one processing run. Processing involves posting the totals from the newly posted transactions to the current master file data to create a new, updated master file. The pre‐update master file, the batch of transactions, and the post update master file are all stored for when backups are needed. With automated batch processing, transaction data may not be entered in the computer system until some time after a business activity occurs, and master files may be updated even later. The only time the master file is accurate and up‐to‐date is immediately after a batch of transaction data has been processed.

How do we account for the exact number of products within a customer order? a. Create something like an Order Lines table to identify each item with a product ID and an order ID b. Account for the quantity ordered in one record c. Create multiple customer orders d. None of these e. All of the above

a. Create something like an Order Lines table to identify each item with a product ID and an order ID at least one but up to many records per sales order (one record per product # ordered - not per quantity of product ordered). Orderlines table includes fields to enable linking back to Products and Orders tables.

Putting quotes around text within criteria will a. Denote text or string b. Denote "TRUE" c. Create a null value d. Depend on the number of characters to determine the action e. None of these

a. Denote text or string To a computer, "1" is different than 1 (something you likely noticed when learning spreadsheets). "1" denotes text or string, 1 denotes a numeric value. "TRUE" denotes text or string, TRUE is a logical system value.

Which of these software is focused on internal functions? a. ERP b. SCM c. CRM d. All of these are focused on internal functions e. None of these are focused on internal functions

a. ERP (enterprise resource planning) Typical ERP application modules include order to cash transaction processing, procure to pay transaction processing, human resources support, payroll processing, financial applications, cash management, general ledger, and inventory / asset management.

What is a data table comprised of? a. Fields and records b. Structured data c. Information which has been processed d. Forms e. None of these

a. Fields and records The table rows are referred to as records and each table can contain many records. Each record is made up of a collection of columns referred to as fields. A field is a data structure that contains a single piece of data or attribute. One of the table fields is a unique identifier that enables users to differentiate between the various records (called the primary key field).

What are the steps in creating a traditional database, in the order which they occur? a. Mapping reality into a conceptual model, mapping the conceptual model into a logical model, and creating a physical database using DBMS software b. Mapping the physical database, creating the logical model, and using DBMS software to turn the logical model into a conceptual database c. Using DBMS software to model reality, mapping a conceptual plan, and mapping a logical database d. None of these e. A or B are both effective ways to create a database

a. Mapping reality into a conceptual model, mapping the conceptual model into a logical model, and creating a physical database using DBMS software

To verify the existence of a record for a customer, which type of file would you access? a. Master file b. Reference file c. Customer filed. Transactions file e. None of these

a. Master file Master files contain balance data or the status of an entity at a point in time. Examples include inventory files, customer files, employee files, vendor files, or cash account files. Master files do not contain event or activity data (meaning that do not contain the details about the transactions that change their balances).

Based on what we have learned thus far, what is a standardized query language that can be used to accomplish many tasks (not just ask questions)? a. SQL b. LPK c. SQY d. ERS e. NAS

a. SQL structured query language SQL is actually a standardized query language that can be used to accomplish many tasks (not just ask questions). You can use SQL commands to do everything from creating databases, creating schemas, creating table structures, updating table structures, deleting tables, joining tables, adding or updating data, adding database users, setting database controls, and requesting information from a database.

If I am wanting to see the matching records from both tables in my query output, which type of join should I use? a. inner b. left c. right d. full outer e. b & c

a. inner An inner join matches up records between two tables based on designated values. The result set that you get contains the rows from the table on the left that match the table on the right. If there are rows in either table that don't match, they aren't returned in the result set.

If in my WHERE statement, I say I want only numbers "between 1 and 10", my output will include the number 1 & the number 10. a.True b.False

a.True Decide if you need to input any criteria that limits the query view output to only records that meet your condition(s). You will use criteria terms such as AND, OR, BETWEEN. The Where Criteria limits the rows/records selected from the tables/query views. Add the fields and tables needed for criteria to your lists created in steps 1 and 2.

What triggers the Order to Cash process? a. Negotiating the sales order b. A customer's decision to buy the organization's goods or services c. A marketing campaign d. None of these trigger the Order to Cash process e. Only B and C trigger the Order to Cash process

b. A customer's decision to buy the organization's goods or services

Would you likely determine which schema (schema on read or schema on write) to apply before or after accessing(viewing) the data? a. Before; to map out the reality before implementation b. After; to determine what is the most relevant to the task at hand c. Before; to determine how to structure the database d. Before; for querying e. None of these

b. After; to determine what is the most relevant to the task at hand

Building a data warehouse is actually a multi-step process referred to as a. Data capture b. ETL c. ERS d. ERP e. None of these

b. ETL Building a data warehouse is actually a multi‐step process referred to as Extract‐Transform‐Load (ETL). Extract refers to data capture. During the Transform stage, designers scrub and clean the data, transforming it and getting it ready for use by analysts. Finally, the data is Loaded and indexed (organized), ready for use.

When does an organization receive payment for goods or services? a. At the credit check b. When the goods are delivered c. When the goods are shipped d. When the customer order is created e. A and B

b. When the goods are delivered

What is the name of the type of query that prompts a user for inputs before a query is run? a. User defined query b. parameter query c. crosstab query d. data input query e. both D and B are correct

b. parameter query prompts the query user for information to be used in executing the query. Ex: use this type if you want a query that displays only the order IDs for the customer ID that the user inputs

A file that contains data about the various vendors used by the company and their performance would be considered which type of file? a. Transaction file b. Archive file c. Master file d. Reference file e. Suspense file

c. Master file Master files contain balance data or the status of an entity at a point in time. Examples include inventory files, customer files, employee files, vendor files, or cash account files. Master files do not contain event or activity data (meaning that do not contain the details about the transactions that change their balances).

In which process would you negotiate a customer order? a. Conversion b. Procure to Pay c. Order to Cash d. All of these e. None of these

c. Order to Cash order to cash process: 1. Market goods or services to potential or returning customers (and/or perform support activities that help customers choose you as a vendor). 2. Negotiate (with a potential or returning customer) the terms of an order for goods or services. 3. Select and inspect goods or services to be delivered to the customer 4. Prepare goods or services for delivery to the customer. 5. Deliver goods or services to the customer. 6. Receive payment for goods or services from the customer. 7. Negotiate the terms of, and possibly accept, a customer return of goods.

What is the best definition of Big Data? a. Unstructured data which is compiled to use for statistical analysis b. Schema on read c. Semi structured and unstructured data enabled in high volumes to arrive at a high velocity d. A and B e. None of these

c. Semi structured and unstructured data enabled in high volumes to arrive at a high velocity

Where does much of today's data tend to be stored? a. Data files b. Traditional databases c. Streams of big data d. B and C e. None of these

d. B and C Much of today's data tends to be stored in traditional databases and in streams of so called big data.

One way of documenting the contents of a database is to look at the a. Table structure b. Record layout c. Data dictionary d. Both A and B e. All of the above

d. Both A and B One way of documenting the contents of a database is to look at the table structure, or record layout. A record layout details the record structure, including record field names, the width of each field, and the type of data stored in each field

Which join would NOT return a null value in the event that there is a record in one table that is not in another? a. Left join b. Full outer join c. Left join d. Inner join e. Union

d. Inner join An inner join matches up records between two tables based on designated values. The result set that you get contains the rows from the table on the left that match the table on the right. If there are rows in either table that don't match, they aren't returned in the result set.

What is name of the table field that contains a unique identifier that enables users to differentiate between the various records? a. Major field key b. Minor field key c. Solitary field key d. Primary field key e. First field key

d. Primary field key The table rows are referred to as records and each table can contain many records. Each record is made up of a collection of columns referred to as fields. A field is a data structure that contains a single piece of data or attribute. One of the table fields is a unique identifier that enables users to differentiate between the various records (called the primary key field).

A purchase order sent by the buyer in the ______ process is the data flow referred to as the customer order by the seller in the ______ process. a. Order to cash; procure to pay b. Conversion; order to cash c. Procure to pay; conversion d. Procure to pay; order to cash e. Conversion; conversion

d. Procure to pay; order to cash

What is the best definition of a query? a. Records and fields which create tables b. A central repository of information created with data from transactional systems, relational databases, and other sources c. Output screen through which a user communicates with a program d. A multi-step process in building a data warehouse e. A request for data or information from a database table or combination of tables

e. A request for data or information from a database table or combination of tables

What is a listed benefit of an EDI? a. Reduced processing expenses b. Obsolesce of physical paper exchange c. Lower inventory costs d. Improved customer relations and service e. All of these

e. All of these EDI (Electronic Data Interchange) 3, a method for exchanging business data between or within organizations in a structured, machine retrievable format.

What is a DBMS? a. The resource available to build and manage data structures in an information system b. Software which maps reality into a logical database c. Software originally developed to simplify and enhance the value of an organization's data by reducing data and programming redundancy, inconsistent data formats, and data inconsistencies d. Software which does not differ in the features offered to users and developers. e. Both A and C

e. Both A and C A DBMS is the resource available to build and manage data structures in an information system. DBMS software was originally developed to simplify and enhance the value of an organization's data by reducing data and programming redundancy, inconsistent data formats, and data inconsistencies. A DBMS environment allows the development and maintenance of a data repository that is independent from application programs.

The three main information processing activities that support all key business events include: a. Recording, reporting, executing b. Referencing, maintaining, executing c. Referencing, invoicing, generating d. Processing, recording, reporting e. Recording, maintaining, reporting

e. Recording, maintaining, reporting