12_TriggerFlows Flashcards

1
Q

What are the 4 connectors for working with files and folders?

A

File. FTP. SFTP. FTPS. (have same set of operations and behave almost identically).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

(File Connector). On CloudHub, the connector can only be used with the ???? folder?

A

/tmp

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is best practice, when you are adding a File module to the project?

A

You should create a global element configuration and set the working directory that will be the root for every path used with the connector.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

(File connector) When using a customer-hosted runtime, the account running Mule must have what?

A

Read and write permissions on the specified directories.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What listener can be used to trigger a file when a new file is created/updated?

A

On New or Updated file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does the On New or Updated File listener do?

A

It polls the directory for files that have been created or updated.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How many messages are generated, when the On New or Update File listener is used to trigger flows when a new file is created or updated?

A

One message is generated for each file that is found.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

When you use a On New or Update File listener, what do you have to avoid? and how?

A

The poller will keep bringing back the created or updated files. You must ensure a file is new by… (deleting each file after processing, move each file, rename a file and add a filteror save and compare the file creationor modification times).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the process for sychronizing data from one system to another?

A

First time you sync all the data, after this you only need to sync the new data. Each sync you will store the latest timestamp for any item in the data set, on other syncs you will retrieve this timestamp and compare to see if it has already been synched. It will sync all later data that has not already been synched. The timestamp is often a creation timestamp/modification timestamp or recordID.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is often used as a timestamp?

A

Creation timestamp, modification timestamp and recordID.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is a watermark?

A

The timestamp that is stored each sync and then retrieved and compared against the next sync.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What can you specify for the On Table Row operation?

A

Watermark column and the Idempotency column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What’s an easy way to remember a watermark?

A

When the house floods …. nightmare … it will leave a watermark at the highest mark that the water came too. So you can think of it as when you are doing the next sync, you will look for the water mark to find the highest poiunt that was previously reached.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How many types of watermarking are there in Mule?

A

2 (Automatic and Manual)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is the Automatic type of watermarking?

A

The saving/retrieving/comparing is automatically handled for you. Availble for several connector listeners (On New or Updated File, On Table Row). Restricted in how you can specify what items/records are recieved.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the Manual type of watermarking?

A

You handle saving, retrieving and comparing the watermark. More flexible in that you specify exactly what records you want retrieved.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

For an automatic watermarking with files, what are the 2 modes?

A

CREATED_TIMESTAMP and MODIFIED_TIMESTAMP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What ????? operation for the family of file connectors has a watermarking option?

A

On New or Upddated File

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What operation can you use to trigger a flow for each row in a database table?

A

On Table Row.

20
Q

What does the Scheduler component allow you to do?

A

Execute any flow at any time.

21
Q

What query is automatically generated and use, for the watermark column specified with handling database tables.

A

SELECT ( FROM table WHERE TIMESTAMP > :watermark

22
Q

What does the query SELECT * FROM table WHERE TIMESTAMP > :watermark, do?

A

On each poll it will run and use the query to retrieve all rows that are higher than the watermark. The component will then go through all the retrieved rows and store the maximum value obtained (for the next watermark.

23
Q

How do you reference the watermark in a Database query?

A

:watermark

24
Q

How can a new poll be executed before the watermark is updated?

A

The poll interval is small. The amounts of rows is big. Processing one single row takes too much time.

25
Q

How can you avoid a record being processed more than once, considering a new poll could be executed before the watermark has been updated?

A

Specify an ID column (unique identifier for the row), the listener will make sure the row is not processed again (If it has already been retrieved and processing of it hasn’t finished yet).

26
Q

When you are handling a watermark manual, what is the general process?

A

Schedule when a flow should be executed. Give the watermark a default value. On the first sync, determine a new watermar valye and store the watermark value so it is available in the future to other flow executions. On later syncs, retrieve the watermark from the storage and check if each item in the data set should be retrieved based on the watermark value.

27
Q

How can you trigger any flow at any time?

A

Use the Scheduler component.

28
Q

What does the Scheduler component allow you to do?

A

Execute any flow at any time.

29
Q

What are the 2 types of scheduling strategies?

A

Fixed frequency (default value) and cron (standard for describing time and date information)

30
Q

What is cron?

A

A standard for describing time and date information

31
Q

What are cron and fixed frequency?

A

Two types of scheduling strategies.

32
Q

What can cron specify?

A

Either an event to occur just once at a certain time or recurring event on some frequence.

33
Q

Give an example of fixed frequence and cron?

A

fixed frequency - default to polll every 10000 seconds, cron - can eiher be an event to occcur just once at a given time, or a recurring event at a given frequenct

34
Q

What should you use to store simple key-value pairs?

A

Object Store

35
Q

What is the object store designed to store?

A

Synchronization information like watermarks. Temporal information like access tokens. User information.

36
Q

How do you access the values that are in the Object Store?

A

The values are accessible as event variables.

37
Q

How does a Mule application get an object store?

A

Every Mule application has an Object Store that is available without any setup or configuration

38
Q

Where are the Object Store saved for Mule standalone runtimes, CloudHub, clustered Mule runtime?

A

file, data storage and shared distributed memory

39
Q

How do you use the Object Store connector for watermarking?

A

Add the ObjectStore module to the project, use the retrieve operation to retrieve a watermark value and to assign a default value for the first poll. User the watermark value in the processor to retrieve the desired items (e.g. db query for records in a table). Then use the Store operation to determine and store a watermark value.

40
Q

What is JMS?

A

it’s a widely used API for enabling applications to communicate through the exchange of messages.

41
Q

What does JMS stand for?

A

Java Messsaging Services

42
Q

What 2 messaging models does it provide?

A

Queues (P2P) and Topics (Pub:Sub or 1:many).

43
Q

Explain the message model Queues.

A

PTP (point-to-point). A sender sends messages to a queue and a single reciever pulls the message off the queue. The receiver does not need to be lsitening to the queue ar the time the message is sent.

44
Q

Explain the message model Topics.

A

Pub-Sub (1:many). A publisher sends a message to a topics and all active subscribers will recieve the message. Subscribers not actively listening will miss the published message (unless messages are made durable).

45
Q

When using the JMS connector, what do you need to configure?

A

Configure a global element configuration. By default, it’s set up with valyes, typically you jsut need to configure which connection should be used.

46
Q

Give an example that uses an in-memory broker.

A

ActiveMQ