ExamGecko
Search Search Login
Home Home / Snowflake / SnowPro Core
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A user needs to create a materialized view in the schema MYDB.MYSCHEM
Which Snowflake technique can be used to improve the performance of a query?
What is a key feature of Snowflake architecture?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Will data cached in a warehouse be lost when the warehouse is resized?

Question 151 - SnowPro Core discussion

Report
Export

Which statement is true about running tasks in Snowflake?

A.
A task can be called using a CALL statement to run a set of predefined SQL commands.
Answers
A.
A task can be called using a CALL statement to run a set of predefined SQL commands.
B.
A task allows a user to execute a single SQL statement/command using a predefined schedule.
Answers
B.
A task allows a user to execute a single SQL statement/command using a predefined schedule.
C.
A task allows a user to execute a set of SQL commands on a predefined schedule.
Answers
C.
A task allows a user to execute a set of SQL commands on a predefined schedule.
D.
A task can be executed using a SELECT statement to run a predefined SQL command.
Answers
D.
A task can be executed using a SELECT statement to run a predefined SQL command.
Suggested answer: B

Explanation:

In Snowflake, a task allows a user to execute a single SQL statement/command using a predefined schedule (B). Tasks are used to automate the execution of SQL statements at scheduled intervals.

Show Answer
asked 23/09/2024
Vilfride Lutumba
41 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms