- All Exams Instant Download
True or False: Pipes can be suspended and resumed.
True or False: Pipes can be suspended and resumed.A . True B. FalseView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:
The PUT command: (Choose two.)
The PUT command: (Choose two.)A . Automatically creates a File Format object B. Automatically uses the last Stage created C. Automatically compresses files using Gzip D. Automatically encrypts filesView AnswerAnswer: C,D Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake Editions B. Is only available to customers with Business Critical Edition C. Restricts or enables access to specific IP addresses D. Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...
Which copy INTO command outputs the data into one file?
Which copy INTO command outputs the data into one file?A . SINGLE=TRUE B. MAX_FILE_NUMBER=1 C. FILE_NUMBER=1 D. MULTIPLE=FAISEView AnswerAnswer: B
Which command can be used to load data into an internal stage?
Which command can be used to load data into an internal stage?A . LOAD B. copy C. GET D. PUTView AnswerAnswer: D Explanation: https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:A . Concurrency B. PerformanceView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.
True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.A . True B. FalseView AnswerAnswer: A Explanation: AWS PrivateLink provides a secure connection from the customer's on-premise data center to Snowflake. It establishes a private connection between the customer's VPC (Virtual...
What is the default File Format used in the COPY command if one is not specified?
What is the default File Format used in the COPY command if one is not specified?A . CSV B. JSON C. Parquet D. XMLView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)A . JDBC B. SnowSQL C. Snowflake Web Interface (UI) D. ODBC E. PythonView AnswerAnswer: A,B,C,D,E Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
True or False: You can query the files in an External Stage directly without having to load the data into a table.
True or False: You can query the files in an External Stage directly without having to load the data into a table.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used...
