Question No : 1
Which of the below are true about external functions

• A.External functions can be overloaded; two different functions can have the same name but different signatures (different numbers or data types of input parameters).
• B.External functions cannot be overloaded
• C.External functions can accept parameters.
• D.The returned value can be a compound value, such as a VARIANT that contains JSON

Show Answers

Answer:

Question No : 2
Which of the below are true about TASKS?

• A.A TASK can have multiple predecessors
• B.Users can define a simple tree-like structure of tasks that starts with a root task and is linked together by task dependencies
• C.All tasks in a simple tree must have the same task owner
• D.A task must be resumed after creation of the TASK

Show Answers

Answer:

Question No : 3
Let's say you have a schema name MY_SCHEMA. This schema contains two permanent tables as shown below
CREATE TABLE MY_TABLE_A (C1 INT)
DATA_RETENTION_TIME_IN_DAYS = 10;
CREATE TABLE MY_TABLE_B (C1 INT);
What will be the impact of running the following command?
ALTER SCHEMA MY_SCHEMA SET DATA_RETENTION_TIME_IN_DAYS = 20;
A. Data retention time cannot be set at SCHEMA level, hence it will fail
B. The retention time on MY_TABLE_A does not change; MY_TABLE_B will be set to 20 days
C. The retention time on both the tables will be set to 20 days
D. The retention time will not change for both tables

Show Answers

Answer:B
Explanation
https://docs.snowflake.com/en/user-guide/data-time-travel.html#changing-the-data-retention-period-for-an-object
Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set. For example:
If you change the retention period at the account level, all databases, schemas, and tables that do not have an explicit retention period automatically inherit the new retention period.
If you change the retention period at the schema level, all tables in the schema that do not have an explicit retention period inherit the new retention period.
Keep this in mind when changing the retention period for your account or any objects in your account because the change might have Time Travel consequences that you did not anticipate or intend. In particular, we do not recommend changing the retention period to 0 at the account level.

Question No : 4
While using kafka connector, what charges are applied to your account?

• A.Snowpipe processing time
• B.Data storage
• C.Kafka connector usage

Show Answers

Answer:

Question No : 5
CREATE OR REPLACE USER USER1 PASSWORD='USER1';
CREATE OR REPLACE ROLE ROLE1;
CREATE OR REPLACE ROLE ROLE2;
CREATE OR REPLACE ROLE ROLE3;
GRANT ROLE ROLE1 TO ROLE ROLE2;
GRANT ROLE ROLE2 TO ROLE ROLE3;
CREATE OR REPLACE TABLE T1(ID VARCHAR, NAME VARCHAR);
GRANT SELECT ON T1 to ROLE1;
GRANT INSERT,DELETE ON T1 TO ROLE2;
GRANT ROLE ROLE3 TO USER USER1;
Which of the accesses below will USER 1 get for Table T1;

• A.SELECT, INSERT, DELETE
• B.SELECT, INSERT, DELETE, TRUNCATE
• C.SELECT, INSERT, DELETE, COPY INTO
• D.SELECT, INSERT, DELETE, TRUNCATE, COPY INTO

Show Answers

Answer:

Question No : 6
CREATE OR REPLACE USER USER1 PASSWORD='USER1';
CREATE OR REPLACE ROLE ROLE1;
CREATE OR REPLACE ROLE ROLE2;
CREATE OR REPLACE ROLE ROLE3;
GRANT ROLE ROLE1 TO ROLE ROLE2;
GRANT ROLE ROLE2 TO ROLE ROLE3;
GRANT ROLE ROLE3 TO USER USER1;
When user will logon to SNOWFLAKE, which roles he will see in the UI under switch role?

• A.ROLE1
• B.ROLE2
• C.ROLE3
• D.PUBLIC
• E.SYSADMIN

Show Answers

Answer:

Question No : 7
Which of the below query is valid when clustering key has not been defined on the table test2?

• A.select system$clustering_information('test2', '(col1, col3)');
• B.select system$clustering_information('test2');
• C.select system$clustering_information('test2', 'columns=col1, col3');

Show Answers

Answer:

Question No : 8
Snowflake does not prune micro-partitions based on a predicate with a subquery

• A.TRUE
• B.FALSE

Show Answers

Answer:

Question No : 9
What is the problem with the below query profile?

• A.There is a join explosion
• B.0.03 MB bytes were scanned
• C.Poor partition pruning

Show Answers

Answer:

Question No : 10
A stream contains table data

• A.True
• B.False

Show Answers

Answer: