Question 911 · 1323 in bank
Which term is used to describe information about disk usage for operations where intermediate results cannot be accommodated in a Snowflake virtual warehouse memory?
Show answer
Answer: B
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
Which term is used to describe information about disk usage for operations where intermediate results cannot be accommodated in a Snowflake virtual warehouse memory?
Answer: B
There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?
Answer: B
A user is unloading data to a stage using this command: copy into @message from (select object_construct('id', 1, 'first_name', 'Snowflake', 'last_name', 'User', 'city', 'Bozeman')) file_format = (type = json) What will the output file in the stage be?
Answer: A
You can use the OBJECT_CONSTRUCT function combined with the COPY command to convert the rows in a relational table to a single VARIANT column and unload the rows into a file.
Source: Adapted from community discussion — vinny2020
A JSON file that contains lots of dates and arrays needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data. How can this be achieved?
Answer: A
I'm undecided between A vs. B. In a real-world task, I would do B and do some ELT if needed to prep the data for analysis. Based on the docs below, it appears that A is recommended by Snowflake as more performant. https://docs.snowflake.com/en/user-guide/semistructured-considerations Storing Semi-structured Data in a VARIANT Column vs. Flattening the Nested Structure¶ For better pruning and less storage consumption, we recommend flattening your OBJECT and key data into separate relational columns if your semi-structured data includes: Dates and timestamps, especially non-ISO 8601 dates and timestamps, as string values Numbers within strings Arrays
Source: Adapted from community discussion — 0e504b5
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
Answer: C
Which key governance feature in Snowflake allows users to identify data objects that contain sensitive data and their related objects?
Answer: B
I will choose B If the analysis determines that the column data corresponds to a semantic category, Snowflake further classifies the column to a privacy category. The privacy category has three values: identifier, quasi-identifier, or sensitive. These three values are the string values that can be specified when assigning the PRIVACY_CATEGORY Classification system tag to a column. -Identifier -Quasi-identifier -Sensitive https://docs.snowflake.com/en/user-guide/governance-classify-concepts Sensitive Data Tracking and Resource Usage Tags simplify identifying sensitive data (e.g. PII, Secret) and bring visibility to Snowflake resource usage. With data and metadata in the same system, analysts can quickly determine which resources consume the most Snowflake credits based on the tag definition (e.g. cost_center, department). https://docs.snowflake.com/en/user-guide/object-tagging However, I think that we can identify already tagged columns, whereas We can identify it initially with Data classification
Source: Adapted from community discussion — pvskbrod
What can a Snowflake user do in the Admin area of Snow right?
Answer: D
Administer Snowflake by using the Admin area of Snowsight. Use the Admin area to: Understand your Snowflake usage. Manage Snowflake warehouses. Set up and view details about resource monitors. Manage users and roles. Administer Snowflake accounts in your organization. Administer network policies and monitor session activity. Set up payment and payout methods. Review and accept the Provider and Consumer Terms of Service. Set organization contacts for Snowflake security, privacy, and product notifications. Connect to Snowflake partners to explore extended functionality.
Source: Adapted from community discussion — Learner21525
Which function generates a Snowflake hosted file URL to a staged file using the stage name and relative file path as inputs?
Answer: A
BUILD_STAGE_FILE_URL Generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs. A file URL permits prolonged access to a specified file. That is, the file URL does not expire.
Source: Adapted from community discussion — ukpino
True or False: A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.
Answer: B
Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):
Answer: D
https://docs.snowflake.com/en/user-guide/security-mfa Attention At a minimum, Snowflake strongly recommends that all users with the ACCOUNTADMIN role be required to use MFA.
Source: Adapted from community discussion — PrasantSadangi
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 911. 1323 questions available.
Version 1.0.0. How we source questions