Quiz
6
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (15)
1Dismissal of fixed assets
- AParticipates
- BFlows
- COccurs
2Making a cash payment
- AParticipates
- BFlows
- COccurs
3Generating quarterly sales reports
- AParticipates
- BFlows
- COccurs
4Return of goods to a vendor
- AParticipates
- BFlows
- COccurs
- DParticipates and Flows
5Which of the following statements is false?
- AA measure hierarchy can be built by applying aritmetic operators to existing measures, such as dividing existing measures.
- BCalculated columns are the center of data analytics. Once calculated, they can be sliced in many ways during data exploration.
- CA calculated column is an integrated part of a table.
- DCalculated columns and measures are both implemented using algorithms.
6Which of the following does not describe an accounting algorithm?
- ACalculating depreciation expenses using the straight-line method.
- BCreating a line chart that shows changes in an organization's net profit margin during the last five years.
- CDetermining last year's net profit margin.
- DCalculating how much overhead should be allocated to different product categories.
7Which of the following statements regarding algorithms would you disagree with?
- AA measure hierarchy defines a relationship between measures from two different tables.
- BSUM, AVERAGE, and COUNT are mathematical operations often used to define measures.
- CBoolean expressions are an integral part of classification algorithms.
- DAnalytics based on data from multiple tables heavily rely on properly defined relationships among the tables.
8Which of the following is not a within-table text calculation?
- ACombining two text fields, such as combining a customer's first name John, and last name Doe, resulting in John Doe.
- BReplacing a number of characters in a text field, such as replacing "str" with "street" in an address field.
- CExtracting a substring for a text field. For example, extracting the area code 302 from telephone number 302-200-5731.
- DCounting the number of different cells in a text field. For example, counting the different values in the Country field.
9Which of the following statements regarding the coding patterns is incorrect?
- AAcross-table calculations strongly rely on matching primary key and foreign key values.
- BSingle-column aggregations (measures) generate a singular value.
- COften, the same formula combines numeric and textual calculations.
- DRatios are most often implemented as measure hierarchies.
101. Depreciation data describe a flows (inflow) relationship.
- AAgree
- BDisagree
112. Data describing all the services a public accounting firm has offered to clients last month is an example of a flows relationship
- AAgree
- BDisagree
12An audit procedure checking the vendors involved in purchases against an approved list of vendors is an analysis of a participates relationship
- AAgree
- BDisagree
13Calendar tables are used for occurs relationships.
- AAgree
- BDisagree
14For what type of table or tables is the how many pattern most relevant?
- ANeither fact nor dimension tables.
- BFact tables.
- CDimension tables.
- DFact and dimension tables.
15Which of the following statements regarding dimensional modeling is incorrect?
- ACalculated columns can function as dimensions.
- BDimensional modeling aims to create data structures that make data analytics easier.
- CHow many measures can be specified for dimension tables only.
- DDimensions can be used for filtering purposes.
Information
- Description
- University acc Quiz on 6, created by Jake Jakes on 16/12/2024.
- Author
- Jake Jakes
- Language
- English
- Views
- 2
- Tags
- Rating
- No ratings yet Rate this quiz