New 2021 Guaranteed Success with Dumps4PDF 1z0-070 Dumps Oracle PDF Questions
Exceptional Practice To Oracle Exadata X5 Administration Pass the First Time
NEW QUESTION 20
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:
Explanation/Reference:
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 21
Which three are true about Exadata Smart Flash Log?
- A. LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.
- B. The use of Exadata Smart Flash Logs is mandatory for support of production databases.
- C. I/O Resource Manager category plans can be used to enable or disable Exadata Smart
Flash Log for different I/O categories. - D. Databases on the Database Machine use Exadata Smart Flash Log by default.
- E. I/O Resource Manager database plans can be used to enable or disable Exadata Smart
Flash Log for individual databases.
Answer: A,D,E
Explanation:
A: Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable Smart
Flash Logging for the different databases running on the Database Machine, reserving flash for the most performance critical databases.
B: The Exadata I/O Resource Manager (IORM) has been enhanced to enable or disable
Smart Flash Logging for the different databases running on the Database Machine.
C: Smart Flash Logging works as follows. When receiving a redo log write request,
Exadata will do parallel writes to the on-disk redo logs as well as a small amount of space reserved in the flash hardware. When either of these writes has successfully completed the database will be immediately notified of completion. If the disk drives hosting the logs experience slow response times, then the Exadata Smart Flash Cache will provide a faster log write response time.
Conversely, if the Exadata Smart Flash Cache is temporarily experiencing slow response times (e.g., due to wear leveling algorithms), then the disk drive will provide a faster response time.
This algorithm will significantly smooth out redo write response times and provide overall better database performance.
NEW QUESTION 22
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
Explanation:
Explanation/Reference:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/exadata-storage-server- software-introduction.html#GUID-3E48425A-AB8A-4E62-80C4-BACA65A1F8D3
https://docs.oracle.com/cd/E91266_01/EMXIG/GUID-FB58204F-2D97-41BC-9AA7-
10BFF920B5B4.htm#EMXIG304
NEW QUESTION 23
You plan to migrate a database supporting both DSS and OLTP workloads to your new X5 Database machine.
The workloads contain many complex aggregating functions and expensive joins on large partitioned tables in the DSS workload and indexed access for OLTP workloads.
Which three benefits accrue as a result of this migration?
- A. Superior flash cache compression technique
- B. Superior compression capability designed specifically for archival data
- C. Columnar storage capability for data in row major data blocks that is held in flash cache
- D. Superior compression capability designed specifically for data warehouse tables
- E. Cell offload processing for indexed-organized table access
- F. Superior compression capability designed specifically for OLTP workloads
Answer: B,D,F
Explanation:
Explanation/Reference:
There are 6 different kinds of Table Data Compression methods:
1. BASIC compression, introduced in Oracle 8 already and only recommended for Data Warehouse
2. OLTP compression, introduced in Oracle 11 and recommended for OLTP Databases as well
3. QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor
4. QUERY HIGH compression (Exadata only), recommended for Data Warehouse with focus on Space Saving
5. ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor
6. ARCHIVE HIGH compression (Exadata only), recommended for Archival Data with maximum Space Saving
Incorrect Answers:
B:
1. BASIC compression, introduced in Oracle 8 already and only recommended for Data Warehouse
2. OLTP compression, introduced in Oracle 11 and recommended for OLTP Databases as well
3. QUERY LOW compression (Exadata only), recommended for Data Warehouse with Load Time as a critical factor
4. QUERY HIGH compression (Exadata only), recommended for Data Warehouse with focus on Space Saving
5. ARCHIVE LOW compression (Exadata only), recommended for Archival Data with Load Time as a critical factor
6. ARCHIVE HIGH compression (Exadata only), recommended for Archival Data with maximum Space Saving
Method 1 and 2 are working by compressing the rows inside of Oracle Blocks - the more redundant values inside the block, the better the compression ratio. OLTP compression might be used with Exadata Database Machine, because Exadata V2 is designed to support OLTP as well as Data Warehouse.
Methods 3 to 6 use Hybrid Columnar Compression (HCC), which is designed to achieve better compression ratios by organizing sets of rows into compression units and then detaching the columns from the rows and collecting them. It is more likely that the same columns store similar (redundant) data, therefore the compression ratio improves with HCC.
References: https://uhesse.com/2011/01/21/exadata-part-iii-compression/
NEW QUESTION 24
You are planning the migration of a large data warehouse to a Little Endian X6 Database Machine using which is running database version 12.2.0.1.
The current database version is Oracle Database 11.2.0.4.0 hosted on a Big Endian platform.
The current database characterset is WE8ISO8859P15.
Which two migration methods are supported?
- A. cross-platform Transportable Database
- B. Data Pump
- C. Logical Standby database
- D. Physical Standby database
Answer: B,C
NEW QUESTION 25
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 may run Oracle Virtual Machine (OVM).
- B. All Exadata storage servers must run Oracle Linux.
- C. All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.
- D. 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. - 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: B
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 26
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 27
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 28
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 29
Which two statements are true about Exadata X5 cell metrics and alerts?
- A. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystem- based repository.
- B. Cell metrics are written to disk every hour by default.
- C. Cell alerts are written to disk every hour by default.
- D. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to 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,B
Explanation:
Explanation/Reference:
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 30
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:
Explanation/Reference:
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 31
Examine this list of software components:
1 . Oracle Virtual Machine (OVM)
2 . Oracle Enterprise Manager Agent (OMA)
3 . ASM instance
4 . RDBMS instance
5 . Automatic Diagnostic Repository Command Interpreter (ADRCI)
6 . CELLCLI
7 . Cell Server (CELLSRV)
8 . diskmon
Identify the location where these software components can run in the standard Exadata Database Machine deployment.
- A. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.
- B. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
- C. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.
- D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.
- E. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
Answer: B
Explanation:
Automatic Diagnostic Repository Command Interpreter (ADRCI) can be used on an Exadata storage server.
NEW QUESTION 32
You plan to migrate a database supporting an OLTP workload to your new X5 Database Machine.
The current database instance supports a large number of short duration sessions and a very high volume of short transactions.
Which three X5 Database Machine features can improve performance for this type of workload?
- A. Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models
- B. Reduced I/O latency for writes due to writeback flashcache on all Exadata X5 and later models
- C. Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models
- D. An improved highly efficient undo and redo architecture
- E. Faster optimization due to an Exadata-specific optimizer
Answer: B,C,D
Explanation:
A: To further accelerate OLTP workloads, the Exadata Smart Flash Cache also implements a special algorithm to reduce the latency of log write I/Os called Exadata Smart Flash Logging.
C: 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.
D: Exadata X5-2 introduces Extreme Flash Storage Servers. Each Extreme Flash storage server contains eight 1.6 TB state-of-the-art PCI Flash drives. PCI flash delivers ultra-high performance by placing flash memory directly on the high speed PCI bus rather than behind slow disk controllers and directors.
References: http://www.oracle.com/technetwork/database/exadata/exadata-x5-2-ds-2406241.pdf
http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash-2179184.html
NEW QUESTION 33
An Exadata storage server physical disk on an X5 high-capacity full rack entered the predictive failure state.
Identify the two steps that you must perform to replace this failed physical disk.
- A. Add the griddisks back into the ASM diskground they used to be a member of.
- B. Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
- C. Replace the failed physical disk.
- D. Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
- E. Create a new celldisk and new griddisks on the replaced physical disk.
Answer: C,D
Explanation:
Explanation/Reference:
You may need to replace a physical disk because the disk is in warning - predictive failure status. The predictive failure status indicates that the physical disk will soon fail, and should be replaced at the earliest opportunity. The Oracle ASM disks associated with the grid disks on the physical drive are automatically dropped, and an Oracle ASM rebalance relocates the data from the predictively failed disk to other disks.
Note: After the physical disk is replaced, the grid disks and cell disks that existed on the previous disk in that slot are re-created on the new physical disk. If those grid disks were part of an Oracle ASM group, then they are added back to the disk group, and the data is rebalanced on them, based on the disk group redundancy and ASM_POWER_LIMIT parameter.
References: http://docs.oracle.com/cd/E80920_01/DBMMN/maintaining-exadata-storage- servers.htm#DBMMN21047
NEW QUESTION 34
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:
Explanation/Reference:
The Oracle Enterprise Manager Grid Control Exadata Monitoring plug-in bundle allows you to monitor the following key components of Exadata machine:
Oracle ILOM: The plug-in monitors the Oracle ILOM card in a database server for hardware events and
records sensor data.
InifiniBand Switch: The plug-in enables Enterprise Manager Grid Control to monitor the Oracle
DataCenter36 Infiniband Switch.
Avocent MergePoint Unity Switch: The Plug-in enables Enterprise Manager Grid Control to monitor
KVM (keyboard, video or visual display unit, mouse) targets. The plug-in provides status of the KVM and the event occurrences like Factory Defaults Set, Fan Failure, Aggregated TargetDevice Status, Power Supply Failure, Power Supply Restored, Reboot Started, Temperature Out of Range on the KVM target.
Cisco Switch: The plug-in enables Enterprise Manager Grid Control to monitor Cisco Switch targets.
This plug-in will monitor the Cisco switch's CPU, memory, temperature, network interfaces, system information, fan, and power supply metrics.
Power Distribution Unit: The plug-in will be used to monitor PDU's actual current value of Phase1,
Phase2, and Phase3
References: http://www.oracle.com/technetwork/oem/grid-control/exadata-plug-in-bundle-188771.html
NEW QUESTION 35
Which three are true concerning Smart Scans?
- A. Smart Scans are only possible during full table scans or fast full index scans.
- B. Smart Scans always outperform scans that are not offloaded.
- C. Smart Scans are possible on Index Organized Tables (IOTs).
- D. Smart Scans are possible on heap organized tables.
- E. Smart Scans are possible on uncompressed B*Tree indexes.
- F. The decision to perform a Smart Scan is made by the Optimizer.
Answer: A,E,F
Explanation:
Explanation/Reference:
B: In order for queries to take advantage of Exadata's Offloading capabilities, the optimizer must decide to execute a statement with a Full Table Scan or a Fast Full Index Scan.
F: Smart Scans can be used for full scanning through B*Tree index segments.
References: Expert Oracle Exadata - K Osborne, et al., (Apress, 2011) BBS, page 346
NEW QUESTION 36
Identify three facilities that can use X5 Extreme Flash Exadata Storage Server flashdisk space.
- A. Exadata Smart Flash Cache
- B. Database Smart Flash Cache
- C. cell boot flash image
- D. Cell System Area
- E. Exadata Smart Flash Log
Answer: A,C,E
NEW QUESTION 37
......
1z0-070 EXAM DUMPS WITH GUARANTEED SUCCESS: https://www.dumps4pdf.com/1z0-070-valid-braindumps.html