Question: 1
Elon, a Data Engineer, needs to Split Semi-structured Elements from the Source files and load them as an array into Separate Columns.
Source File:
1. +----------------------------------------------------------------------+
2. | $1 |
3. |----------------------------------------------------------------------|
4. | {"mac_address": {"host1": "197.128.1.1","host2": "197.168.0.1"}}, |
5. | {"mac_address": {"host1": "197.168.2.1","host2": "197.168.3.1"}} |
6. +----------------------------------------------------------------------+
Output: Splitting the Machine Address as below.
1. COL1 | COL2 |
2. |----------+----------|
3. | [ | [ |
4. | "197", | "197", |
5. | "128", | "168", |
6. | "1", | "0", |
7. | "1" | "1" |
8. | ] | ] |
9. | [ | [ |
10. | "197", | "197", |
11. | "168", | "168", |
12. | "2", | "3", |
13. | "1" | "1" |
14. | ] | ]
Which SnowFlake Function can Elon use to transform this semi structured data in the output for-mat?
Question: 2
For enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks, which two glob-al/account privileges snowflake provide?
Question: 3
Which is the non-supportable JavaScript UDF data types?
Question: 4
Mark the Incorrect Statements with respect to types of streams supported by Snowflake?
Question: 5
Snowflake supports using key pair authentication for enhanced authentication security as an alterna-tive to basic authentication (i.e. username and password). Select the list of SnowFlake Clients sup-port the same? [Select All that Apply]
