- All Exams Instant Download
Which permission sets must be granted to this role?
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db...
Which commands should the Architect use to load only file5.csv file from the stage?
An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously....
Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?
A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company’s business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share...
What is the BEST way to find recent and ongoing login attempts to Snowflake?
The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization’s system. What is the BEST way to find recent and ongoing login attempts to Snowflake?A . Call the LOGIN_HISTORY Information Schema table function.B . Query the LOGIN_HISTORY view in the ACCOUNT_USAGE...
Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege?
An Architect entered the following commands in sequence: USER1 cannot find the table. Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)A . GRANT ROLE PUBLIC TO ROLE INTERN;B . GRANT USAGE ON DATABASE...
To convert JSON null value to SQL null value, you will use
To convert JSON null value to SQL null value, you will useA . STRIP_NULL_VALUEB . IS_NULL_VALUEC . NULL_IFView AnswerAnswer: C Explanation: The NULL_IF function in Snowflake is used to compare two expressions, and if they are equivalent, a SQL NULL value is returned. However, when dealing with JSON data and...
Which are those?
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns. Which are those?A . RECORD_CONTENTB . RECORD_METADATAC . RECORD_MESSAGEView AnswerAnswer: A,B Explanation: Schema of Topics for Kafka Topics Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns:
How can cloning the STAGING schema be achieved?
An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. The Architect runs the following statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The...
To meet this requirement, the user’s role must have which privileges?
An Architect needs to allow a user to create a database from an inbound share. To meet this requirement, the user’s role must have which privileges? (Choose two.)A . IMPORT SHARE;B . IMPORT PRIVILEGES;C . CREATE DATABASE;D . CREATE SHARE;E . IMPORT DATABASE;View AnswerAnswer: A,C
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)
Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)A . SYSTEM$CLUSTERING_INFORMATIONB . SYSTEM$CLUSTERING_USAGEC . SYSTEM$CLUSTERING_DEPTHD . SYSTEM$CLUSTERING_KEYSE . SYSTEM$CLUSTERING_PERCENTView AnswerAnswer: A,C
