Oracle 1Z0-931-26 問題集

質問 1：
A corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add any more admin responsibility to the team and is looking for a database option that’s low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
A. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis
B. Since the application needs to be highly available, it should be deployed on a Kubernetes Cluster
C. ADW since operational reporting is a higher priority in this scenario
D. ATP using 'tpurgent' and 'high' TNS services to separate connection types
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true about using an Oracle Autonomous Database with private endpoints? (Choose two.)
A. A Network Security Group is required within your Virtual Cloud Network before you can provision a shared Autonomous Database to use private endpoints.
B. An Autonomous Database with private endpoints can be accessed from the public internet by adding your IP address to an Access Control List (ACL).
C. You can configure private endpoints for an Always Free Autonomous Database
D. Private endpoints can be configured when you clone a shared Autonomous Database that was initially created with public endpoints.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three statements are true about procedures in the DBMS_CLOUD package?
A. The DBMS_CLOUD.DELETE_FILE procedure removes the credential file from the Autonomous Data Warehouse.
B. The DBMS_CLOUVALIDATE_EXTERNAL_TABLE validates the source file for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a bad file table in Autonomous Data Warehouse.
C. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
D. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from cloud object storage to the Autonomous Data Warehouse.
E. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores cloud object credentials in the Autonomous Data Warehouse.
正解：B,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database instance?
A. The destination port range is set to 1522
B. A stateless ingress rule is created to allow connections from the source to the Autonomous Database instance
C. The IP Protocol is set to TCP
D. The source is set to the address range you want to allow to connect to your database
正解：B

質問 5：
You have an Autonomous Transaction Processing Database with three OCPUs and auto-scaling turned on, and your application is using the TPURGENT service. The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support?
A. 2700
B. 1800
C. 1500
D. 900
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which statement is FALSE about setting up compartment quotas?
A. Quotas set on a parent compartment override quotas set on child compartments.
B. Compartment quotas cannot be set on the root compartment.
C. You cannot manage quotas in a compartment unless you belong to a group that has the correct permissions.
D. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
A. The target table will be created in Autonomous Database if it does not already exist.
B. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
C. The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.
D. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
A. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
B. A single fault domain can be associated with multiple regions and availability domains.
C. Regions are dependent on other regions and must be located within 5 thousand kilometers of each other.
D. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)