Adaface Sample Qlik Sense Questions

We are loading data from a third party source using a Qlik REST connector. Our use case requires that the REST endpoint be called multiple times and pass different values into a query parameter each time, so that we can retrieve all the data we require. The URL and the other query parameters remain the same between calls. We have already set up a REST connector with the appropriate URL and static query parameters.

We have stored the parameter values in a table in the data model. These values have been previously loaded and may change during each data reload. You are hired as the data architect to temporarily replace the previous architect who is currently on paternity leave. Which steps will you take to retrieve all data?

Our client is a retailer with stores across the country has shared the following requirements for the Qlik Sense app we are building for them.
            
            - Load data from SQL Server for 18 stores
            - Load data from Oracle for 7 stores
            - All data should be refreshed once per day
            - Users must see details of every transaction
            - Most users should only see data for their store
            - Some users (management) will have access to all data
            
            Which of these approaches do you recommend we take?