Download Oracle Exadata X5 Administration.test-inside.1z0-070.2020-06-02.1e.62q.vcex


Download Exam

File Info

Exam Oracle Exadata X5 Administration
Number 1z0-070
File Name Oracle Exadata X5 Administration.test-inside.1z0-070.2020-06-02.1e.62q.vcex
Size 767 Kb
Posted June 02, 2020
Downloads 36



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



Demo Questions

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.



Question 2
Which three statements are true regarding the configuration of Auto Service Request (ASR) on an X5 Database Machine?

  • A: ASR Manager may be installed on any type of server running Oracle Solaris.
  • B: ASR Manager may be installed on any type of server running Oracle Linux.
  • C: Oracle Linux must be used on the server where ASR Manager is installed.
  • D: SMTP must be enabled on at least one database server.
  • E: Oracle Solaris must be used on the server where ASR Manager is installed.
  • F: ASR Manager must be installed on one of the database servers.
  • G: HTTPS connectivity must be enabled from the ASR Manager host to the Internet. 



Question 3
You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine. 
A part of the requirement is to provide for high availability of the monitoring infrastructure. 
If the host running the agent that has Database Machine targets bound to it fails, the monitoring of these targets must be done by another agent. 
Which three statements are true regarding the configuration used to support this requirement?

  • A: Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.
  • B: Fail back to the original agent when the host is restarted is done automatically.
  • C: Fail over to any secondary agent is done automatically.
  • D: Fail over to any secondary agent must be done manually.
  • E: Database machine plug-ins must be deployed to all Enterprise Manager agents.
  • F: Fail back to the original agent when the host is restarted must be done manually.



Question 4
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 diskgroup they used to be a member of.
  • B: Create a new celldisk and new griddisks on the replaced physical disk.
  • C: Verify that the griddisks located on the physical disk have been successfully dropped from the associated ASM diskgroups.
  • D: Identify the griddisks located on the failed physical disk and drop them from the associated ASM diskgroups.
  • E: Replace the failed physical disk.



Question 5
Which two completely prevent a Smart Scan from occurring?

  • A: querying a table containing many chained rows
  • B: querying a table containing many migrated rows
  • C: performing a minimum or maximum function on an indexed column
  • D: performing a Fast Full Index scan on a reverse key index
  • E: referencing more than 255 columns form an OLTP compressed table in a query
  • F: querying a table containing a JSON column



Question 6
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).



Question 7
Which two are true concerning Columnar Flash Caching?

  • A: It can be enabled or disabled for individual databases by using I/O Resource Manager database plans.
  • B: It automatically transforms ROW STORE COMPRESS compressed data into a pure columnar format during Exadata Smart Flash Cache population.
  • C: Data is either cached in Hybrid Columnar Compressed format or in pure compressed format, but never in both formats at the same time.
  • D: It is enabled by default.
  • E: It automatically transforms Hybrid Columnar Compressed (HCC) data into a pure columnar format during Exadata Smart Flash Cache population.
  • F: It improves single-row lookup performance.



Question 8
You are evaluating the performance of a SQL statement that accesses a very large table. 
You run this query:

  

Identify two reasons why the “cell physical IO interconnect bytes” statistic is greater than the “cell physical IO interconnect bytes returned by smart scan” statistic.

  • A: There is a transaction, which committed after the query began, that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.
  • B: There are chained rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.
  • C: The table is a hash clustered table, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.
  • D: The table is list partitioned, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.
  • E: There is a local index on a list partitioned table on the column used in the WHERE clause, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.



Question 9
Which three are true about Exadata Smart Flash Log?

  • A: Databases on the Database Machine use Exadata Smart Flash Log by default.
  • B: I/O Resource Manager database plans can be used to enable or disable Exadata Smart Flash Log for individual databases.
  • C: LGWR will not wait for writes to Exadata Smart Flash Log if the write to a disk-based logfile completes first.
  • D: I/O Resource Manager category plans can be used to enable or disable Exadata Smart Flash Log for different I/O categories.
  • E: The use of Exadata Smart Flash Logs is mandatory for support of production databases.



Question 10
Which components of an Exadata storage server image, if updated, may require that a patch also be applied to the database servers in an Exadata X6 Database Machine?

  • A: Linux operating system on the storage server
  • B: InfiniBand HCA firmware on the storage server
  • C: Storage server hard disk device drivers
  • D: Storage server flash device drivers








ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset