SnowPro Core Exam Practice Questions Part 3;
Questions and Answers 100% Pass
What is a SF virtual warehouse? Correct Ans-Virtual warehouse is the name given to the
compute clusters used by SF for query processing.
Which options can be used to bring semi structured data into SF? Correct Ans-Load semi
structured data into a VARIANT column; Transform the data while using the COPY command
T/F - A Small virtual warehouse (2 servers) executing for 2 hours will consume the same
number of credits as a Medium virtual warehouse (4 servers) executing for 1 hour Correct
Ans-True - with a larger size the credit consumption is more
In the SF staged release process for new releases, which account types are applied updates
ahead of everyone else? Correct Ans-Designated accounts opting for early access
The reader account belongs to: Correct Ans-The producer - created by, owned by, uses the
compute resources of the producer
T/F - In a VARIANT column, the NULL values are stored as a literal string "null" Correct Ans-
True
, SnowPro Core Exam Practice Questions Part 3;
Questions and Answers 100% Pass
Under the Download section in Snowflake Web UI, what are the connectors & programs that
can be downloaded? Correct Ans-Spark Connector, Python Components, Node.js driver;
not Redshift connector or Unload connector
Y/N - SF stores data for each table in a proprietary columnar format Correct Ans-Yes
On the WebUI, which button on the top bar should you select to run queries? Correct Ans-
Worksheets
To see existing virtual warehouses, what is the correct command? Correct Ans-SHOW
WAREHOUSES;
You are creating a new virtual warehouse that you want to auto suspend if no query has been
run in last 10 minutes. What is the correct syntax for creating such a virtual warehouse?
Correct Ans-CREATE OR REPLACE WAREHOUSE brand_new_warehouse
WAREHOUSE_SIZE=large AUTO_SUSPEND=600;
Questions and Answers 100% Pass
What is a SF virtual warehouse? Correct Ans-Virtual warehouse is the name given to the
compute clusters used by SF for query processing.
Which options can be used to bring semi structured data into SF? Correct Ans-Load semi
structured data into a VARIANT column; Transform the data while using the COPY command
T/F - A Small virtual warehouse (2 servers) executing for 2 hours will consume the same
number of credits as a Medium virtual warehouse (4 servers) executing for 1 hour Correct
Ans-True - with a larger size the credit consumption is more
In the SF staged release process for new releases, which account types are applied updates
ahead of everyone else? Correct Ans-Designated accounts opting for early access
The reader account belongs to: Correct Ans-The producer - created by, owned by, uses the
compute resources of the producer
T/F - In a VARIANT column, the NULL values are stored as a literal string "null" Correct Ans-
True
, SnowPro Core Exam Practice Questions Part 3;
Questions and Answers 100% Pass
Under the Download section in Snowflake Web UI, what are the connectors & programs that
can be downloaded? Correct Ans-Spark Connector, Python Components, Node.js driver;
not Redshift connector or Unload connector
Y/N - SF stores data for each table in a proprietary columnar format Correct Ans-Yes
On the WebUI, which button on the top bar should you select to run queries? Correct Ans-
Worksheets
To see existing virtual warehouses, what is the correct command? Correct Ans-SHOW
WAREHOUSES;
You are creating a new virtual warehouse that you want to auto suspend if no query has been
run in last 10 minutes. What is the correct syntax for creating such a virtual warehouse?
Correct Ans-CREATE OR REPLACE WAREHOUSE brand_new_warehouse
WAREHOUSE_SIZE=large AUTO_SUSPEND=600;
