1z0-931

1z0-931 practice questions, page 2 of 3, with answer review and explanations.

Question 6

Which two statements are true with regards to Oracle Data Sync? (Choose two.)

  1. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
  2. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
  3. Data Sync can load your data in parallel in order to speed up the loading process.
  4. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.

Question 7

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

  1. In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
  2. The Oracle Client Credential file is downloaded as a ZIP file.
  3. The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
  4. You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.

Question 8

What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?

  1. ADBDEV
  2. ADMIN
  3. DWROLE
  4. ADWC

Question 9

Which two system privileges does a user need to create analytic views? (Choose two.)

  1. CREATE ANALYTIC MEASURE
  2. CREATE ANALYTIC LEVEL
  3. CREATE ANALYTIC HIERARCHY
  4. CREATE ANALYTIC VIEW
  5. CREATE ATTRIBUTE DIMENSION

Question 10

What are three methods to load data into the Autonomous Database? (Choose three.)

  1. Oracle GoldenGate
  2. Transportable Tablespace
  3. RMAN Restore
  4. Oracle Data Pump
  5. SQL*Loader