MIST$331$ Spring $2023$

Finat Exam

Monday, May ${299}^{10}2023$

$\backslash$table$[[\backslash$table$[[$Froctiome$],[$Atwintar$]],$save Rrown,$],[,$Cavt$-$nitht,$6],[5ma+6p+,\backslash$table$[[$Nce$-$restent$],[$Nor$.$e$]],$sb$],[$NConnwy$,$Eo$],[$Whtheset$,60],[$row$-$amertent,$],[$Fenterwhen$,6],[,$souts...,$90],[cdots,,65]]$

In the tables above showing ProdName and Sales Region are produced using the exact same fields, what could be a reason for the difference in numbers?

a$.$ The field setting changed from sum to average

b$.$ Coumt of orders is the same as order total

$($d$)$ One table is showing the orders by Sales Region and the other by ProdName All of the above

Creating a map chart requires a dimension that is designated as

a$.$ dimension

b$.$ a measure

$($c$.)$ a measure labeled as a location

d$.$ a dimension labeled as a location

In the above table, the college would like to create an action where choosing a gender will show the educational degrees attained and the number of students in each group. To ado so you need to create

a$.$ A gender set

b$.$ A calculated field that if a gender is selected, to show the education attained

c$.$ A gender filter

$($d$)$ Both a & b $b$

An availability check is conducted automatically when

a$.$ A production order is confirmed

$($b$)$ a planned order is converted to a production order

c$.$ goods are issued to the production floor

d$.$ goods are received by the warehouse.

When running the MRP$,$ production orders can be created without any purchase orders.

Q$.$ True

b$.$ False

$8$