Download Oracle Exadata X5 Administration.actualtests.1z0-070.2020-01-17.1e.61q.vcex


Download Exam

File Info

Exam Oracle Exadata X5 Administration
Number 1z0-070
File Name Oracle Exadata X5 Administration.actualtests.1z0-070.2020-01-17.1e.61q.vcex
Size 914 Kb
Posted January 17, 2020
Downloads 2



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
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: 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.
  • 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: Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.



Question 2
Which three statements are true concerning the configuration of SNMP on an Exadata x5 or x6 Database Machine?

  • A: All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.
  • B: Some SNMP notifications may be configured using the alter cell command on the storage servers.
  • C: The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.
  • D: Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.
  • E: All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.
  • F: All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.



Question 3
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 4
Which three storage components are available after nonvirtualized standard deployment of an X5 Database Machine using high-capacity disks?

  • A: mirrored system area on hard disk 0, hard disk 1, and hard disk 2
  • B: Exadata Smart Flash Cache using all of the flashdisk space
  • C: the DBFS_DG diskgroup with high redundancy
  • D: mirrored system area on hard disk 0 and hard disk 1
  • E: the RECO_<DBM_Name> ASM diskgroup
  • F: the DATA_<DBM_Name> ASM diskgroup



Question 5
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: total_mb
  • C: required_mirror_free_mb
  • D: free_mb
  • E: usable_file_mb



Question 6
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 7
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 8
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 9
Which two are true about Smart Scan?

  • A: A query rewrite may occur to a materialized view stored in Exadata, and it will always benefit from Smart Scan.
  • B: Column projection does not contribute to the performance benefit of Smart Scan.
  • C: A query rewrite may occur to a materialized view stored in Exadata but will never benefit from Smart Scan.
  • D: It is possible to offload single row functions to the Exadata Storage Servers.
  • E: Join processing can be partly offloaded to Exadata Storage Servers.
  • F: Join processing can be fully offloaded to Exadata Storage Servers.



Question 10
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.









CONNECT US


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