Question list
List of questions
Related questions
Question 39 - DEA-C01 discussion
Pascal, a Data Engineer, have requirement to retrieve the 10 most recent executions of a specified task (completed, still running, or scheduled in the future) scheduled within the last hour, which of the following is the correct SQL Code ?
A.
B.
select *
C.
from table(information_schema.task_history(
D.
scheduled_time_range_start=>dateadd('hour',-1,current_timestamp()),
E.
result_limit => 10,
F.
task_name=>'MYTASK') WHERE query_id IS NOT NULL);
G.
H.
select *
I.
from table(information_schema.task_history(
J.
scheduled_time_range_start=>dateadd('hour',-1,current_timestamp()),
K.
result_limit => 11,
L.
task_name=>'MYTASK') WHERE query_id IS NOT NULL);
M.
N.
select *
O.
from table(information_schema.task_history(
P.
scheduled_time_range_start=>dateadd('hour',-1,current_timestamp()),
Q.
result_limit => 10,query_id IS NOT NULL
R.
task_name=>'MYTASK'));
S.
T.
select *
U.
from table(information_schema.task_history(
V.
scheduled_time_range_start=>dateadd('hour',-1,current_timestamp()),
W.
result_limit => 10,
X.
task_name=>'MYTASK'));
Previous
Next
Your answer:
0 comments
Sorted by
Leave a comment first
