1)

2)

3)

4)

5)

Which of the following statements regarding algorithms would you disagree with? Boolean expressions are an integral part of classification algorithms. Analytics based on data from multiple tables heavily rely on properly defined relationships among the tables. A measure hierarchy defines a relationship between measures from two different tables. SUM, AVERAGE, and COUNT are mathematical operations often used to define measures. Which of the following is not a within-table text calculation? Combining two text fields, such as combining a customer's first name John, and last name Doe, resulting in John Doe. Replacing a number of characters in a text field, such as replacing "str" with "street" in an address field. Extracting a substring for a text field. For example, extracting the area code 302 from telephone number 302-200-5731. Counting the number of different cells in a text field. For example, counting the different values in the Country field. For what type of table or tables is the how many pattern most relevant? Fact tables. Dimension tables. Fact and dimension tables. Neither fact nor dimension tables. Which of the following questions does not rely on a flows relationship? How many payments did John, an accounting clerk, make in January How many units did we produce in January? How much money was deposited in the Fulton bank account in Janu Which customer bought the most electronics products? Who-what-when stars are connected through transactions (e.g., sales). resources (e.g., finished goods). internal agents (e.g., employees). external agents (e.g., customers)