[2021] 1Z0-931-20 PDF Questions - Perfect Prospect To Go With Pass4sureCert Practice Exam
Oracle 1Z0-931-20 Pdf Questions - Outstanding Practice To your Exam
NEW QUESTION 51
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?
- A. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
- B. Create a separate VCN that contains only public subnets
- C. Create at least 2 of each resource
- D. Only 1 of each is allowed to be allocated per environment.
Answer: A
NEW QUESTION 52
Which statement is true when you provision an Autonomous Database using the cloning method?
- A. After an Autonomous database is created using a clone, the network access option can be changed.
- B. A clone database source can be a running database instance.
- C. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.
- D. A clone database source can be from a point-in-time backup that is less than 2 hours old.
Answer: C
NEW QUESTION 53
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?
- A. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
- B. When you share the credential files with authorized users, mail the wallet password and the file in the same email.
- C. Place the credential files on a share drive that all users can use to connect to the database.
- D. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.
Answer: D
Explanation:
Connection to Autonomous DB uses certificate authentication and Secure Sockets Layer (SSL). This ensures that there is no unauthorized access to Autonomous DB and that communications between the client and server are fully encrypted and cannot be intercepted or altered.
Certification authentication uses an encrypted key stored in a wallet on both the client (where the application is running) and the server (where your database service on the Autonomous DB is running). The key on the client must match the key on the server to make a connection There's credentials zip file available for download once ADB is created, the zip file contains a collection of files, that needed to connect to your Autonomous DB. All communications between the client and the server are encrypted Wallet files, along with the Database user ID and password provide access to data in your Autonomous Transaction Processing database. Store wallet files in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), transmit the wallet password separately and securely.
For better security, Oracle recommends using restricted permissions on wallet files. This means setting the file permissions to 600 on Linux/Unix.
Similar restrictions can be achieved on Windows by letting the file owner have Read and Write permissions while all other users have no permissions.
https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/adbconnecting.htm
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-download-wallet.html#GUID-B06202D2-0597-41AA-9481-3B174F75D4B1
NEW QUESTION 54
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
- A. Neither service ignores hints by default.
- B. Both services ignore hints by default.
- C. Autonomous Data Warehouse.
- D. Autonomous Transaction Processing.
Answer: C
Explanation:
http://blog.umairmansoob.com/tag/oracle-autonomous-data-warehouse/
NEW QUESTION 55
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
- A. Schemas
- B. Reports
- C. Tablespaces
- D. Data
Answer: A,D
NEW QUESTION 56
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?
- A. Oracle Data Safe only supports Autonomous Databases.
- B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
- C. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.
- D. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
Answer: A
NEW QUESTION 57
Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.
Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)
- A. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
- B. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.
- C. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
- D. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.
Answer: A,C,D
Explanation:
SQL Developer is a free integrated development environment (IDE) provided by Oracle that simplifies the development and management of Oracle databases. A Java based platform, this IDE can run on Linux, Mac OS X, and Windows platforms. SQL Developer facilitates database migrations by providing options to use Oracle tools like Data Pump export, database copy, and SQL'Loader
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/sql-developer-web.html#GUID-102845D9-6855-4944-8937-5C688939610F
NEW QUESTION 58
Which statement is true when the Autonomous Database has auto scaling enabled?
- A. Increases the number of sessions available to the database.
- B. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.
- C. Database concurrency is scaled up when needed by the workload.
- D. Scales the PGA and SGA size when needed for the workload.
Answer: B
NEW QUESTION 59
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?
- A. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.
- B. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
- C. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
- D. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
Answer: A
NEW QUESTION 60
When exporting a notebook, what type of file is created?
- A. TXT
- B. JSON
- C. XML
- D. ASCII
- E. SQL
Answer: B
Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks- data-analysis-and-data-visualization.html#GUID-1EE10D98-DEC3-4591-9D17-72DC5EDDD77D
NEW QUESTION 61
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?
- A. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,
- B. Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure
- C. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure
- D. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database
Answer: A
NEW QUESTION 62
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
- A. Data Organization
- B. Backup Retention
- C. Undo Management
- D. Memory Usage
- E. Index Storage
Answer: A,E
NEW QUESTION 63
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?
- A. Create a database link from source database to the ADB environment and clone the PDB.
- B. Unplug into a pdb archive which can be uploaded to object storage.
- C. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
- D. Unplug to an xml file so database files and xml file can be uploaded to object storage.
Answer: C
Explanation:
Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.
NEW QUESTION 64
Which two Oracle Cloud Infrastructure database services allow you to dynamically scale both CPU and storage? (Choose two.)
- A. bare metal DB system
- B. Autonomous Data Warehouse (ADW)
- C. virtual machine DB system
- D. Autonomous Transaction Processing (ATP)
Answer: A,C
NEW QUESTION 65
Which statement is NOT correct when setting up compartment quotas?
- A. Compartment quotas are set by Oracle.
- B. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.
- C. There are three types of quota policy statements which are set, unset and zero.
- D. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
Answer: B
NEW QUESTION 66
Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).
How can they achieve this?
- A. Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.
- B. Change the Automatic Maintenance Schedule to 'No Preference'.
- C. Change the Automatic Maintenance Schedule to 'None'd.
- D. You cannot permanently disable scheduled Automatic Maintenance.
Answer: A
NEW QUESTION 67
Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)
- A. Users are given OS logons or SYSDBA privileges to prevent phishing attacking.
- B. Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
- C. Data is encrypted at rest using transparent data encryption.
- D. Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors.
Answer: B,C,D
Explanation:
In Autonomous Database, Oracle encrypt your data everywhere-whether in motion in SQL'Net traffic, and at rest in tablespaces and backups by default, each Autonomous Database service is automatically configured to use industry-standard TLS 1.2 to encrypt data in transit between the database service and clients or applications. Required client certificates and networking information are automatically packaged for the service consumer when the service is provisioned Oracle encrypt data at rest, by default the Autonomous Database is automatically encrypted using Oracle Transparent Data Encryption in tablespaces and backups
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-security.html#GUID-B26111FC-311F-4A80-96F7-E3608BEC25C7
NEW QUESTION 68
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
- A. Increasing OCPUs will automatically increase storage.
- B. Storage in TB cannot be larger than the number of OCPUs.
- C. OCPUs and storage must remain in sync.
- D. OCPUs and storage can be scaled independently.
Answer: D
Explanation:
You simply specify the number of OCPUs and the storage capacity in TB's for the database. At any time, you may scale, increase or decrease either the OCPUs or the storage capacity.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/autonomous-add-resources.html#GUID-DA72422A-5A70-42FA-A363-AB269600D4B0
NEW QUESTION 69
Which statement is true in regards to database links?
- A. Connect from Autonomous Database to remote database using a database link.
- B. You can call PL/SQL procedures and functions using a database link.
- C. Connect to Autonomous Database from remote database using a database link.
- D. Create a database link from one Autonomous Database to another Autonomous Database instance.
Answer: D
Explanation:
https://blogs.oracle.com/datawarehousing/making-database-links-from-adw-to-other-databases
NEW QUESTION 70
When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?
- A. The SQL statement completed its execution.
- B. The SQL statement did not complete either due to an error.
- C. The SQL statement is queued.
- D. The SQL statement is executing.
Answer: C
NEW QUESTION 71
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
- A. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
- B. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
- C. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.
- D. Data Sync can load your data in parallel in order to speed up the loading process.
Answer: A,D
Explanation:
http://www.ateam-oracle.com/configuring-the-data-sync-tool-for-bi-cloud-service-bics
NEW QUESTION 72
How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?
- A. Execute alter user MTHEO quota unlimited on tablespace DATA;
- B. Execute alter tablespace DATA set quota = 10G;
- C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
- D. Execute alter database for user MTHEO tablespace DATA quota = 10G;
Answer: B
NEW QUESTION 73
......
Online Questions - Outstanding Practice To your 1Z0-931-20 Exam: https://www.pass4surecert.com/Oracle/1Z0-931-20-practice-exam-dumps.html