Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-931

Oracle 1z0-931 Exam Practice Questions (P. 4)

  • Full Access (60 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #16
If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?
  1. A
    tnsnames.ora
  2. B
    keystore.jks
  3. C
    sqlnet.ora
  4. D
    cwallet.sso
  5. E
    ojdbc.properties

Correct Answer:
AC
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-preparing.html#GUID-EFAFA00E-54CC-47C7-8C71-
E7868279EF3B

Question #17
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?
  1. A
    Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
  2. B
    Data Sync can not transform your data while loading it into the destination table.
  3. C
    Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
  4. D
    Data Sync can only load data from one source into one destination table.

Correct Answer:
C
Reference:
https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/data-sync.html

Question #18
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).
Which statement is true about the migration of the application's database success?
  1. A
    The migration can be technically a success but the 3-rd party vendor needs to support the result.
  2. B
    The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
  3. C
    The tablespace names will result in a blocking error during datapump import because of ADB limitations.
  4. D
    The migration can be a success, both technically and functional due to datapump enhancements.

Correct Answer:
B

Question #19
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.
Which statement about the migration using Golden Gate is correct?
  1. A
    Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
  2. B
    Only the migration to ADB is possible from an on-premise installation of Golden Gate.
  3. C
    Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.
  4. D
    The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.
  5. E
    The described scenario is correct, can be used for migration and fallback scenarios.

Correct Answer:
B

Question #20
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?
  1. A
    Place the credential files on a share drive that all users can use to connect to the database.
  2. B
    The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
  3. C
    Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.
  4. D
    When you share the credential files with authorized users, mail the wallet password and the file in the same email.

Correct Answer:
C

Previous Questions Next Questions

All Pages