A fully updated 2021 1z0-070 Exam Dumps exam guide from training expert RealExamFree [Q52-Q77]

A fully updated 2021 1z0-070 Exam Dumps exam guide from training expert RealExamFree

Provides complete coverage of every objective on exam and exam preparation 1z0-070

NEW QUESTION 52
You are designing the monitoring architecture and procedures for an X5 Database Machine fabric consisting of two full racks, to provide for the monitoring for all components on the critical path of the admin network.
Which two components need to be monitored?

• A. the InfiniBand spine switches
• B. the Cisco 48 port Catalyst Ethernet Switch
• C. the power distribution units
• D. the Infiniband leaf switches

Answer: A,B

Explanation:
Explanation/Reference:
The Cisco Catalyst 4948 Ethernet switch is supplied with the Oracle Exadata Rack.
D: Figure: Running the Subnet Manager in Different Rack Configurations

References:
https://docs.oracle.com/cd/E18476_01/doc.220/e18478/GUID-9FF8B5B0-3481-4B73-89D3-
108CBD7EB989.htm#ELMOG76346
http://docs.oracle.com/cd/E80920_01/DBMIN/configuring-exadata.htm#DBMIN21274

 

NEW QUESTION 53
Examine this IORM plan:

Which two are true concerning this plan?

• A. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.
• B. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.
• C. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.
• D. The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.
• E. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.

Answer: B,E

Explanation:
The IORM plan can be configured using the ALTER IORMPLAN command on command-line interface (CellCLI) utility on each Exadata storage cell. It consists of two parameters - dbplan and catplan. While the "dbplan" is used to create the I/O resource directives for the databases, the "catplan" is used to allocate resources by workload category consolidated on the target system.
allocation/share - Specify the resource allocation to a specific database in terms of percentage or shares.
limit - Specify maximum limit of disk utilization for a database.

 

NEW QUESTION 54
You have partitioned an X5-2 full rack into two four-node RAC clusters called CLUSA and CLUSB.
No virtualization is used and the storage grid has not been partitioned.
Which two set of files on which servers must be modified after connecting an Exadata storage expansion rack to your X5-2 Exadata Database Machine on the InfiniBand network so that the storage servers in the expansion rack are added to the storage grid?

• A. the CELLIP.ORA files on the database servers in CLUSB
• B. the CELLIP.ORA files on all newly added Exadata storage servers
• C. the CELLINIT.ORA files on the database servers in CLUSB
• D. the CELLINIT.ORA files on the database servers in CLUSA
• E. the CELLIP.ORA files on the database servers in CLUSA
• F. the CELLIP.ORA files on all existing Exadata storage servers

Answer: A,E

Explanation:
Explanation/Reference:
The cellip.ora is the configuration file, on every compute node (database server), that tells ASM instances which cells are available to this cluster.
The cellip.ora file contains the storage cell IP addresses.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- configuring.htm#SAGUG20369

 

NEW QUESTION 55
Which three are true concerning Exadata snapshot databases?

• A. They don't support all Exadata features.
• B. They can be created on any type of ASM disk group.
• C. They are supported on non-container databases.
• D. They are integrated with the Multitenant architecture.
• E. They are based on a read-write copy of an existing database.
• F. They can be created only on sparse ASM disk groups.

Answer: C,D,F

Explanation:
A: An Exadata snapshot database can be either a non-container database (non-CDB) or a container database (CDB). Creating an Exadata snapshot database of a CDB enables access to all of the pluggable databases in that container.
C: You can create two types of Exadata snapshots, depending on the current setup of your environment:
* You have a pluggable database (PDB) and want to create a test master from it.
* You have a container database (CDB) and want to create test masters from all its PDBs, or you have a simple non-container database and want to create a test master from it.
D: SPARSE disk group based database snapshots is functionality included in Exadata Storage Software. It requires Exadata Storage Software version 12.1.2.1.0 and Oracle Database 12c version 12.1.0.2 with bundle patch 5 or later. This feature is designed to work on native Exadata ASM storage disk groups. It uses ASM SPARSE grid disk based thin provisioning where snapshot databases created on a SPARSE disk group need only the space for changes plus some metadata, thereby enabling storage efficient snapshot databases.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-snapshots.htm#SAGUG-GUID- E1D6EF45-36EF-40E3-A57E-F80B749E6122
http://www.oracle.com/technetwork/database/exadata/learnmore/exadata-database-copy-twp-2543083.pdf

 

NEW QUESTION 56
You are in the process of upgrading your X5 Database Machine half rack to a full rack.
The new storage servers are called DM01CEL08 through DM01CEL14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATA diskgroup by executing this SQL statement?

• A. 0, because the new griddisks will be added to the existing failgroups
• B. 12, consisting of seven griddisks each
• C. 96, consisting of seven griddisk each
• D. 1, consisting of all 96 griddisks
• E. 7, consisting of 12 griddisks each

Answer: E

Explanation:
Explanation/Reference:
The number of failure groups equals the number of Exadata Cells. Each failure group is composed of a subset of grid disks in the Oracle ASM disk group that belong to a single storage cell.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm

 

NEW QUESTION 57
Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine?

• A. ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server.
• B. ASR Manager software may be installed on one of the database servers in the Database Machine.
• C. ASR Manager software may be installed on a server that is not part of the Database Machine.
• D. ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP).
• E. ASR Manager can connect to the Internet with HTTPS using a proxy server.
• F. ASR Manager can connect to the Internet directly with HTTPS.

Answer: B,C,E,F

Explanation:
C: If you need to use HTTPS for security purposes, you can set up HTTPS/SSL for the ASR Manager HTTP receiver.
D: As part of the registration process for ASR Manager, you can optionally set the ASR Manager to access the internet through a proxy server.
References: https://docs.oracle.com/cd/E37710_01/install.41/e18475/ch2_asr_manager.htm#ASRUD137

 

NEW QUESTION 58
Which two are true about the allocation of I/O resources by IORM within the CELLSRV process?

• A. Log Writer I/O and Control File I/O are always prioritized over all user I/O.
• B. Database Writer I/O is always prioritized over all user I/O.
• C. If two consumer groups A and B in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and interdatabase plans are unchanged, and consumer groups A and B are still mapped to the same category.
• D. If two consumer groups C and D in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively, and were remapped to a different category by the DBA, provided that the category plans and the interdatabase plans are unchanged.
• E. If two consumer groups P and Q in the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups P and Q are still mapped to the same categories.

Answer: A,E

Explanation:
B: Rules in an interdatabase resource plan specify allocations to databases, not consumer groups.
E: Redo and control file writes always take precedence.
Reference: Using IORM with Exadata

 

NEW QUESTION 59
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 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.
• C. Edit the CELLIP. ORA file on each storage server on contain IP addresses of database servers in the database server grid that are associated with the storage grid to which that storage server belongs.
• D. 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.
• E. Configure Exadata realms using Database -scoped security mode.
• F. 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.

Answer: D

Explanation:
Explanation/Reference:
The cellinit.ora file is host-specific, and contains all database IP addresses that connect to the storage network used by Oracle Exadata Storage Servers. This file must exist for each database that connect to Oracle Exadata Storage Servers.
The cellinit.ora file contains the database IP addresses.
The cellip.ora file contains the storage cell IP addresses.
Both files are located on the database server host.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- configuring.htm#SAGUG20369

 

NEW QUESTION 60
Which two are true about the allocation of I/O resources by IORM within the CELLSRV process?

• A. Log Writer I/O and Control File I/O are always prioritized over all user I/O.
• B. If two consumer groups A and B in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they got 20% and 30% respectively, provided that the category plans and interdatabase plans are unchanged, and consumer groups A and B are still mapped to the same category.
• C. If two consumer groups C and D in the PROD database get 10% and 15% respectively, of resource allocation, then the percentage of I/O resource would be the same if they still got 10% and 15% respectively, and were remapped to a different category by the DBA, provided that the category plans and the interdatabase plans are unchanged.
• D. If two consumer groups P and Q in the PROD database get 20% and 10% respectively of resource allocation, then the percentage of I/O resource would be the same if they got 10% and 5% respectively, and the interdatabase plan has changed, provided that the category plan is unchanged, and consumer groups P and Q are still mapped to the same categories.
• E. Database Writer I/O always prioritized over all user I/O.

Answer: A,D

Explanation:
B: Rules in an interdatabase resource plan specify allocations to databases, not consumer groups.
E: Redo and control file writes always take precedence.

 

NEW QUESTION 61
Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server?

• A. Using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
• B. Using the CELLCLI LIST LUN DETAIL command as the celladmin user
• C. Using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin
• D. Hardware monitoring using the storage server ILOM

Answer: A,D

Explanation:
Explanation/Reference:
The CALIBRATE command runs raw performance tests on cell disks, enabling you to verify the disk performance before the cell is put online. You must be logged on to the cell as the root user to run CALIBRATE.
Oracle ILOM automatically detects system hardware faults and environmental conditions on the server. If a problem occurs on the server, Oracle ILOM will automatically do the following:
Illuminate the Service Required status indicator (LED) on the server front and back panels.
Identify the faulted component in the Open Problems table.
Record system information about the faulted component or condition in the event log.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- cellcli.htm#SAGUG20617

 

NEW QUESTION 62
Which two are true about Smart Scan?

• A. Join processing can be partly offloaded to Exadata Storage Servers.
• B. It is possible to offload single row functions to the Exadata Storage Servers.
• C. A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.
• D. Column projection does not contribute to the performance benefit of Smart Scan.
• E. Join processing can be fully offloaded to Exadata Storage Servers.
• F. A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.

Answer: A,B

Explanation:
Explanation/Reference:
D: With Exadata storage, database operations are handled much more efficiently. Queries that perform table scans can be processed within Exadata storage with only the required subset of data returned to the database server. Row filtering, column filtering and some join processing (among other functions) are performed within the Exadata storage cells. When this takes place only the relevant and required data is returned to the database server.
E: With Smart Scan processing, row filtering, column filtering, some join processing, and other functions are performed in the Exadata cells.
References: http://www.centroid.com/blog/exadata-smart-scan-processing

 

NEW QUESTION 63
Which three statements are true about the CELLCLI command?

• A. It requires root privileges to create CELLDISKS and GRIDDISKS.
• B. It has command-line history.
• C. It can be executed using the DCLI utility.
• D. It can execute commands on multiple storage servers in parallel.
• E. It can be executed on storage servers.

Answer: B,C,E

Explanation:
The CellCLI utility supports command-line history.
Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface.
The dcli utility facilitates centralized management across an Oracle Exadata Storage
Server Software realm by automating the execution of CellCLI commands on a set of cells and returning the output to the centralized management location where the dcli utility was run.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-cellcli.htm

 

NEW QUESTION 64
A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.
The script must run on each cell simultaneously.
How would you achieve this?

• A. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.
• B. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.
• C. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.
• D. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.
• E. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.

Answer: B

Explanation:
Explanation/Reference:
The exadcli utility runs commands on multiple remote nodes in parallel threads.
You can issue an ExaCLI command to be run on multiple remote nodes. Remote nodes are referenced by their host name or IP address. Unlike dcli, exadcli can only execute ExaCLI commands. Other commands, for example, shell commands, cannot be executed using exadcli.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadcli.htm#DBMMN-GUID-4AE469A6-F291-
4737-B975-F1B4B91D0BA0

 

NEW QUESTION 65
Examine this IORM plan:

Which two are true concerning this plan?

• A. I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.
• B. If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.
• C. If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.
• D. The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.
• E. I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if no other databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.

Answer: B,E

Explanation:
Explanation/Reference:
The IORM plan can be configured using the ALTER IORMPLAN command on command-line interface (CellCLI) utility on each Exadata storage cell. It consists of two parameters - dbplan and catplan. While the
"dbplan" is used to create the I/O resource directives for the databases, the "catplan" is used to allocate resources by workload category consolidated on the target system.
allocation/share - Specify the resource allocation to a specific database in terms of percentage or shares.
limit - Specify maximum limit of disk utilization for a database.
Incorrect Answers:
A: IORM plans configures % I/O resources, not % of Flash Cache.
References: https://community.oracle.com/docs/DOC-998939

 

NEW QUESTION 66
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. Create user-defined metrics for the InfiniBand switch.
• D. Use Enterprise Manager Cloud Control.

Answer: B,D

Explanation:
There are two approaches for monitoring Oracle Exadata Storage Servers:
using a command-line interface (CLI) or using the graphical interface provided by the Oracle Enterprise Manager Cloud Control 12c console.
You can manually monitor the InfiniBand Switch Ports with the ibqueryerrors.pl command.
Run the ibqueryerrors.pl command to report on switch port error counters and port configuration information using the command:
# ibqueryerrors.pl -rR -s RcvSwRelayErrors,XmtDiscards,XmtWait,VL15Dropped
References: http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html

 

NEW QUESTION 67
In which three situations will a Smart Scan occur on a table for which Smart Scan is possible, assuming that nothing in the environment prevents a Smart Scan?

• A. Executing queries in parallel.
• B. Having direct path reads used at execution time.
• C. The ASM diskgroup containing the table's tablespace has a 4 MByte AU size.
• D. An update to the table is made identifying the row to be modified by primary key.
• E. setting _serial_direct_read= true in the session issuing the SQL statements and executing a serial query.
• F. An index range scan occurs for the table.

Answer: A,B,E

Explanation:
Whether you get a direct path read & smart scan, depends on the current buffer cache size, how big segment you're about to scan and how much of that segment is actually cached at the moment. This dynamic decision unfortunately can cause unexpected surprises and variance in your report/batch job runtimes.
To work around these problems and force a direct path read/smart scan, you can either:
D: One of the most common Exadata performance problems is that the direct path reads (and thus also Smart Scans) don't sometimes kick in when running full scans in serial sessions.
Note: Smart Scan is a subset of Cell Offload Processing and is perhaps the feature that is most highly associated with Exadata. Smart Scan allows Oracle databases to push query information down to the storage level, specifically:

 

NEW QUESTION 68
Which two statements are true regarding the use of Auto Service Request (ASR) with an X6 Database Machine?

• A. The database server ILOMs must use SMTP over the management network for notifications to ASR Manager.
• B. The database server MS process must have SNMP traps configured to use the management network for notifications to ASR Manager.
• C. The database server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.
• D. The storage server ILOMs must have SNMP traps configured to use the management network for notifications to ASR Manager.

Answer: C,D

Explanation:
Explanation/Reference:
B: Database Server ILOM plug-in
Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the ILOM plug-in, as there is no Management Server (MS) on the database servers to receive SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from the ILOM including alerts based on pre-set ILOM thresholds.
C: Exadata Storage Server plug-in extends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user. For alerts to be sent to the plug-in, SNMP traps are used as follows:
Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send SNMP notifications onward to the plug-in.
Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent to the plug-in using SNMP.
References:
https://dbatrain.wordpress.com/2011/06/
http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html

 

NEW QUESTION 69
You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.
You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.
You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

• A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC
• B. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
• C. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ
• D. CT_IO_UTIL_SM and CT_IO_UTIL_LG

Answer: C

 

NEW QUESTION 70
A file contains a script with several EXACLI commands that must be executed on each cell in an X5 full rack.
The script must run on each cell simultaneously.
How would you achieve this?

• A. Execute it on all cells using the DBMCLI command specifying the file name containing the EXACLI script.
• B. Execute it on all cells using the EXADCLI command specifying the file name containing the EXACLI script.
• C. Copy the script to all cells using the CELLCLI command and execute it on all cells in parallel using the CELLCLI command.
• D. Copy the script to the cells using the EXACLI command and execute the script on all cells using the EXACLI command.
• E. Copy the script to all cells using the DCLI command and manually execute it on each cell using the DCLI command.

Answer: B

Explanation:
The exadcli utility runs commands on multiple remote nodes in parallel threads.
You can issue an ExaCLI command to be run on multiple remote nodes. Remote nodes are referenced by their host name or IP address. Unlike dcli, exadcli can only execute ExaCLI commands. Other commands, for example, shell commands, cannot be executed using exadcli.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/exadcli.htm#DBMMN-GUID-4AE469A6-F291-
4737-B975-F1B4B91D0BA0

 

NEW QUESTION 71
Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

• A. IPMI can be used for server configuration and management on each storage server.
• B. IPMI can be used for server configuration and management on each database server.
• C. The Baseboard Management Controller (BMC), which supports IPMI, runs as a multithreaded process on the storage server O/S.
• D. The Baseboard Management Controller (BMC), which supports IPMI, runs as a single-threaded process on the storage server O/S.

Answer: B,D

Explanation:
Explanation/Reference:
A: IPMI - short for Intelligent Platform Management Interface - is an interface standard that allows remote management of a server from another using standardized interface. The servers in the Exadata Database Machine follow that. It's not an Exadata command but rather a general Linux one.
To power on a cell or database server, issue this from another server:
# ipmitool -H prolcel01-ilom -U root chassis power on
To stop a server, use the shutdown command. To stop immediately and keep it down, i.e. not reboot, execute:# shutdown -h -y now
C: Like the KCS interface, the SSIF Interface is only specified as a 'Single Threaded Interface' for standard IPMI commands. That is, the BMC implementation is not expected to process more than one IPMI request at a time. While an implementation is allowed to have a degree of 'command queuing', for standard IPMI messages the SSIF lacks a 'Seq' field that software can use to match up particular instances of requests with responses.
References: https://www.intel.com/content/dam/www/public/us/en/documents/specification-updates/ipmi- intelligent-platform-mgt-interface-spec-2nd-gen-v2-0-spec-update.pdf

 

NEW QUESTION 72
Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage?

• A. Rows residing in HCC compressed segments, are always self- contained in a single database block.
• B. By default, decompression is performed by Exadata Storage Servers.
• C. HCC data is never cached in the Exadata Smart Flash Cache.
• D. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.
• E. HCC can be used only when the Exadata Smart Flash Cache is configured in Write-Through mode.
• F. Row-level locks are supported on HCC compressed data.

Answer: B,D,F

Explanation:
C: The decompression process typically takes place on the Oracle Exadata Storage Server in order to maximize performance and offload processing from the database server.
E: A logical construct called the compression unit is used to store a set of hybrid columnar compressed rows.
When data is loaded, column values for a set of rows are grouped together and compressed. After the column data for a set of rows has been compressed, it is stored in a compression unit.
F: What happens when I update a row on compressed tables? What about locks?
* BASIC and OLTP:
the updated row stays in the compressed block 'usual' Oracle's row-level locks
* Hybrid columnar:
Updated row is moved, as in a delete + insert
How to see that? With dbms_rowid package
New row is OLTP compressed if possible
Lock affects the entire CU that contains the row
Note: Oracle's Hybrid Columnar Compression technology is a new method for organizing data within a database block. As the name implies, this technology utilizes a combination of both row and columnar methods for storing data. This hybrid approach achieves the compression benefits of columnar storage, while avoiding the performance shortfalls of a pure columnar format.
Incorrect Answers:
B: Data remains compressed not only on disk, but also remains compressed in the Exadata Smart Flash Cache, on Infiniband, in the database server buffer cache, as well as when doing back-ups or log shipping to Data Guard.
References: http://www.oracle.com/technetwork/database/exadata/ehcc-twp-131254.pdf

 

NEW QUESTION 73
You have altered an index supporting a constraint to be invisible on a large data warehouse table in an X5 Database Machine.
Which two statements are true?

• A. You might drop the index and make the constraint invisible, for the constraint to be recognized and enforced.
• B. You must retain the index and make it visible again for the constraint to be recognized and enforced.
• C. You might drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags for the constraint to be recognized.
• D. You might retain the index, and leave it as invisible, and the constraint will still be recognized and enforced.
• E. You must retain the index and set the constraint to DISABLE NOVALIDATE RELY for the constraint to be recognized.

Answer: B,E

Explanation:
Explanation/Reference:
B: With making indexes invisible, we can easily check whether indexes are useful without having to drop (and in case recreate) them actually. While this may be of interest for "ordinary" Oracle Databases already, it is particular a useful feature for Exadata where we expect some conventional indexes to become obsolete after a migration.
C: DISABLE NOVALIDATE RELY means: "I don't want an index and constraint checking to slow down my batch data loading into datawarehouse, but the optimizer can RELY on my data loading routine and assume this constraint is enforced by other mechanism". This information can greatly help optimizer to use correct materialized view when rewriting queries. So if you don't use materialized views for query rewrite then you can put RELY for all your constraints (or NORELY for all your constraints) and forget about it.

 

NEW QUESTION 74
You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.
You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.
You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?

• A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC
• B. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
• C. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ
• D. CT_IO_UTIL_SM and CT_IO_UTIL_LG

Answer: C

Explanation:
* CT_IO_RQ_SM
The cumulative number of small I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category.
* CT_IO_RQ_LG
The cumulative number of large I/O requests issued by the category for hard disks. A large value indicates a heavy I/O workload from this category.
* CT_IO_WT_SM_RQ
The average IORM wait time per request for small I/O requests issued to hard disks by an IORM category.
* CT_IO_WT_LG_RQ
The average IORM wait time per request for large I/O requests issued to hard disks by an IORM category.
Incorrect Answers:
A: CT_IO_RQ_SM_SEC
This metric is derived from CT_IO_RQ_SM. It specifies the rate of small I/O requests issued by the category for hard disks. Its units are number of I/O requests per second. A large value indicates a heavy I/O workload from this category in the past minute.
B: CT_IO_UTIL_SM
The percentage of disk resources utilized by small requests from this category.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-monitoring.htm

 

NEW QUESTION 75
Which three must be true for a Smart Scan to occur for a table?

• A. The ASM diskgroup containing the table's tablespace must have cell.smart_scan_capable set to true.
• B. The query must be executed in parallel.
• C. The query must be executed serially.
• D. Direct path reads must be used at run time.
• E. cell_offload_processing must be true in sessions issuing SQL statements that access the table.
• F. The ASM diskgroup containing the table's tablespace must have a 4 Mbyte AU size.

Answer: A,D,E

Explanation:
A: pt_param( 'cell_offload_processing' 'TRUE') hint is used to enable the exadata smart scan feature in sql execution process.
D: Direct reads bypass the buffer cache and go directly into the process PGA. Cell offload operations occur for direct reads only.
F: The cell.smart_scan_capable attribute must be set to TRUE.

 

NEW QUESTION 76
Which two statements are true about Exadata storage server and database server alerts on an X5 Database Machine?

• A. Metric thresholds, if set, will persist across storage and database server reboots.
• B. Metric alerts are never stateful.
• C. Metrics have no thresholds set on them by default.
• D. SNMP alert notifications can be sent to only one destination.
• E. SMTP alert notifications must be sent to both ASR manager and Enterprise Manager agents.

Answer: A,E

 

NEW QUESTION 77
......

Tested Material Used To 1z0-070: https://www.realexamfree.com/1z0-070-real-exam-dumps.html