Breathing 1z0-070 Exam Dumps 2021

NEW QUESTION 1
You plan to monitor the status of the motherboard, memory, power, fans, and network
cards on the database nodes in your Exadata X6 Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?

• A. No thresholds need to be set because they are present in the ILOM and in Enterprise Manager.
• B. Set thresholds in ILOM and in Enterprise Manager because they are not present anywhere and must be set in both places.
• C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
• D. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.

Answer: D

NEW QUESTION 2
An important application has been migrated to a database on an X5 Database Machine.
You are examining high-load SQL statements from this application, in an attempt to determine which ones will benefit from the Exadata Smart Scan capability.
Which three access paths always generate “cell single block physical read” or “cell multiblock physical read” requests?

• A. Index fast full scans executed in parallel
• B. Full table scans on heap organized tables executed in parallel
• C. Full table scans on heap organized tables executed serially
• D. Full table scans on index organized tables executed in parallel
• E. Index unique scan access by primary key to heap organized tables executed in parallel
• F. Index unique scan access by primary key to heap organized tables executed serially

Answer: ACF

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

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

Answer: ACD

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:
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 4
Which four are true about Exadata features?

• A. Storage Indexes persist across Exadata storage server reboots.
• B. Data Warehouse workloads will benefit from Smart Flash Cache configured in Write- Through mode.
• C. Hybrid Columnar Compressed tables can be compressed and decompressed on Exadata storage servers.
• D. Hybrid Columnar Compressed tables can be compressed and decompressed on the database servers.
• E. OLTP workloads will benefit from Smart Flash Cache configured in Write-Back mode.
• F. Storage Indexes persist across database server reboots.

Answer: CDEF

Explanation: CD: That 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 logshipping to Data Guard.
E (not B): Use the Write-Back Flash Cache feature to leverage the Exadata Flash hardware and make Exadata Database Machine a faster system for Oracle Database Deployments. Write-through cache mode is slower than write-back cache mode. However, write-back
cache mode has a risk of data loss if the Exadata Storage Server loses power or fails.
F: Storage indexes are not stored on disk; they are resident in the memory of the storage cell servers.

NEW QUESTION 5
Identify three valid reasons for creating multiple griddisks on a single harddisk-based celldisk.

• A. to implement storage realms so that storage that can be reserved for specific resource consumer groups in the same database
• B. to enable the creation of normal or high redundancy ASM diskgroups
• C. to segregate storage into multiple pools with different performance characteristics
• D. to enable disk mirroring for the system area
• E. to implement storage realms so that storage can be reserved for specific databases
• F. to implement storage realms so that storage that can be reserved for specific Grid Infrastructure

Answer: BCF

Explanation: Creating multiple grid disks per cell disk allows you to create multiple pools of storage on the same Exadata Storage Server. The multiple grid disks can be assigned to separate ASM diskgroups, which can be provisioned to different databases.
Note: Griddisk is a logical disk that can be created on a celldisk. In a standard Exadata deployment we create griddisks on hard disk based celldisks only. While it is possible to create griddisks on flashdisks, this is not a standard practice.
F: After you complete the cell configuration, you can perform the following optional steps on the storage cell:
References:https://docs.oracle.com/cd/E80920_01/SAGUG/SAGUG.pdf

NEW QUESTION 6
Which two must be true for a Smart Scan to occur on a table?

• A. Sessions querying the table must set cell_offload_processing = true.
• B. It must be stored in an ASM diskgroup with a 4MByte AU size.
• C. It must be heap organized.
• D. It must be accessed using direct path reads.
• E. The table must not be compressed.

Answer: AD

NEW QUESTION 7
Which two statements are true about the Integrated Lights Out Manager (ILOM) on an Exadata x5 or x6 Database Machine?

• A. ILOM on database servers can use IPMI to send sensor alerts to an Enterprise Manager Agent.
• B. ILOM on a storage server uses SNMP to send sensor alerts to the cellsrv process on the same storage server.
• C. ILOM on a storage server uses IPMI to send sensor alerts to the MS process on the same storage server.
• D. ILOM on a storage server uses SNMP to send sensor alerts to the MS process on the same storage server.
• E. ILOM on database servers can use SNMP to send sensor alerts to an Enterprise Manager Agent.

Answer: CE

Explanation: C: ILOM supports the Intelligent Platform Management Interface (IPMI), which enables you to monitor and control your server platform, as well as to retrieve information about your server platform.
ILOM supports alerts in the form of IPMI Platform Event Trap (PET) alerts. Alerts provide advance warning of possible system failures.
E: Oracle ILOM supports the Simple Network Management Protocol (SNMP), which is used to exchange data about network activity.
SNMP functionality requires the following two components: References:https://docs.oracle.com/cd/E19860-01/E21452/E21452.pdf

NEW QUESTION 8
Which two statements are true about RMAN incremental level-1 backups for a database running on an X5 Database Machine?

• A. Block Change tracking (BCT) is not needed for databases in an X5 Database Machine, because ASM automatically does block change tracking when diskgroups are built from griddisks.
• B. cellsrv filters blocks and returns only those that have changed since the last backup, fordatabases in archivelog mode.
• C. cellsrv returns all blocks that have been or might have been changed since the last backup, and RMAN filters the blocks that do not require backup.
• D. cellsrv filters blocks and returns only those that have changed since the last backup, for databases in noarchivelog mode.
• E. Block Change Tracking (BCT) is not needed for databases in an X5 Database Machine, because change tracking is done by cellsrv.

Answer: DE

Explanation: D: Whenever data blocks change, the Change Tracking Writer (CTWR) background process tracks the changed blocks in a private area of memory.
When RMAN performs an incremental backup on the Exadata platform, cellsrv filters out unwanted blocks and sends back only those that have changed since the last level 0 or level 1 backup.
E: For the Exadata platform, you may choose to allow cellserv to do all the blocking filtering for incremental backups.
Note: RMAN block change tracking is used to improve the performance of incremental backup. The level 0 incremental backup scans the entire database but level 1 incremental backups use the block change tracking file to scan only the blocks that have changed since the last backup. This significantly reduces the amount of reads that are required on the database.
References: Expert Oracle Exadata (29 Aug 2015), page 319

NEW QUESTION 9
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. The ASM diskgroup containing the table’s tablespace has a 4 MByte AU size.
• B. Executing queries in parallel.
• C. setting serial_direct_read= true in the session issuing the SQL statements and executing a serial query.
• D. Having direct path reads used at execution time.
• E. An update to the table is made identifying the row to be modified by primary key.
• F. An index range scan occurs for the table.

Answer: BCD

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 10
Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine?

• A. Sparse diskgroups must be created using sparse griddisks.
• B. Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks.
• C. Sparse diskgroups may not be used for database snapshots.
• D. Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell.
• E. The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk.

Answer: AE

Explanation: A: A sparse ASM disk group is composed of sparse grid disks.
E: Sparse grid disks allocate space as new data is written to the disk, and therefore have a virtual size that can be much larger than the actual physical size. Sparse grid disks can be used to create a sparse disk group to store database files that will use a small portion of their allocated space. Sparse disk groups are especially useful for quickly and efficiently creating database snapshots on Oracle Exadata. Traditional databases can also be created using a sparse disk group.
References:
http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server- snapshots.htm#SAGUG-GUID-42945059-13FD-4F6A-B7FA-A1201D16238F
http://docs.oracle.com/cd/E80920_01/DBMSO/exadata-whatsnew.htm#DBMSO22120

NEW QUESTION 11
Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack?

• A. All Exadata storage servers used by the same virtual cluster nodes must run the same O/S but Exadata Storage Servers in different clusters may run different operating systems.
• B. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
• C. All Exadata storage servers may run Oracle Virtual Machine (OVM).
• D. All Exadata storage servers must run Oracle Linux.
• E. All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual Machine (OVM).

Answer: D

Explanation: On both physical and virtual deployments, Exadata systems use minimal Linux distributions to ensure that just the RPMs needed to run Oracle database, are installed and enabled.
References:http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds- 2406241.pdf

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

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

Answer: ADF

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 13
Which type or types of network traffic are transported over the internal InfiniBand interconnect in Exadata Database Machine X5?

• A. IDB protocol traffic, clustered ASM traffic, and clustered database instance traffic
• B. IDB protocol traffic and clustered database instance traffic only
• C. IDB protocol traffic and clustered ASM instance traffic only
• D. Both clustered ASM and clustered database instance traffic only
• E. IDB protocol traffic only

Answer: E

Explanation: Oracle Exadata uses the Intelligent Database protocol (iDB) to transfer data between Database Node and Storage Cell Node.
iDB is used to ship SQL operations down to the Exadata cells for execution and to return query result sets to the database kernel.

NEW QUESTION 14
Which three statements are true about Recovery Manager (RMAN) daily differential incremental backup strategies on an X5 Database Machine for a database having 25% or more of its blocks modified each day and which has an 8 k block size?

• A. Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.
• B. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.
• C. Enabling Block Change Tracking (BCT) on the database can result in a reduction ofphysical I/O on the cells during incremental backups.
• D. For level-1 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• E. For level-0 backups, Block Change Tracking (BCT) is most beneficial when more than 25 percent of the blocks have changed since the last backup.
• F. cellsrv returns only blocks that have changed since the last backup.

Answer: ACF

Explanation: A: Fast Incremental backups is possible with Block change tracking, which is initially introduced from version 10.2 onwards, by this tool it's very useful to reduce the RMAN incremental backup duration.
If the changes are something around 20% then in this situation BCT helps a lot.
C: Exadata Storage Server offload capability combined with RMAN block change tracking will efficiently perform large I/Os at the storage-tier level, returning only individual changed blocks for incremental backups and increasing the backup performance of the system.
Note: Level 1 backup: A level 1 backup includes only those blocks that have been changed since the "parent" backup was taken. Remember a parent backup may be either a level 0 or a level 1 backup.
Block change tracking allows indeed the highest benefit for databases where the changes are not so high,
Level 0 backup: A level 0 incremental backup is physically identical to a full backup and it includes every data block in the file except empty blocks. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.
References:http://www.dba-oracle.com/t_rman_backup_types.htm http://www.oracle.com/technetwork/database/availability/maa-tech-wp-sundbm-backup- 11202-183503.pdf
https://www.toadworld.com/platforms/oracle/w/wiki/11124.fast-incremental-backups-active- data-guard

NEW QUESTION 15
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: AD

Explanation: 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 16
Which two statements are true about data paths used during RMAN backup and restore operations when media management servers use InfiniBand to connect to an X5 Database Machine?

• A. During backups, data blocks are always read from Smart Flash Cache by cellsrv.
• B. During restores, data blocks read from the media are sent to a database server that sends the blocks to cellsrv to be written.
• C. During backups, data blocks are read by cellsrv and sent to a database server, which sends the blocks to the media manager to be written to media.
• D. During backups, data blocks are read by cellsrv and sent directly to the media manager to be written to media.
• E. During restores, data blocks read from the media are sent directly to cellsrv to be written.

Answer: DE

Explanation: The fastest database backup is achieved via InfiniBand.
RMAN does not back up directly to tape. However, it will integrate with media management software such as Oracle Secure Backup and utilize their capabilities to manage tape libraries.
Exadata Database Machine: The Database Machine contains the databases that need to
be backed up. Oracle RMAN is the only mechanism to back up the databases that utilize Exadata Storage Servers as the storage. RMAN processes run on the database servers and interact with the Oracle Secure Backup (OSB) agent, which further interacts with the media management software and enables RMAN to communicate with the tape library.
References:http://apprize.info/data/oracle_4/6.html

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

• A. Database Writer I/O always prioritized over all user I/O.
• B. 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.
• 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 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.
• E. Log Writer I/O and Control File I/O are always prioritized over all user I/O.

Answer: BE

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