Choose the best answer (MCQ)

Course : ACT 430 (AIS)

41. Which of the following attributes in a customer table of a relational database could function as the primary key?

*Customer address.

*Date of sale.

*Customer number.

*Balance due

42. Internal audit decided to use data analytics to detect errors or other unanticipated variances in several financial statement accounts. Which of the following data analytic techniques would most likely be used to compare information from various sources, such as supplier price lists, purchase orders, and supplier invoices?

*Sorting

*Matching

*Trend analysis

*Ratio analysis

43. Which of the following procedures most likely would identify unwanted page breaks or tabs in extracted data?

*Decoding data.

*Filtering data.

*Integrating data.

*Removing nonprintable characters.

44. An entity needs to update the data stored in a data warehouse that is used for business intelligence purposes. The organization has identified the records that have been modified, added, and deleted since the prior data load. Which of the following load types should be used to update the data warehouse?

*Incremental load.

*Full refresh.

*Transform.

*Initial load.

45. Software used for extract, transform, load (ETL) processes can perform each of the following functions, except:

*Retrieve data from semi-structured sources.

*Calculate summary statistics.

*Maintain a metadata repository.

*Operate enterprise resource planning (ERP) systems

46. An organization needs to update the data stored in a data warehouse. The organization is unable to determine which data has been modified, added, or deleted since the prior data load. Which of the following load types would best meet the objective to update the data?

*Full refresh.

*Initial load followed by an incremental refresh.

*Incremental loading.

*Initial load.

47. An organization wants to migrate data from several different systems to a centralized location so that it can be analyzed for business intelligence purposes. Which of the following items would best meet the objective?

*Change control process.

*Extract, transform, load process.

*Robotic process automation.

*Data normalization process.