ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam
Go to Exam

Exam 70-463 topic 3 question 35 discussion

Actual exam question from Microsoft's 70-463
Question #: 35
Topic #: 3
[All 70-463 Questions]

A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database.
To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a comma-separated values (CSV) file that contains one row per currency.
You need to download the CSV file to the environment.
What should you use to retrieve the document from the website?

  • A. a Script component
  • B. a Web Service task
  • C. a Web Service source
  • D. a Script task
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by davidkuz at March 31, 2020, 10:17 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
davidkuz
5 years, 3 months ago
why not a script component?
upvoted 1 times
sanketh
5 years, 2 months ago
Since the requirement is only to download the file and not process i.e. to traverse it. There is one more similar question to this in which script component is used due to the requirement of traversing
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel