Consider the following scenario where a masking policy is applied on the CREDICARDND column of the CREDITCARDINFO table. The masking policy definition Is as follows:

Sample data for the CREDITCARDINFO table is as follows:
NAME EXPIRYDATE CREDITCARDNO
JOHN DOE 2022-07-23 4321 5678 9012 1234
if the Snowflake system rotes have not been granted any additional roles, what will be the result?

• A. The owner of the table will see the CREDICARDND column data in clear text.
• B. The sysadmin can see the CREDICARDND column data in clear text.
• C. Anyone with the Pl_ANALYTICS role will see the CREDICARDND column as*** 'MASKED* **'.
• D. Anyone with the Pl_ANALYTICS role will see the last 4 characters of the CREDICARDND column data in dear text.

Explanation: Only visible for 2Pass4sure members. You can sign-up / login (it's free).

A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
What can be done to improve performance?

• A. Alter the target table to Include additional fields pulled from the JSON records. This would Include a create_date field with a datatype of time stamp. When this field Is used in the filter, partition pruning will occur.
• B. Alter the target table to include additional fields pulled from the JSON records. This would include a create_date field with a datatype of varchar. When this field is used in the filter, partition pruning will occur.
• C. Validate the size of the warehouse being used. If the record count is approaching 100s of millions, size XL will be the minimum size required to process this amount of data.
• D. Incorporate the use of multiple tables partitioned by date ranges. When a user or process needs to query a particular date range, ensure the appropriate base table Is used.

Explanation: Only visible for 2Pass4sure members. You can sign-up / login (it's free).

A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1# SHOW GRANTS TO USER user_01;
Command 2# SHOW GRANTS ON USER user_01;
What inferences can be made about these commands?

• A. Command 1 defines all the grants which are given to user_01Command 2 defines which user owns user_01
• B. Command 1 defines all the grants which are given to user_01Command 2 defines which role owns user_01
• C. Command 1 defines which user owns user_01Command 2 defines all the grants which have been given to user_01
• D. Command 1 defines which role owns user_01Command 2 defines all the grants which have been given to user_01

Explanation: Only visible for 2Pass4sure members. You can sign-up / login (it's free).

A company needs to have the following features available in its Snowflake account:
1. Support for Multi-Factor Authentication (MFA)
2. A minimum of 2 months of Time Travel availability
3. Database replication in between different regions
4. Native support for JDBC and ODBC
5. Customer-managed encryption keys using Tri-Secret Secure
6. Support for Payment Card Industry Data Security Standards (PCI DSS)
In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

• A. Business Critical
• B. Virtual Private Snowflake (VPS)
• C. Standard
• D. Enterprise

Explanation: Only visible for 2Pass4sure members. You can sign-up / login (it's free).

A company has a Snowflake environment running in AWS us-west-2 (Oregon). The company needs to share data privately with a customer who is running their Snowflake environment in Azure East US 2 (Virginia).
What is the recommended sequence of operations that must be followed to meet this requirement?

• A. 1. Ask the customer to create a new Snowflake account in Azure EAST US 2 (Virginia)2. Create a share and add the database privileges to the share3. Alter the share and add the customer's Snowflake account to the share
• B. 1. Create a share and add the database privileges to the share2. Create a new listing on the Snowflake Marketplace3. Alter the listing and add the share4. Instruct the customer to subscribe to the listing on the Snowflake Marketplace
• C. 1. Create a reader account in Azure East US 2 (Virginia)2. Create a share and add the database privileges to the share3. Add the reader account to the share4. Share the reader account's URL and credentials with the customer
• D. 1. Create a new Snowflake account in Azure East US 2 (Virginia)2. Set up replication between AWS us- west-2 (Oregon) and Azure East US 2 (Virginia) for the database objects to be shared3. Create a share and add the database privileges to the share4. Alter the share and add the customer's Snowflake account to the share

Explanation: Only visible for 2Pass4sure members. You can sign-up / login (it's free).