Real Exam Questions 1z0-070 Dumps Exam Questions in here [Oct-2021]
Get Latest Oct-2021 Conduct effective penetration tests using 1z0-070
NEW QUESTION 15
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 16
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 17
Which two statements are true about the X5 Exadata storage server rescue procedure?
- A. The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.
- B. The rescue procedure can be used to restore a corrupt system area.
- C. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
- D. The rescue procedure can be used to repair corruption in an ASM diskgroup.
- E. The rescue procedure can be executed from the CELLBOOT USB flash drive.
Answer: B,E
Explanation:
The rescue procedure is necessary when system disks fail, the operating system has a corrupt file system, or there was damage to the boot area. If only one system disk fails, then use CellCLI commands to recover. In the rare event that both system disks fail simultaneously, you must use the Exadata Storage Server rescue functionality provided on the Oracle Exadata Storage Server Software CELLBOOT USB flash drive.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm#GUID-710814E7-4691-49EE-95AD-726D2D6C5BFE
NEW QUESTION 18
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:
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 19
You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine.
You use RAC for your databases and also use Data Guard, having standby databases on another Database Machine.
You want to have scripts that contain the appropriate commands to patch your environment.
Your patch bundle is one the first database server and is located at /uo1/stage.
You have downloaded the oplan utility to the first database server and run:
$ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage
Which two statements are true concerning the type of instructions oplan will generate?
- A. Instructions for patching all components on the Database Machine
- B. Instructions for patching only storage servers
- C. Instructions for patching the Grid Infrastructure home on the primary location
- D. Instructions for patching the RAC Oracle Home on the primary location
- E. Instructions for patching the Data Guard environment on the standby location
Answer: C,D
Explanation:
Oplan generates instructions for all of the nodes in the cluster.
Note:
* Oplan is a utility that facilitates you with the application of bundle patches on Exadata compute nodes via Opatch. This new utility helps you with the patch process by generating step-by-step instructions telling you how to apply a bundle patch in your environment.
* Exadata is much more than a "database-in-a-box." It is a set of compute nodes (think RAC node servers) combined with ultra-fast infiniband (...and 10GB ethernet, and multiple 1GB ethernet) and storage nodes.
Incorrect Answers:
B: There is no support for Oracle DataGuard
References: https://blogs.oracle.com/xpsonha/patching-for-exadata:-introducing-oplan
NEW QUESTION 20
Which three statements are true about bulk data loading capabilities in an X5 Database Machine environment?
- A. DBFS must be used to have a POSIX-compliant shared storage solution that is accessible from the database servers on a Database Machine.
- B. DBFS must use the DBFS_DG diskgroup for any DBFS store.
- C. DBFS must be used to bulk load data into a production database on the Database Machine.
- D. DBFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
- E. ACFS may use the DBFS_DG diskgroup to contain the ADVM volume file.
- F. ACFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
- G. ACFS must be used to have a POSIX -compliant shared storage solution that is accessible from the database servers on a Database Machine.
Answer: A,C,D
Explanation:
External tables on DBFS file-systems provide the probably the most high-performance way to bulk load data into your database.
Bulk Data Loading
Describe the various options for staging data to be bulk loading into Database Machine
Configure the Database File System (DBFS) feature for staging input data files
Use external tables based on input data files stored in DBFS to perform high-performance data loads.
NEW QUESTION 21
Which two completely prevent a Smart Scan from occurring?
- A. performing a minimum or maximum function on an indexed column
- B. querying a table containing many chained rows
- C. referencing more than 255 columns form an OLTP compressed table in a query
- D. performing a Fast Full Index scan on a reverse key index
- E. querying a table containing many migrated rows
- F. querying a table containing a JSON column
Answer: C,E
Explanation:
B: Migrated Rows is a special case of chained rows. Migrated rows still affect performance, as they do in conventional storage situations, but with the additional overhead of reducing the beneficial effects of "Smart Scan" in addition to increasing the number of I/Os
E: Smart Scans - broadly speaking and ignoring edge cases - can only transport a maximum of 254 columns from a single (non-HCC) segment. Requesting more columns will simply disable Smart Scans for that segment.
An interesting limitation to Exadata Smart Scans - if more than 254 columns from a table (not HCC compressed, more on that in moment) need to be projected, Smart Scans for that particular segment will be disabled and Exadata will fall back to conventional I/O. This means that the number of columns in the projection clause can make a significant difference to performance, since only Smart Scans allow taking advantage of offloading and particularly avoiding I/O via Storage Indexes.
NEW QUESTION 22
Which three are true concerning Storage Indexes?
- A. The use of Storage Indexes for particular categories of I/O can be displayed by using an I/O Resource Manager Category Plan.
- B. A maximum of eight table columns for any table are indexed per storage region.
- C. The use of Storage Indexes for a particular database can be disabled by using an I/O Resource Manager Database Plan.
- D. A Storage Index is automatically maintained by CELLSRV based on the filter columns of the offloaded SQL.
- E. Storage Indexes persist across any Exadata storage server reboots.
- F. Different storage regions may have different columns indexed for the same table.
Answer: B,C,D
Explanation:
Explanation/Reference:
A: Each disk in the Exadata storage cell is divided into equal sized pieces called storage regions (default
1MB). There is an index entry for every storage regions (1MB of data stored on disk). Each entry contains the minimum and maximum value for columns seen in 'where' clause predicates. Information for up to 8 columns can be stored. The index is then used to eliminate disk IO by identifying which storage regions don't match the 'where' clause of a query.
NEW QUESTION 23
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 24
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 25
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 26
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. OS users that own the Grid Infrastructure installation
- D. Cluster configuration for up to 32 clusters
- E. Virtualized Computer Node configuration
Answer: A,D,E
Explanation:
Explanation/Reference:
Oracle Exadata Deployment Assistant has two main phases
the customer provides naming, DNS, NTP, and networking details. This information is collected using
the Oracle Exadata Deployment Assistant user interface. A configuration file is generated the configuration file is pushed to the database node, and the validation and installation is
Oracle Exadata Deployment Assistant can configure Oracle Exadata Database Machine, Recovery Appliance, or Oracle SuperCluster.
References:
https://docs.oracle.com/cd/E55822_01/AMOGD/configurator.htm#AMOGD22056
https://www.toadworld.com/platforms/oracle/w/wiki/11469.oracle-exadata-deployment-assistance-oeda
NEW QUESTION 27
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:
Explanation/Reference:
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 28
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 29
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:
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 30
Which three statements are true about Automatic Hard Disk Scrubbing and repair on high-capacity storage servers in an X5 Database Machine?
- A. Hard disks are scanned every two weeks by default but only when disks are idle.
- B. Hard disks are scanned every two weeks by default in all situations.
- C. Disk repair may be made from another mirror copy if the corrupt area is part of a Normal or High Redundancy Disk Group.
- D. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is dirty in the Smart Flash Cache.
- E. Disk repair is made immediately from Smart Flash Cache for corruption on disk when the corresponding data is clean in the Smart Flash Cache.
Answer: B,C,E
Explanation:
Explanation/Reference:
The default schedule of scrubbing is every two weeks.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage-servers.htm
NEW QUESTION 31
......
Authentic Best resources for 1z0-070 Online Practice Exam: https://www.actualtestsit.com/Oracle/1z0-070-exam-prep-dumps.html