Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 751:

  What is a key feature of Snowflake architecture?

  A. Zero-copy cloning creates a mirror copy of a database that updates with the original

  B. Software updates are automatically applied on a quarterly basis

  C. Snowflake eliminates resource contention with its virtual warehouse implementation

  D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters

  E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

  Correct Answer: C

• Question 752:

  A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

  A. It removes the last element of the outer array.

  B. It removes the outer array structure and loads the records into separate table rows,

  C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

  D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

  Correct Answer: B

  Data Size Limitations The VARIANT data type imposes a 16 MB size limit on individual rows. For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported. If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO [table] command to remove the outer array structure and load the records into separate table rows: copy into [table] from @~/[file].json file_format = (type = 'JSON' strip_outer_array = true);

  https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

• Question 753:

  Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

  A. Load files that are approximately 25 MB or smaller.

  B. Remove all dates and timestamps.

  C. Load files that are approximately 100-250 MB (or larger)

  D. Avoid using embedded characters such as commas for numeric data types

  E. Remove semi-structured data types

  Correct Answer: CD

  https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

• Question 754:

  A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

  A. The primary cluster in the virtual warehouse

  B. The entire virtual warehouse

  C. The database in which the virtual warehouse resides

  D. The Queries currently being run on the virtual warehouse

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.

• Question 755:

  What is the purpose of an External Function?

  A. To call code that executes outside of Snowflake

  B. To run a function in another Snowflake database

  C. To share data in Snowflake with external parties

  D. To ingest data from on-premises data sources

  Correct Answer: A

  https://docs.snowflake.com/en/sql-reference/external-functions.html

• Question 756:

  What tasks can be completed using the copy command? (Select TWO)

  A. Columns can be aggregated

  B. Columns can be joined with an existing table

  C. Columns can be reordered

  D. Columns can be omitted

  E. Data can be loaded without the need to spin up a virtual warehouse

  Correct Answer: CD

• Question 757:

  In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

  A. Compute Credits = 50 Credits Cloud Services = 10

  B. Compute Credits = 80 Credits Cloud Services = 5

  C. Compute Credits = 10 Credits Cloud Services = 9

  D. Compute Credits = 120 Credits Cloud Services = 10

  E. Compute Credits = 200 Credits Cloud Services = 26

  Correct Answer: AE

• Question 758:

  A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

  A. Yes, because a table owner has full control and can unset masking policies.

  B. Yes, because masking policies only apply to cloned tables.

  C. No, because masking policies must always reference specific access roles.

  D. No, because ownership of a table does not include the ability to change masking policies

  Correct Answer: D

• Question 759:

  What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

  A. The ability to scale up warehouses

  B. The use of warehouse auto scaling

  C. The ability to resize warehouses

  D. Use of multi-clustered warehouses

  E. The use of warehouse indexing

  Correct Answer: BD

• Question 760:

  Which services does the Snowflake Cloud Services layer manage? (Select TWO).

  A. Compute resources

  B. Query execution

  C. Authentication

  D. Data storage

  E. Metadata

  Correct Answer: CE

  https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider. Services managed in this layer include: Authentication Infrastructure management Metadata management Query parsing and optimization Access control