[Oct-2021] Valid Way To Pass Oracle Exam Dumps with 1z0-070 Exam Study Guide [Q54-Q69]

[Oct-2021] Valid Way To Pass Oracle Exam Dumps with 1z0-070 Exam Study Guide

All 1z0-070 Dumps and Oracle Exadata X5 Administration Training Courses Help candidates to study and pass the Exams hassle-free!

NEW QUESTION 54
Which two communication methods are used by which components in the Enterprise Manager architecture for a Database Machine?

• A. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.
• B. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.
• C. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.
• D. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.
• E. SNMP traps for alerts are sent by the storage server ILOM directly to the Enterprise Manager agent.

Answer: C,D

NEW QUESTION 55
You are planning the monitoring configuration for your X5 Database Machine.
Which two components are monitored directly through the use of Exadata -specific Enterprise Manager Plug-Ins?

• A. ASM instances
• B. the Infiniband switches
• C. the storage server ILOM
• D. the database server Clusterware
• E. the database server O/S

Answer: B,C

Explanation:
The Oracle Enterprise Manager Grid Control Exadata Monitoring plug-in bundle allows you to monitor the following key components of Exadata machine:
References: http://www.oracle.com/technetwork/oem/grid-control/exadata-plug-in-bundle-188771.html

NEW QUESTION 56
You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting Exadata-based ASM diskgroups.
You want to check for potential space problems that take ASM mirroring requirements into account.
Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command?

• A. cold_used_mb
• B. required_mirror_free_mb
• C. total_mb
• D. free_mb
• E. usable_file_mb

Answer: C,D

Explanation:
Determine the Amount of Available Space
To increase the size of the disks in a disk group you must either have unallocated disk space available, or you have to reallocate space currently used by a different disk group.
Example: View the space currently used by the disk groups.
SELECT name, total_mb, free_mb, total_mb - free_mb used_mb, round(100*free_mb/total_mb,2) pct_free
FROM v$asm_diskgroup
ORDER BY 1;

The example above shows that the DATAC1 disk group has only about 15% of free space available while the RECOC1 disk group has about 87% free disk space. The PCT_FREE displayed here is raw free space, not usable free space. Additional space is needed for rebalancing operations.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-administering-asm.htm#SAGUG20526

NEW QUESTION 57
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 read by cellsrv and sent to a database server, which sends the blocks to the media manager to be written to media.
• B. During restores, data blocks read from the media are sent directly to cellsrv to be written.
• C. During backups, data blocks are read by cellsrv and sent directly to the media manager to be written to media.
• D. During restores, data blocks read from the media are sent to a database server that sends the blocks to cellsrv to be written.
• E. During backups, data blocks are always read from Smart Flash Cache by cellsrv.

Answer: B,C

Explanation:
The fastest database backup is achieved via InfiniBand.
* Get dedicated Media Servers that connect to tape library
* Offers backup rates of up to 12GB/sec
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 58
Which two statements are true about Exadata X5 cell metrics and alerts?

• A. Cell metrics are written to disk every hour by default.
• B. Cell alerts are written to disk every hour by default.
• C. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to a filesystem-based repository.
• D. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystem-based repository.
• E. Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository.

Answer: A,D

Explanation:
Metrics are a series of measurements that are computed and retained in memory for an interval of time, and stored on a disk for a more permanent history.
On the storage servers, the CELLSRV process provides the majority of Oracle Exadata storage services and is the primary storage software component. One of its functions is to process, collect, and store metrics. The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly.
References:
http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-2291964.html

NEW QUESTION 59
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 database servers can use SNMP to send sensor alerts to an Enterprise Manager Agent.
• E. ILOM on a storage server uses SNMP to send sensor alerts to the MS process on the same storage server.

Answer: C,D

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 60
Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.
There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.
You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.
You decide to use the I/O resource manager.
Which is the best way to solve this problem?

• A. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create the OLTP category and map all OLTP- oriented consumer groups in all databases to it.
• B. Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.
• C. Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.
• D. Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.

Answer: C

Explanation:
Explanation/Reference:
You can manage I/O resources based on categories by creating a category plan.
You can add any number of categories, or modify the predefined categories. You should map consumer groups to the appropriate category for all databases that use the same cell storage. Any consumer group without an explicitly specified category defaults to the OTHER category.
References: http://docs.oracle.com/cd/E80920_01/SAGUG/exadata-storage-server-iorm.htm

NEW QUESTION 61
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 62
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:
Explanation/Reference:
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 63
Which three are sources for alerts from storage servers in an X5 Database Machine?

• A. Software errors reported by the RS process on the storage servers
• B. Hardware sensor alerts detected by the ILOM on the storage servers
• C. Metrics that have administrator-defined thresholds on the storage servers
• D. Software errors reported by the MS process on the storage servers
• E. Hardware sensor alerts reported by the CELLSRV process on the storage servers

Answer: C,D,E

Explanation:
AB: The Management Server (MS) process receives the metrics data from CELLSRV, keeps a subset of metrics in memory, and writes to an internal disk-based repository hourly. In addition, the MS process can generate alerts for important storage cell hardware or software events.
Incorrect Answers:
C: The Restart Server (RS) process is used to start up and shut down the CELLSRV and MS processes. It also monitors these services to check whether they need to be restarted.
References: http://www.oracle.com/technetwork/articles/servers-storage-admin/monitor-exadata-em12-
2291964.html

NEW QUESTION 64
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 65
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. Enabling Block Change Tracking (BCT) on the database can result in reduced consumption of storage network bandwidth.
• B. 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.
• C. 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.
• D. Enabling Block Change Tracking (BCT) on the database can result in a reduction of physical I/O on the cells during incremental backups.
• E. Fast incremental backups when 50% or more of the blocks have changed since the last backup, will run as slowly as normal incremental backup.
• F. cellsrv returns only blocks that have changed since the last backup.

Answer: D,E,F

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 66
Which two statements are true about Auto Service Request (ASR) with an X5 Database Machine?

• A. ASR Manager must be installed and configured on one of the database servers.
• B. ASR can upload configuration metadata to support problem resolution.
• C. ASR communicates with Oracle support services using HTTPS.
• D. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• E. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.
• F. Configuring ASR is mandatory for all Database Machine assets.

Answer: D,E

Explanation:
Explanation
Explanation:
A: Oracle recommends that you install Oracle ASR Manager on an external, standalone server.
C: Oracle ASR is designed to generate Oracle service requests automatically when certain types of faults are detected on Oracle products that are qualified for Oracle ASR.
Oracle ASR works only for specific component faults. Most of the common components, such as disks, fans, and power supplies, are covered. However, some components are not covered. For example, Oracle ASR does not cover InfiniBand events; there are specific images and specific InfiniBand switch firmware that you must use. You cannot upgrade these components independently.
Incorrect Answers:
D: Oracle recommends that you install Oracle ASR Manager on an external, standalone server.
References: http://docs.oracle.com/cd/E80920_01/ASXQI/toc.htm#GUID-490B2837-C608-4626-B4FF-
59F679C36302

NEW QUESTION 67
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:
Explanation/Reference:
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 68
Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

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

Answer: A,C

Explanation:
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 69
......

Get Latest [Oct-2021] Conduct effective penetration tests using  Free4Torrent 1z0-070