A Data Engineer needs to ingest invoice data in PDF format into Snowflake so that the data can be queried and used in a forecasting solution.
..... recommended way to ingest this data?

• A.Use Snowpipe to ingest the files that land in an external stage into a Snowflake table
• B.Use a COPY INTO command to ingest the PDF files in an external stage into a Snowflake table with a VARIANT column.
• C.Create an external table on the PDF files that are stored in a stage and parse the data nto structured data
• D.Create a Java User-Defined Function (UDF) that leverages Java-based PDF parser libraries to parse PDF data into structured data

Comment: *

Name: *

Email: *

Verification: *

Ryan, a Data Engineer, wants to improve the performance of large, complex queries against large data sets. He decided to Scale up underlying warehouse/cluster. What is correct Snowflake consid-eration while scaling up so that he can achieve better performance results? [Select all that apply]

• A.Resizing can help reduce the queuing that occurs if a warehouse does not have enough compute resources to process all the queries that are submitted concurrently.
• B.Scaling up is not intended for handling concurrency issues; instead, use additional warehouses to handle the workload or use a multi-cluster warehouse (if this feature is available for your account).
• C.Snowflake supports resizing a warehouse at any time, even while running.
• D.Resizing a running warehouse does not impact queries that are already being processed by the warehouse; the additional compute resources, once fully provisioned, are only used for queued and new queries.
• E.Resizing between a 5XL or 6XL warehouse to a 4XL or smaller warehouse results in a brief period during which the customer is charged for both the new warehouse and the old warehouse while the old warehouse is quiesced.

Comment: *

Name: *

Email: *

Verification: *

Data Engineer Loading File named snowdata.tsv in the /datadir directory from his local machine to Snowflake stage and try to prefix the file with a folder named tablestage, please mark the correct command which helps him to load the files data into snowflake internal Table stage?

• A.put file://c:\datadir\snowdata.tsv @~/tablestage;
• B.put file://c:\datadir\snowdata.tsv @%tablestage;
• C.put file://c:\datadir\snowdata.tsv @tablestage;
• D.put file:///datadir/snowdata.tsv @%tablestage;

Comment: *

Name: *

Email: *

Verification: *

John, Data Engineer, do have technical requirements to refresh the External tables Metadata period-ically or in auto mode, which approach John can take to meet this technical specification?

• A.John can use AUTO_REFRESH parameter if the underlying External Cloud host sup-ports this for External tables.
• B.He can create a task that executes an ALTER EXTERNAL TABLE ... REFRESH statement every 5 minutes.
• C.External table cannot be scheduled via Snowflake Tasks, 3rd party tools/scripts needs to be used provided by External cloud storage provider.
• D.Snowflake implicitly take care this Infrastructure needs, as underlying warehouse layer internally manage the refresh. No action needed from John.

Comment: *

Name: *

Email: *

Verification: *

In Which Data Modelling Technique, Data Engineer generally refer the terms Hubs & Satellites?

• A.Data Hub
• B.Data Vault
• C.Star Schema
• D.Snowflake Schema

Comment: *

Name: *

Email: *

Verification: *