Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 76
Which transformation is supported by a COPY INTO [table] command?
- A: Filter using a WHERE clause
- B: Filter using a LIMIT keyword
- C: Cast using a SELECT statement
- D: Order using an ORDER BY Clause
Question 77
How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?
- A: Review the granted privileges to the database object.
- B: Review the row access policy for the database object.
- C: Query the ACCESS_HISTORY view in the ACCOUNT_USAGE schema.
- D: Query the REPLICATION_USAGE_HISTORY view in the ORGANIZATION_USAGE schema.
Question 78
How does conditional data masking work in Snowflake?
- A: It selectively masks plain text data.
- B: It selectively masks multiple columns.
- C: It masks all values in a given column.
- D: It selectively masks a column value based on another column.
Question 79
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
- A: 60
- B: 91
- C: 120
- D: 121
Question 80
True or False: When active, a Pipe requires a dedicated Virtual Warehouse to execute.
- A: True
- B: False
Question 81
What function, combined with the copy command, should be used to unload data from a relational table into a JSON file?
- A: LATERAL
- B: CAST
- C: FLATTEN
- D: OBJECT_CONSTRUCT
Question 82
What is the primary purpose of a directory table in Snowflake?
- A: To store actual data from external stages
- B: To automatically expire file URLs for security
- C: To manage user privileges and access control
- D: To store file-level metadata about data files in a stage
Question 83
Which Snowflake table objects can be shared with other accounts? (Choose two.)
- A: Temporary tables
- B: Permanent tables
- C: Transient tables
- D: External tables
- E: User-Defined Table Functions (UDTFs)
Question 84
Which metadata table will store the storage utilization information even for dropped tables?
- A: DATABASE_STORAGE_USAGE_HISTORY
- B: TABLE_STORAGE_METRICS
- C: STORAGE_DAILY_HISTORY
- D: STAGE_STORAGE_USAGE_HISTORY
Question 85
How is role hierarchy established in Snowflake?
- A: By assigning users to roles
- B: By default when a role is created
- C: By granting one role to another role
- D: By transferring ownership of one role to another role
Question 86
What commands can be used to see what files are stored in a stage? (Choose two.)
- A: LIST
- B: SELECT
- C: LS
- D: GET
- E: DESCRIBE
Question 87
Which stages are created by default, with no need to use the CREATE STAGE command? (Choose two.)
- A: External stage
- B: Internal stage
- C: Named stage
- D: Table stage
- E: User stage
Question 88
While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
- A: BUILD_STAGE_FILE_URL
- B: GET_ABSOLUTE_PATH
- C: BUILD_SCOPED_FILE_URL
- D: GET_PRESIGNED_URL
Question 89
Who can create and manage reader accounts? (Choose two.)
- A: A user with ACCOUNTADMIN role
- B: A user with SECURITYADMIN role
- C: A user with SYSADMIN role
- D: A user with ORGADMIN role
- E: A user with CREATE ACCOUNT privilege
Question 90
Which command allows for continuous loading of data files as soon as they are available in a stage?
- A: COPY INTO [table]
- B: PUT
- C: CREATE PIPE
- D: GET
Question 91
True or False: Snowflake supports federated authentication in all editions.
- A: True
- B: False
Question 92
What is an advantage of using database roles instead of granting privileges on objects directly to a share in Snowflake?
- A: Easier management of cross-region data sharing
- B: Greater flexibility in including objects from multiple databases
- C: More control over object-level access for different user groups
- D: Reduction in the number of shares required for different objects in the same database
Question 93
What is the order of precedence (highest to lowest) of network policies when applied at the account, user, and security integrations layers?
- A: Account, user, security integration
- B: Account, security integration, user
- C: User, security integration, account
- D: User, account, security integration
Question 94
Which type of Snowflake virtual warehouse provides 16 times the memory for each node, and is recommended for larger workloads like Machine Learning (ML) training?
- A: A size 6XL warehouse
- B: A standard warehouse
- C: A multi-cluster warehouse
- D: A Snowpark-optimized warehouse
Question 95
Which common query issues can be identified by the Query Profile? (Choose two.)
- A: Insufficient credit quota
- B: Inefficient query pruning
- C: Excessive query pruning
- D: Exploding joins
- E: Credit usage that exceeds a set threshold
Question 96
In Snowflake, what allows users to perform recursive queries?
- A: QUALIFY
- B: LATERAL
- C: PIVOT
- D: CONNECT BY
Question 97
A user wants to create objects within a schema but wants to restrict other users’ ability to grant privileges on these objects.
What configuration should be used to create the schema?
- A: Use a regular (non-managed) schema.
- B: Use a managed access schema.
- C: Use a transient schema.
- D: Set the Default_DDL_Collation parameter.
Question 98
What is the MOST cost-effective way to resolve memory spillage in a virtual warehouse?
- A: Enable automatic clustering.
- B: Enable the query acceleration service.
- C: Enable the search optimization service.
- D: Convert to a Snowpark-optimized warehouse.
Question 99
What objects in Snowflake are supported by Dynamic Data Masking? (Choose two.)
- A: Views
- B: Materialized views
- C: Tables
- D: External tables
- E: Future grants
Question 100
A user has created a dashboard in Snowflake and wants to share it with colleagues.
How can the dashboard be shared?
- A: By creating a private Data Exchange
- B: By using the share option within Snowsight
- C: By using a Direct Share with another account
- D: By creating a listing on Snowflake Marketplace
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!