44 Questions
What determines the maximum number of processes that can run inside a single Matillion ETL job?
Number of vCPUs on the instance
What type of queue is used when a Matillion ETL job is submitted?
Unbounded queue
How many jobs can run concurrently by default in all Matillion ETL instances?
16 jobs
What happens when multiple runs of the same job are queued behind each other?
They run sequentially
How do long-running jobs submitted to Matillion ETL potentially affect scheduled jobs?
They delay the scheduled jobs
What determines the maximum number of concurrent processes that a single job execution can run in Matillion ETL?
$n^2$ where n is the number of vCPUs on the instance
What is the potential issue when users launch Matillion ETL with instance types that have many more vCPUs?
Concurrency conflicts with scheduled jobs
What is a consequence of a long-running job conflicting with a scheduled job in Matillion ETL?
The scheduled job is delayed
Which factor is NOT mentioned as affecting the concurrent running of jobs in Matillion ETL?
$Quartz$ scheduler
What increases as the number of vCPUs on an instance increases in Matillion ETL?
The number of available processes for a single job execution
What pattern is recommended in the scenarios described?
Micro-batching
How are validation tasks handled in Matillion ETL?
Through the task runner and queued behind running jobs
What happens when the maximum concurrency limit is reached in Matillion ETL?
Development may experience long validation times
In an HA Cluster for Matillion ETL, how are jobs distributed across nodes?
Essentially randomly
Why is it important to make jobs idempotent in an HA Cluster?
To handle scenarios where nodes fail and jobs need to be re-submitted
What is the implication of running multiple instances of the same transformation job at once without using a shared job?
It will result in errors due to inability to run in parallel
What behavior is exhibited when using a Run Orchestration component?
Sub jobs do not queue, as queuing is done at the top level
What feature in Matillion allows users to run multiple ETL jobs across multiple connections?
'Multiple Environment Connections' feature
How many threads does a job running in Matillion ETL have by default?
$2*n$ Vcores
What is not relevant to Matillion ETL for BigQuery?
HA Clusters for BigQuery
What action must be taken for any changes made within the administrative tools to take effect in Matillion ETL?
SSL Restart Server
Which administrative tool opens the Matillion ETL Updates pop-up window?
User Configuration
Why is the User Configuration option unavailable in HA (clustered) instances of Matillion ETL?
LDAP is used by default
Which Admin menu option in Matillion ETL provides access to manage database drivers?
Manage Database Drivers
What should users do when an error occurs in Matillion ETL to aid troubleshooting?
Attempt to reproduce the error and download server logs
Which option is a consequence of restarting the server in Matillion ETL?
Disconnected client sessions and stopped jobs
What does the 'Download Server Log' option in Matillion ETL provide users access to?
Server log files containing servlet logs
In Matillion ETL for BigQuery, where can admins adjust permission settings for groups created in the Manage Groups window?
User Configurations
Which feature in Matillion ETL is only available in Enterprise Mode and requires users and security setup via User Configurations?
Manage Groups
What action can admins perform using the Migrate feature in Matillion ETL?
Transfer resources between instances
Where can users see a detailed list of significant activity within a Matillion ETL Instance?
Audit Log
What is the default setting for the Product Improvement Metrics option in Matillion ETL?
'Yes' by default
Which instance types in Matillion ETL support the Audit Log feature?
m4 and m5 instances
What additional steps are required when using the Migrate feature in Matillion ETL to transfer resources between instances?
'100% duplication' process
Where can admins manage the creation, editing, and removal of groups with identifying names specified by them in Matillion ETL?
'Manage Groups'
What is a requirement for the 'Manage Permissions' feature to be available in Matillion ETL?
Enterprise Mode activation
What is the recommended action before upgrading an instance in Matillion ETL?
Perform a manual backup of the instance
How can new users access projects in Matillion ETL according to the text?
By logging in at least once
What is the purpose of controlling user access in Matillion ETL?
To manage internal and external users
What security measure does using External security in Matillion ETL provide?
Allows LDAP integration for user access
How can SSL be enabled in Matillion ETL?
By uploading SSL certificates
What is the purpose of the Restart Server function in Matillion ETL?
To restart the Matillion ETL instance without EC2 console
Why might administrators need to manage database drivers in Matillion ETL?
To use specific drivers not included by default
What is the role of the Manage Backups function in Matillion ETL?
To create automatic backups of the instance
Learn about Matillion ETL's process of running jobs and job concurrency. Understand how jobs are queued and executed using Message Queues, the API, or the Scheduler. Get insights into the role of Quartz job scheduler in managing job queues.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
