- All Exams Instant Download
If the user runs the same copy into command what will happen?
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer...
Which statements will provide this access?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access? A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE; B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;...
Which command is used to unload data from a Snowflake table into a file in a stage?
Which command is used to unload data from a Snowflake table into a file in a stage?A . COPY INTOB . GETC . WRITED . EXTRACT INTOView AnswerAnswer: A Explanation: The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage....
Which copy INTO command outputs the data into one file?
Which copy INTO command outputs the data into one file?A . SINGLE=TRUEB . MAX_FILE_NUMBER=1C . FILE_NUMBER=1D . MULTIPLE=FAISEView AnswerAnswer: B Explanation: The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of...
Which command can be used to stage local files from which Snowflake interface?
Which command can be used to stage local files from which Snowflake interface?A . SnowSQLB . Snowflake classic web interface (Ul)C . SnowsightD . .NET driverView AnswerAnswer: A Explanation: SnowSQL is the command-line client for Snowflake that allows users to execute SQL queries and perform all DDL and DML operations,...
What would be the MOST efficient way to get the files into Snowflake?
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?A . Create a task that runs a copy into operation from an external stage every 5 minutesB . Create...
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?A . Compute layerB . Storage layerC . Cloud infrastructure layerD . Cloud services layerView AnswerAnswer: D Explanation: Query compilation in Snowflake occurs in the Cloud Services layer. This layer is responsible for coordinating and managing all aspects...
The fail-safe retention period is how many days?
The fail-safe retention period is how many days?A . 1 dayB . 7 daysC . 45 daysD . 90 daysView AnswerAnswer: B Explanation: Fail-safe is a feature in Snowflake that provides an additional layer of data protection. After the Time Travel retention period ends, Fail-safe offers a non-configurable 7-day period...
What happens when an external or an internal stage is dropped? (Select TWO).
What happens when an external or an internal stage is dropped? (Select TWO).A . When dropping an external stage, the files are not removed and only the stage is droppedB . When dropping an external stage, both the stage and the files within the stage are removedC . When dropping...
