Model Advanced (2023) Assessment

Model: Advanced

Check all that are True. What type of information is stored in the Model Definition?

Model: Advanced

True or False? The Model Definition and Materialized Database are separate entities; the materialized database can exist without the Model Definition.

Model: Advanced

Check all that apply. Advanced users can construct a Master Flow which may contain multiple:

Model: Advanced

Check all that apply. A variable can be added to the following Data Flow nodes:

Model: Advanced

Check all that apply. In a Master Flow, a Pyramid Event can be used to execute a schedule for the following items:

Model: Advanced

When we create an ML model, it is important to test it against data that was not used to train the model. The simplest way to achieve this is to divide our existing data into training and testing sets. What’s the best way in the Workflow to split the data between training and testing?

Model: Advanced

In a Prediction example, we use a Support Vector Machine model which only works against number inputs. How can we complete encoding columns to convert to numeric values?

Model: Advanced

True or False? You can save the output of a learn and predict algorithm as a machine learning model. This stores the existing results and allows you to add the ML model to another data flow later on.

Model: Advanced

When configuring a scripting node (Learn & Predict Script), what property determines the amount of data that is used to train the algorithm?

Model: Advanced

Check all that apply. To create a Python “Learn & Predict Script” the script needs to contain which 3 functions?

Model: Advanced

True or False? Using an existing ML Model node allows you to pass new data through a model you have already trained.

Model: Advanced

Check all that apply. The ‘Learn and Predict Script’ algorithm can be added to a Python or R scripting node in the following ways:

Model: Advanced

True or False? The model score is evaluated after the algorithm has been run. To produce this score, the algorithm compares its predictions based on the training data with the actual data.

Model: Advanced

Check all that apply. Which methods can be used to initialise a variable within a data model definition?

Model: Advanced

Check all that apply. Which of the following are conditional nodes available in the Master Flow?

Model: Advanced

Check all that apply. Which of the following are loop types available in the Master Flow?

Model: Advanced

Which symbol precedes a variable name when used in PQL / condition expressions with the data flow?

Model: Advanced

Within a Table node, which of the following is NOT a logical operator that can be used as a Filter?

Model: Advanced

Check all that apply. Which scripting languages are choices with the Marketplace node in a data flow?

Model: Advanced

Which Preparation node would be used to add a column which provides a Unique identifier (uid) to each row within a data flow ?

Model: Advanced

True or False? ‘Seed’ allows for the numbers generated by ‘Random Number’ to remain static when the preview is refreshed or the data flow is re-run.

Model: Advanced

Which ‘operator’ is used within Parent-Child hierarchies to allow for an indicator column to be implemented to indicate how each Child element is aggregated to its Parent?

Model: Advanced

True or False? Virtual Calculated Columns Calculations are different to data flow Column Calculations as they are not materialized but calculated at run time.

Model: Advanced

Where can Virtual Calculated Columns be created / defined? Select all that apply.