ExamGecko
Question list
Search
Search

List of questions

Search

Question 85 - DEA-C01 discussion

Report
Export

The Snowpipe API provides REST endpoints for fetching load reports. One of the Endpoint named insertReport helps to retrieves a report of files submitted via insertFiles end point whose contents were recently ingested into a table. A success response (200) contains information about files that have recently been added to the table. Response Looks like below:

A.
{
Answers
A.
{
B.
"pipe": "SNOWTESTDB.SFTESTSCHEMA.SFpipe",
Answers
B.
"pipe": "SNOWTESTDB.SFTESTSCHEMA.SFpipe",
C.
"completeResult": true,
Answers
C.
"completeResult": true,
D.
"nextBeginMark": "1_16",
Answers
D.
"nextBeginMark": "1_16",
E.
"files": [
Answers
E.
"files": [
F.
{
Answers
F.
{
G.
"path": "data4859992083898.csv",
Answers
G.
"path": "data4859992083898.csv",
H.
"stageLocation": "s3://mybucket/",
Answers
H.
"stageLocation": "s3://mybucket/",
I.
"fileSize": 89,10. "timeReceived": "2022-01-31T04:47:41.453Z",11. "lastInsertTime": "2022-01-31T04:48:28.575Z",12. "rowsInserted": 1,13. "rowsParsed": 1,14. "errorsSeen": 0,15. "errorLimit": 1,16. "complete": true,17. "status": "????"18. }19. ]20. }Which one is the correct value of status string data in the Response Body?
Answers
I.
"fileSize": 89,10. "timeReceived": "2022-01-31T04:47:41.453Z",11. "lastInsertTime": "2022-01-31T04:48:28.575Z",12. "rowsInserted": 1,13. "rowsParsed": 1,14. "errorsSeen": 0,15. "errorLimit": 1,16. "complete": true,17. "status": "????"18. }19. ]20. }Which one is the correct value of status string data in the Response Body?
J.
LOADED
Answers
J.
LOADED
K.
LOADED_SUCCESS
Answers
K.
LOADED_SUCCESS
L.
LOAD_SUCCESS
Answers
L.
LOAD_SUCCESS
M.
SUCCESS
Answers
M.
SUCCESS
Suggested answer: C

Explanation:

Permissible Load status for the file:

LOAD_IN_PROGRESS: Part of the file has been loaded into the table, but the load process has not completed yet.

LOADED: The entire file has been loaded successfully into the table.

LOAD_FAILED: The file load failed.

PARTIALLY_LOADED: Some rows from this file were loaded successfully, but others were not loaded due to errors. Processing of this file is completed.

Please not the different Response Codes available with their meaning.

200 — Success. Report returned.

400 — Failure. Invalid request due to an invalid format, or limit exceeded.

404 — Failure. pipeName not recognized.

This error code can also be returned if the role used when calling the endpoint does not have sufficient privileges. For more information, see Granting Access Privileges.

429 — Failure. Request rate limit exceeded.

500 — Failure. Internal error occurred.

As you could understand from the questions, there is 200 Success response returned, Status in the response body would be LOADED.

asked 23/09/2024
Juan Jose Montero Caletrio
30 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first