Level 1: Model Intro (2023)
Here is a short assessment to test your knowledge gained from the ‘Model Intro (2023)’ course, you will be asked 15 questions to complete.
We recommend you work through all walkthroughs before completing the assessment. The passing score is 80%.
You may retake the assessment as many times as you like.
Assessment Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the assessment before. Hence you can not start it again.
Assessment is loading…
You must sign in or sign up to start the assessment.
You must first complete the following:
Results
Results
0 of 15 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 15
1. Question
Model
Which of the following is a functionality of Model?
-
Question 2 of 15
2. Question
Model
What is the fastest way to upload and model data?
-
Question 3 of 15
3. Question
Model
True or False: Direct query gives the option to copy data directly from the data source.
-
Question 4 of 15
4. Question
Model
Model definitions contain:
-
Question 5 of 15
5. Question
Model
The data model includes instructions for:
-
Question 6 of 15
6. Question
Model
True or False: Deleting the model definition also deletes the materialized database.
-
Question 7 of 15
7. Question
Model
Which of the following is not a capability of Model’s data preparation?
-
Question 8 of 15
8. Question
Model
End-Users can use ______ to build advanced pipeline and flow logic, multiple data flows, multiple data models, and interactions with various other tools like APIs, command line and messaging.
-
Question 9 of 15
9. Question
Model
True or False: Custom columns allow the user to extend the original data model with new column calculations; that will not materialize within the underlying data source.
-
Question 10 of 15
10. Question
Model
Check all that apply about Text Aggregation.
-
Question 11 of 15
11. Question
Model
Fill in the blank: _______ is a node used to join two or more columns into be a single column in a table.
-
Question 12 of 15
12. Question
Model
Where in Model Pro can you join two tables together of the same structure?
-
Question 13 of 15
13. Question
Model
Which of the following is the correct way to build a hierarchy in model?
-
Question 14 of 15
14. Question
Model
Fill in the blank: ___________ is used to convert cross tabulated grids into a tabular format.
-
Question 15 of 15
15. Question
Model
True or False: In Pyramid you are allowed to build a level of hierarchy that may come from one or more tables.