nerdexam
Oracle

1Z0-1072 · Question #76

Where do you find the tnsnames.ora for your Autonomous Data Warehouse (ADW) database?

The correct answer is B. The tnsnames.ora file is included in credentials.zip file that you download from service console of. https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect- intorduction.html#GUID-CD4C10A6-1C1E-4969-8F67-1433B6CE626A To download client credentials from the Autonomous Transaction Processing Service Console: - From the Service Console click the…

Database Services

Question

Where do you find the tnsnames.ora for your Autonomous Data Warehouse (ADW) database?

Options

  • AYou can download tnsnames.ora from Oracle Cloud Infrastructure web console under ADW details
  • BThe tnsnames.ora file is included in credentials.zip file that you download from service console of
  • CThe ADW database will place the tnsnames.ora file in an object storage bucket
  • DYou are automatically prompted to download the tnsnames.ora file upon creation of the ADW

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    82% (23)
  • C
    11% (3)
  • D
    4% (1)

Explanation

https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect- intorduction.html#GUID-CD4C10A6-1C1E-4969-8F67-1433B6CE626A To download client credentials from the Autonomous Transaction Processing Service Console: - From the Service Console click the Administration link. - Click Download Client Credentials (Wallet). - On the Download Client Credentials (Wallet) page, enter a wallet password in the Password field and confirm the password in the Confirm Password field. The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character. This password protects the downloaded Client Credentials wallet. - Click Download to save the client security credentials zip file. By default the filename is: Wallet_databasename.zip. You can save this file as any filename you want. You must protect this file to prevent unauthorized database access. The zip file includes the following: tnsnames.ora and sqlnet.ora: Network configuration files storing connect descriptors and SQL*Net client side configuration. cwallet.sso and ewallet.p12: Auto-open SSO wallet and PKCS12 file. PKCS12 file is protected by the wallet password provided in the UI. keystore.jks and truststore.jks: Java keystore and truststore files. They are protected by the wallet password provided while downloading the wallet. ojdbc.properties: Contains the wallet related connection property required for JDBC connection. This should be in the same path as tnsnames.ora.

Topics

#ADW#tnsnames.ora#credentials.zip#connection configuration

Community Discussion

No community discussion yet for this question.

Full 1Z0-1072 Practice