Free Access Snowflake.SnowPro-Core.v2022-06-27.q91 Practice Test (Page 5)

Question 16

What command is used to load files into an Internal Stage within Snowflake? Select one.

A.PUT

B.COPY INTO

C.TRANSFER

D.INSERT

Question 17

Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers

A.Information Schema -> TABLE_STORAGE_METRICS

B.SHOW STORAGE BY TABLE;

C.SHOW TABLES;

D.Information Schema -> TASLE_HISTORY

Question 18

What happens when a Data Provider revokes privileges to a Share on an object in their source database?

A.The Data Consumers stop seeing data updates and become responsible for storage charges for the object

B.The object immediately becomes unavailable for all Data Consumers

C.A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

D.Any additional data arriving after this point in time will not be visible to Data Consumers

Question 19

Which statements are true of micro-partitions?
Choose 2 answers

A.They are approximately 16MB in size

B.They are stored compressed only if COMPRESS=TRUE on Table

C.They are Immutable

D.They are only encrypted in the Enterprise edition and above

Question 20

How would you execute a series of SQL statements using Task?

A.A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);

B.A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():

C.include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..
INSERT INTO target2 SELECT .. FROM stream .s1 where ..

D.Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.

Other Version: 2115Snowflake.SnowPro-Core.v2025-02-18.q136; 1801Snowflake.SnowPro-Core.v2024-03-20.q154; 2097Snowflake.SnowPro-Core.v2023-03-14.q81; 2250Snowflake.SnowPro-Core.v2022-05-06.q56; 2393Snowflake.SnowPro-Core.v2022-03-21.q79; 2714Snowflake.SnowPro-Core.v2021-11-10.q46; 59Snowflake.Exams4sures.SnowPro-Core.v2021-09-20.by.valentine.62q.pdf

Latest Upload: 448PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 584Nokia.4A0-113.v2026-05-01.q69; 615EC-COUNCIL.312-49v11.v2026-04-30.q214; 598Microsoft.MB-820.v2026-04-30.q101; 439Salesforce.MC-202.v2026-04-30.q57; 481BICSI.INSTC_V8.v2026-04-29.q53; 585NMLS.MLO.v2026-04-28.q82; 404NCARB.Project-Management.v2026-04-28.q27; 761EMC.D-AV-DY-23.v2026-04-27.q184; 1989ServiceNow.CSA.v2026-04-27.q483

Question 16

Question 17

Question 18

Question 19

Question 20

Download PDF File