1z0-070試験無料問題集（105題）「Oracle Exadata X5 Administration 認定」

出題：1

You plan to partition the database and storage grids in an X5-2 full rack, creating two clusters and two storage grids without using virtualization.
One cluster will be used for production and should consist of six database servers and nine storage servers.
The other cluster will be used for test and development, and should consist of two database servers and five storage servers.
The storage must be partitioned so that the storage servers are visible only to the appropriate database servers that are meant to access them.
What must be done to achieve this?

A. Configure Exadata realms using Oracle ASM-scoped security mode.

B. Edit the CELLIP.ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.

C. Edit the CELLIP.ORA file on each database server to contain IP addresses of database servers which are allowed access to specific storage servers in the same storage grid.

D. Configure Exadata realms using Database-scoped security mode.

E. Edit the CELLINIT.ORA file on each database server to contain IP addresses of storage servers in the storage grid associated with the cluster to which that database server belongs.

F. Edit the CELLIP.ORA file on each storage server to contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that storage server belongs.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle's recommended best practices.
Which three actions could you take to do this?

A. Use exachk to schedule itself to run at regular intervals.

B. Run it once each cell and it will then perform periodic monitoring automatically.

C. Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.

D. Use a cron job on a database node to run it at regular intervals.

E. Use a cron job on each cell to run it at regular intervals.

正解：A,C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Identify three valid configuration options that can be implemented during the initial configuration process of a new X5 Database Machine by using the Exadata Deployment Assistant.

A. The size for the system area on the first two disks in each cell

B. Virtualized Storage node configuration

C. Virtualized Compute Node configuration

D. OS users that own the Grid Infrastructure installation

E. Cluster configuration for up to 32 clusters

正解：A,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You are checking the status of the ports on one of the InfiniBand switches on your X5 Database Machine.
You run the getportstatus command as shown:
[root@exampsw-ib2 bin]# getportstatus 17b
Port status for connector 17B Switch Port 2
Adminstate:......................Enabled
LinkWidthEnabled: ...............1X or 4X
LinkWidthSupported:..............1X or 4X
LinkWidthActive..................4X
LinkSpeedSupported: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps
LinkState: ......................Active
PhysLinkState: ................LinkUp
LinkSpeedActive: ..............10.0 Gbps
LinkSpeedEnabled: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps
You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?

A. Use Enterprise Manager Express.

B. Use the ibqueryerrors.pl script after logging in to the InfiniBand switch as root.

C. Use Enterprise Manager.Cloud Control.

D. Create user-defined metrics for the InfiniBand switch.

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?

A. The Infiniband subnet master location can be determined by using the getmaster command run on any database server.

B. The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility.

C. The InfiniBand port monitoring is automatic on the database servers and is managed by Enterprise Manager.

D. The InfiniBand port status may be displayed on the Infiniband switches by using the LIST IBPORT command in the DBMCLI utility.

E. The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.

F. The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch.

正解：B,E,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which three statements are true about Automatic Hard Disk Scrubbing and repair on high-capacity storage servers in an X5 Database Machine?

A. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.

B. Hard disks are scanned every two weeks by default in all situations.

C. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.

D. Hard disks are scanned every two weeks by default but only when disks are idle.

E. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.

正解：A,B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

You are evaluating the performance of a SQL statement that accesses a very large table.
You run this query:

Identify two reasons why the "physical read total bytes" statistic is greater than the "cell physical IO bytes eligible for predicate offload" statistic.

A. There are migrated rows in the table, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.

B. The table is an index clustered table, causing "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.

C. The table is an IOT and has an overflow segment, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O.

D. There is an index on the column used in the WHERE clause, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O.

E. There is an uncommitted transaction that has modified some of the table blocks, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

You applied patches to both the storage servers and the database servers in your Exadata X6 Database Machine.
You use Database Replay for a 90-minute workload to verify that there are no performance regressions after applying the patches.
Which three options could you use to immediately measure the performance and to check for possible regressions caused by changes in the storage server software?

A. cellcli list metriccurrent

B. SQL trace using dbms_monitor

C. cellcli list metrichistory

D. SQL Access Advisor

E. cellcli list alerthistory

正解：A,B,D 解答を投票する

出題：9

Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?

A. Oracle Solaris must be used on the server where ASR Manager is installed.

B. SMTP must be enabled on at least one database server.

C. ASR Manager must be installed on one of the database servers.

D. ASR Manager may be installed on any type of server running Oracle Solaris.

E. Oracle Linux must be used on the server where ASR Manager is installed.

F. ASR Manager may be installed on any type of server running Oracle Linux.

G. HTTPS connectivity must be enabled from the ASR Manager host to the Internet.

正解：D,F,G 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z0-070試験無料問題集「Oracle Exadata X5 Administration 認定」