Snowflake DEA-C01 SnowPro Advanced: Data Engineer Certification Exam Exam Practice Test Questions

• Question 1

  PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove par-titions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?

  • TRUE
  • FALSE

  Show Answer Answer: A Next

• Question 2

  In one of your created Schema, you have been required to create Internal Stages, what are the In- correct considerations you can noticed from the below options? [Select All that Apply]

  • User stages can be altered or dropped just like Table Stage.
  • Table stage type is designed to store files that are staged and managed by one or more users but only loaded into a single table.
  • A named internal stage type can store files that are staged and managed by one or more users and loaded into one or more tables.
  • A table stage is available for each table created in Snowflake.

  Show Answer Answer: A Next

• Question 3

  Data Engineer wants to analyze query performance & looking out for profiling information, He went to Query/Operator Details also called Profile Overview of Query Profile Interface & searching for statistics attributes around I/O. Which of the following information he can’t get from there?

  • Percentage scanned from cache — the percentage of data scanned from the local disk cache.
  • Bytes written — bytes written (e.g. when loading into a table).
  • External bytes scanned — bytes read from an external object, e.g. a stage.
  • Bytes sent over the wireframe — amount of data sent over the wireframe
  • Bytes read from result — bytes read from the result object.

  Show Answer Answer: D Next

• Question 4

  What are Common Query Problems a Data Engineer can identified using Query Profiler?

  • “Exploding” Joins i.e Joins resulting due to a “Cartesian product”
  • Queries Too Large to Fit in Memory
  • Inefficient Pruning
  • Ineffective Data Sharing

  Show Answer Answer: A, ,B, ,C Next

• Question 5

  Mark the Incorrect Statements with respect to types of streams supported by Snowflake?

  • Standard streams cannot retrieve update data for geospatial data.
  • An append-only stream returns the appended rows only and therefore can be much more performant than a standard stream for extract, load, transform (ELT).
  • Insert-only Stream supported on external tables only.
  • An insert-only stream tracks row inserts & Delete ops only

  Show Answer Answer: D Next