Question

A. Which of the following is often used as the main repository of a company’s historical data (i.e., its corporate memory)?

• The XBRL instance document.

• The data warehouse.

• The operational system.

• Its digital dashboard.

B. Which of the following activities is not associated with the sales and collection business process?

• Billing customers.

• Maintaining vendor records.

• Recording customer payments.

• Selling products and services.

C. Which of the following is not one of the Excel tools described as useful for data analytics?

• Tableau.

• Calculated Field.

• Slicers.

• Power Pivot.

D. Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Purchases and Products classes?

Multiple Choice

• Each purchase is for one product.

• Each purchase can include many products.

• Checks are written after products are added to inventory.

• Each purchase order specifies many products.

Answer 1

Q A. 2. The Data Warehouse - This statement is correct. Data warehousing (DW), as the main repository of historical data, manages data from different sources to give meaningful business insights. The data warehouse is commonly used to connect business data from heterogeneous sources. The data warehouse is the core of BI for data reporting. The data warehouse collects data from many sources, such as organization reports and analytical matters. 

1. This statement is incorrect. The XBRL document is an electronic business statement detailing the XBRL principle. The XBRL contains information about what is defined by the classification factors, their cost, and what they are in relation to.

3. This statement is incorrect. Operational systems include data warehousing, which is used to process the day-to-day business of an organization. It has a system that closely monitors the process of daily transactions.

4. This statement is incorrect. The digital dashboard appears as an electronic reference, in which data is collected from sources such as files and web services for the database hosting locally.

Q B. 2. Maintaining vendor records - This option is Correct Because, Sellers are the suppliers of products sold in your business. In a business the seller can only add or change records. When creating a vendor record, it is necessary to select the seller in the General Parameters Maintenance window. Therefore, the sale and collection of activities is not related to the business process.