Q1 - Which of the following statements regarding algorithms would you disagree with?

a. Boolean expressions are an integral part of classification algorithms.

b. Analytics based on data from multiple tables heavily rely on properly defined relationships among the tables.

c. A measure hierarchy defines a relationship between measures from two different tables.

d. SUM, AVERAGE, and COUNT are mathematical operations often used to define measures.

Q2 - Which of the following statements regarding the coding patterns is incorrect?

a. Ratios are most often implemented as measure hierarchies.

b. Across-table calculations strongly rely on matching primary key and foreign key values.

c. Single-column aggregations (measures) generate a singular value.

d. Often, the same formula combines numeric and textual calculations.

Q3 - The diagram is part of a star schema that describes a manufacturing process.

How would you describe the nature of the relationship between production and finished goods?

a. A participates relationship.

b. An occurs relationship.

c. A flows relationship resulting in a decrease or outflow of finished goods.

d. A flow relationship resulting in an increase or inflow of finished goods.

Q4 - Which of the following statements regarding dimensional modeling is incorrect?

a. Dimensional modeling aims to create data structures that make data analytics easier.

b. Dimensions can be used for filtering purposes.

c. Calculated columns can function as dimensions.

d. How many measures can be specified for dimension tables only.

\begin{tabular}{|l|l|l|} \hline Fact Table & \multicolumn{1}{c}{ Dimension Table } \\ \hline Production & N & 1 \\ \hline \end{tabular}