Choose the correct answer (MCQ))

Course: Act 430 (AIS)

48. Charting is one of the most effective data visualization techniques used in business intelligence. A gauge chart is particularly useful because it

*Illustrates the current status in achieving a financial goal or target.

*Demonstrates the proportional composition of an item to the whole.

*Compares changes over the same period of time for more than one item.

*Permits comparisons between categories.

49. Organizations must have adequate storage options for the massive amounts of data required for data analytics. Each of the following is an example of a storage technique used to support data analytics and business intelligence, except

*Data warehouses.

*Data lakes.

*Data marts.

*Data veracity.

50. A user is reviewing the description of a dataset containing accounts receivable data, which indicates this dataset contains receivables that are only for customers with balances greater than $10,000. This note in the description helps the user of the dataset understand which of the following-

*The population of events in the data.

*The sources of the data.

*The units of measurement of the data.

*The precision of measurement.

51. An organization is moving data from various files into a data warehouse. The extracted data includes total sales by zip code. The target database requires total sales by region (ie, North, South, West, East). Which of the following transformation methods most likely will be used to transform the data to meet the requirements of the target database?

*Transposing.

*Joining.

*Aggregating.

*Sorting.

52. An account number field in a relational database table is formatted to accept a two-letter state code followed by a seven-digit customer number (for example, VA1972200). Which of the following is an appropriate data type for storing the account numbers?

*Boolean.

*String.

*Integer.

*Decimal.

53. Each of the following is considered to be a characteristic of big data, except

*Versatility.

*Volume.

*Velocity.

*Variety.

54. Each of the following is an example of a technology that supports business intelligence, except

*Data lake.

*Machine learning.

*Cloud computing

*Collaborative computing

55.A credit card company that processes millions of transactions each year has experienced an increase in fraudulent transactions. The company maintains a data warehouse with data about customers and transactions from the past five years. How could the company best use this data to detect potentially fraudulent charges within 24 hours of receipt of transaction data?

*Employ data mining.

*Increase the internal audit staff.

*Adopt more stringent credit-approval policies.

*Use sequential coding for authorization numbers.

56. Each of the following is a characteristic of a relational database (RDB), except *

*Stores information sequentially.

*Consists of data sets organized by tables, rows, and columns.

*Creates relationships between tables through the primary key.

*Allows tables to communicate and share information with each other.

57. Which of the following can be discovered using a data-mining process?

*Data structure.

*Previously unknown information.

*Artificial intelligence.

*Standard query reporting