- All Exams Instant Download
Snowflake has row level security
Snowflake has row level securityA . TRUE B. FALSEView AnswerAnswer: A Explanation: The below is an old Explanation: -------------- Currently row level security is not available in Snowflake. There is a work around to achieve this using views and permissions. New Explanation: ------- Snowflake has introduced row level security now....
How can this query be interpreted?
An Architect runs the following SQL query: How can this query be interpreted?A . FILEROWS is a stage. FILE_ROW_NUMBER is line number in file. B. FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table. C. FILEROWS is a file. FILE_ROW_NUMBER is the file format location. D. FILERONS...
Which of the below commands will use warehouse credits?
Which of the below commands will use warehouse credits?A . SHOW TABLES LIKE 'SNOWFL%'; B. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE; C. SELECT COUNT(*) FROM SNOWFLAKE; D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;View AnswerAnswer: D Explanation: Try this your self CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); INSERT INTO SNOWFLAKE VALUES(1111,...
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: B,C
Which option will you choose to setup the access?
Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only. Which option will you choose...
Which of the below commands will use warehouse credits?
Which of the below commands will use warehouse credits?A . SHOW TABLES LIKE 'SNOWFL%'; B. SELECT MAX(FLAKE_ID) FROM SNOWFLAKE; C. SELECT COUNT(*) FROM SNOWFLAKE; D. SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;View AnswerAnswer: D Explanation: Try this your self CREATE TABLE SNOWFLAKE (FLAKE_ID INTEGER, UDEMY_COURSE VARCHAR); INSERT INTO SNOWFLAKE VALUES(1111,...
For which use cases, will you use cross-cloud and cross-region replication?
For which use cases, will you use cross-cloud and cross-region replication?A . Business continuity and disaster recovery B. Secure data sharing across regions/cloud C. Data portability and account migrations D. All of theseView AnswerAnswer: D Explanation: All of these are uses cases for cross-cloud/region replication
You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.
You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve. What may be the most possible cause of this.A...
For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.
For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.A . FALSE B. TRUEView AnswerAnswer: B Explanation: PATTERN = 'regex_pattern' A regular expression pattern string, enclosed in single quotes, specifying the file names and/or paths...
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?A . CONTINUE B. SKIP_FILE C. ABORT_STATEMENT D. FAILView AnswerAnswer: A,B,C Explanation: Copy Options (copyOptions) You can specify one or more of the following copy options (separated by blank spaces, commas, or new lines):...
