What should you use to create a predefined query in a database for ease of use?

You're creating a synced record type which will store read-only data from an external web service. Data in the external system is updated nightly, and the latest information must be available to users in the morning. Currently there are approximately 150,000 entries in the external system, and this number is not expected to change significantly.
There is an existing integration object and associated expression rule, which when called returns the complete dataset from the external system.
What are two configurations that you must apply to ensure that the latest and complete record set is available? (Choose two.)

Your client wants to configure user authentication using single sign-on (SSO) in their cloud environment.
Which two authentication types should you use to support this requirement? (Choose two.)

You're designing an integration object with JSON (application/json) as the content type.
Which two data types can be automatically converted to JSON in Appian? (Choose two.)

You need to configure Appian user authentication against an external directory server. The requirement is to use the same corporate logon information without single sign-on (SSO).
Which authentication type should you use?