Question 1

You were asked to identify number of times a temperature sensor exceed threshold temperature (100.00) by each device, each row contains 5 readings collected every 5 minutes, fill in the blank with the appropriate functionsSchema: deviceId INT, deviceTemp ARRAY< double >, dateTimeCollected TIMESTAMP 2022-07-10-07-48-44-ce161b7b323528430beda1ec35cfd36e SELECT deviceId, __ (__ (__(deviceTemp], i -> i > 100.00)))FROM devicesGROUP BY deviceId

Options :

A : SUM, COUNT, SIZE

B : SUM, SIZE, SLICE

C : SUM, SIZE, ARRAY_CONTAINS

D : SUM, SIZE, ARRAY_FILTER

E : SUM, SIZE, FILTER

Answer: A

Question 2

Which of the following section in the UI can be used to manage permissions and grants to tables?

Options :

A : User Settings

B : Admin UI

C : Workspace admin settings

D : User access control lists

E : Data Explorer

Answer: A

Question 3

A data engineering team has two tables. The first table march_transactions is a collection of all retail

transactions in the month of March. The second table april_transactions is a collection of all retail

transactions in the month of April. There are no duplicate records between the tables.

Which of the following commands should be run to create a new table all_transactions that contains all

records from march_transactions and april_transactions without duplicate records?

Options :

A :