True or False? When connecting to a SQL Database, an SSH Tunnel can be used to increase security?
- True
- False
Which of the following “units” of time can be included in the DATE_STARTOF function? Select ALL that apply.
Which of the following “units” of time can be included in the DATE_STARTOF function? Select ALL that apply.
- Hour
- Day
- Week
- Month
- Quarter
- Year
- Decade
- Fortnight
You can reference the value(s) of a component in another component in the same Klip.
You can reference the value(s) of a component in another component in the same Klip.
- True
- False
Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change it to ARRAY(“Apple”,”Apple”)?
Consider the following array of data: ARRAY(“apple”,”banana”). What function do you use to change it to ARRAY(“Apple”,”Apple”)?
- SUBSTITUTE
- SUBSTITUTE_REGEX
- REPLACE OR SUBSTITUTE
- REPLACE
- All of the above
Consider the following scenario. A user can change the default start day of the week when using DATE_STARTOF function when the unit parameter chosen is “day of week” or “week”.
Consider the following scenario. A user can change the default start day of the week when using DATE_STARTOF function when the unit parameter chosen is “day of week” or “week”.
- True
- False
In which of the following scenarios is the DATE_ADD function the optimal date function to use? Select ALL that apply.
In which of the following scenarios is the DATE_ADD function the optimal date function to use? Select ALL that apply.
- To find values in the last 30 days
- To find values in the last month.
- To add or subtract a certain number of days from a given date
- To find values in a given week.
- To find values between the start of last month, and the end of the current month