Based on the architecture in the image, how can the data from DB1 be copied into TBL2? (Choose two.)
Based on the architecture in the image, how can the data from DB1 be copied into TBL2? (Choose two.)
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.
A & E are the only ones with qualified names that will work
A & E should be correct.