A user from human resources wants to access all records that are in the employee database. The user is not comfortable editing databases but is comfortable working in Excel.
What are two methods that an administrator can provide the information to the user in the desired format? (Choose two.)
- Using Database Command and SQL query to export the data from the database and store it in a CSV.
- The user can Iterate over the SQL query result set generated by SQL query command, one row at a time, fetching column values of current row using the "Excel column" system variable, and write the result to a CSV file row by row.
- The user can Iterate over the SQL query result set generated by the SQL query command, one row at a time, fetching column values of the current row using the "File Data column" system variable, and writing the result to a CSV file row by row.
- Using Database Command to export the result of "Run Stored procedure" command to CSV.
Reveal Solution
Next Question