Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 81

Based on the architecture in the image, how can the data from DB1 be copied into TBL2? (Choose two.)

    Correct Answer: D, E

    To copy data from DB1 into TBL2, the code must specify the correct database, schema, table, stage, and file format details. In order for the copying process to work correctly, the stage and file format must be fully qualified because they are located in a different schema (SH1) from the target table (located in SH2). Option E correctly uses fully qualified names for both the stage and the file format, and it specifies using the SH2 schema where TBL2 resides. Option D also correctly uses qualified names, following the proper syntax for referencing the stage and file format from SH1 while targeting the TBL2 table in SH2. Therefore, the correct answers are E and D.

Discussion
Atomic_GeckoOptions: AE

A & E are the only ones with qualified names that will work

cui_liOptions: AE

A & E should be correct.