20 December, 2020

Vivid Oracle 1z0-070 Free Samples Online

Guaranteed of 1z0-070 download materials and practice for Oracle certification for IT candidates, Real Success Guaranteed with Updated 1z0-070 pdf dumps vce Materials. 100% PASS Oracle Exadata X5 Administration exam Today!

Also have 1z0-070 free dumps questions for you:

Page: 1 / 7

Total 90 questions Full Exam Access

Question 1

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?

the database server Clusterware

the storage server ILOM

ASM instances

the database server O/S

the Infiniband switches

Question 2

In which scenario will griddisks residing on the same celldisk have balanced performance characteristics in an X5 High Capacity Exadata Storage Server?

griddisks on memory based celldisks

griddisks on hard disk-based celldisk consumed by ASM when creating diskgroups using ASM-based Intelligent Data Placement (IDP)

griddisks on hard disk-based celldisks consumed by the Database Smart Flash Cache

griddisks on Flash-based celldisks

Question 3

You installed ASR Manager on a stand-alone server and configured Auto Service Request (ASR) for your X5 Database Machine and its assets.
Which three statements are true about this configuration?

Simple Network Management Protocol (SNMP) traps are used to send notifications fromdatabase servers to the ASR Manager.

Simple Network Management Protocol (SNMP) traps are used to send notifications from storage servers to the ASR Manager.

When a component fault occurs, fault telemetry is securely transmitted to Oracle via Simple Network Management Protocol (SNMP).

When a component fault occurs, fault telemetry is securely transmitted to Oracle via HTTPS.

Simple Network Management Protocol (SNMP) traps are used to send notifications from the Enterprise Manager to the ASR Manager.

Simple Network Management Protocol (SNMP) traps received by ASR Manager are forwarded to the Enterprise Manager.

Question 4

Examine this IORM plan:
1Z0-070 dumps exhibit

Which two are true concerning this plan?

The Finance database can use at least 45%, but never more than 60%, of the total Flash Cache capacity.

I/Os from the finance database are guaranteed to get a minimum of 45% of the I/O bandwidth if the demand exists, and a maximum of 60% of the I/O bandwidth even if noother databases are doing I/O to the cell, and the demand from the finance database exceeds 60% of the maximum I/O rate of the cell.

If I/Os come from the HR database only, then they may get up to 100% of the I/O bandwidth on the cell.

I/Os from the finance database are guaranteed to get 45% of the I/O bandwidth if the demand is at least 60% of the maximum I/O rate of the cell, but may get 100% of the I/O bandwidth if no other databases are performing I/O to the cell.

If I/Os come from the HR database only, then they may get up to 10% of the I/O bandwidth on the cell.

Question 5

Which four statements are true about the configuration of Auto Service Request (ASR) for use with an X5 Database Machine?

ASR Manager software may be installed on one of the database servers in the Database Machine.

ASR can connect to the Internet using Simple Network Management Protocol (SNMP), using a proxy server.

ASR Manager can connect to the Internet directly with HTTPS.

ASR Manager can connect to the Internet with HTTPS using a proxy server.

ASR can connect to the Internet directly using Simple Network Management Protocol (SNMP).

ASR Manager software may be installed on a server that is not part of the Database Machine.

Question 6

Because of a motherboard failure on an X6 high-capacity Exadata storage server, you must replace the server chassis with a replacement unit.
Which are three of the components must you move from the original Exadata storage server to the new Exadata storage server?

Redundant power supplies

The host bus channel adaptor

The USB flash drive

The four Sun Flash Accelerator PCIe cards

The 12 physical disks

Question 7

You plan to migrate an Oracle database that supports an online transaction processing (OLTP) workload to your X6 Database Machine. The Database Machine database version is 11.2.
You plan to perform a physical database migration using Transportable Database. Which two are requirements for this method?

The source database must be deployed on a Little Endian platform,

The source database must be at least 11.1.

The source database must be at least 11.2.

The source database must use only bigfile tablespaces.

The source database must be deployed on a Big Endian platform.

The source database must not use bigfile tablespaces.

Question 8

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?

An improved highly efficient undo and redo architecture

Faster optimization due to an Exadata-specific optimizer

Reduced I/O latency for writes due to writeback flashcache on all Exadata X5 and later models

Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models

Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models

Question 9

Which two statements are true about backup performance when using Recovery Manager (RMAN) on an X5 Database Machine?

Backups are fast because the Infiniband network is faster than fiber channel storage, so RMAN read I/O operations are faster than in traditional storage networks.

Backups are fast, because physical I/Os operations are reduced by the use of the Storage Index by cellsrv.

Backups are fast, because data blocks are read from the Database Flash Cache.

Backups are fast, because all data blocks are read from the Exadata Smart Flash Cache.

For incremental backups using Block Change Tracking, cellsrv filters blocks and returns only those that have changed since the last backup.

Question 10

Which two completely prevent a Smart Scan from occurring?

querying a table containing many chained rows

querying a table containing many migrated rows

performing a minimum or maximum function on an indexed column

performing a Fast Full Index scan on a reverse key index

referencing more than 255 columns form an OLTP compressed table in a query

querying a table containing a JSON column

Question 11

Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle’s recommended best practices.
Which three actions could you take to do this?

Use a cron job on a database node to run it at regular intervals.

Use a cron job on each cell to run it at regular intervals.

Run it once each cell and it will then perform periodic monitoring automatically.

Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.

Use exachk to schedule itself to run at regular intervals.

Question 12

Which three statements are true about Exadata storage server alerts in an X5 Database Machine?

Storage server alerts notifications may be sent using SNMP.

A threshold- based alert gets cleared automatically when the measured value no longer violates the threshold.

A storage server alert is only ever issued as a warning or at a critical situation.

Storage server alerts are all stateless alerts.

Storage server alerts are all stateful alerts.

Storage server alerts notifications may be sent using SMTP.

Question 13

Which three are sources for alerts from storage servers in an X5 Database Machine?

Software errors reported by the MS process on the storage servers

Hardware sensor alerts reported by the CELLSRV process on the storage servers

Software errors reported by the RS process on the storage servers

Hardware sensor alerts detected by the ILOM on the storage servers

Metrics that have administrator-defined thresholds on the storage servers

Question 14

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?

You might retain the index, and leave it as invisible, and the constraint will still be recognized and enforced.

You must retain the index and make it visible again for the constraint to be recognized and enforced.

You must retain the index and set the constraint to DISABLE NOVALIDATE RELY for the constraint to be recognized.

You might drop the index and use a constraint with the DISABLE NOVALIDATE RELY flags for the constraint to be recognized.

You might drop the index and make the constraint invisible, for the constraint to be recognized and enforced.

Question 15

Which three are recommended options on an X5 Exadata Database machine, for staging files that will be loaded as external tables?

on an ACFS file system stored in a staging database on the Database Machine

a ZFS over NFS file system mounted on a database server where the external table will be accessed

an Exadata-based ACFS file system on the Database Machine

a DBFS file system stored in a staging database on the Database Machine

on local storage on one or more storage servers that are accessible to the database server where the load will be performed

Question 16

Which two statements are true about the use of Intelligent Platform Management Interface (IPMI) on an X5 or X6 Database Machine?

IPMI can be used for server configuration and management on each database server.

The Baseboard Management Controller (BMC), which supports IPMI, runs as amultithreaded process on the storage server O/S.

The Baseboard Management Controller (BMC), which supports IPMI, runs as a single- threaded process on the storage server O/S.

IPMI can be used for server configuration and management on each storage server.

Question 17

An important application has been migrated to a database on an X5 Database Machine.
You are examining high-load SQL statements from this application, in an attempt to determine which ones will benefit from the Exadata Smart Scan capability.
Which three access paths always generate “cell single block physical read” or “cell multiblock physical read” requests?

Index fast full scans executed in parallel

Full table scans on heap organized tables executed in parallel

Full table scans on heap organized tables executed serially

Full table scans on index organized tables executed in parallel

Index unique scan access by primary key to heap organized tables executed in parallel

Index unique scan access by primary key to heap organized tables executed serially

Question 18

Which three statements are true about the EXADCLI utility?

It may be run interactively.

It can be used to execute EXACLI scripts on multiple storage servers in parallel.

It can be used to execute O/S commands on multiple storage servers in parallel.

It can be used to execute EXACLI commands on multiple storage servers in parallel.

It uses the same security mechanism as the EXACLI command.

It may be used to execute DBMCLI commands on multiple database nodes in parallel.

Question 19

Which type or types of network traffic are transported over the internal InfiniBand interconnect in Exadata Database Machine X5?

IDB protocol traffic, clustered ASM traffic, and clustered database instance traffic

IDB protocol traffic and clustered database instance traffic only

IDB protocol traffic and clustered ASM instance traffic only

Both clustered ASM and clustered database instance traffic only

IDB protocol traffic only

Question 20

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

All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.

Some SNMP notifications may be configured using the alter cell command on the storage servers.

The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.

Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.

All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.

All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.

My answer: -

Reference answer: BDE

Reference analysis:

B: You can configure SNMP Trap Destinations for the Exadata Storage Servers with the following command:
# cellcli -e “alter cell snmpSubscriber=(host =\'ASR-Manager-name-or-IP- address\',port=162,community=public,type=asr)”
D: Exadata Storage Server plug-in
This extends the monitoring of exadata cells in addition to providing a GUI interface. The plug-in uses an SSH connection to the cellmonitor user on the cells and uses list commands only. This is for interactive monitoring. One may also set thresholds using the plug-in which are distinct from any thresholds set using cellcli utility as the celladmin user. For alerts to be sent to the plug-in, SNMP traps are used as follows:
Cell ILOM alerts are sent to the cell Management Server (MS) via an SNMP trap. The MS then send SNMP notifications onward to the plug-in.
Cell alerts flagged by MS itself, such as cell thresholds being exceeded, or ADR software alerts, are sent to the plug-in using SNMP.
E: Database Server ILOM plug-in
Monitoring databases and their instances, ASM environments, the Grid Infrastructure, and the host software environment are done by Enterprise Manager in the usual way as these are standard targets. But monitoring the hardware for the database servers requires the ILOM plug-in, as there is no Management Server (MS) on the database servers to receive SNMP traps from the ILOM. The plug-in will receive sensor state and availability data from
the ILOM including alerts based on pre-set ILOM thresholds.
References: https://dbatrain.wordpress.com/2011/06/
http://docs.oracle.com/cd/E21659_01/html/E21660/z40015671004046509.html

Question 21

You are evaluating the performance of a SQL statement that accesses a very large table. You run this query:
1Z0-070 dumps exhibit

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.

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.

There are chained rows in the table, causing some “single block physical reads” to be requested by the database instance, resulting in additional I/O.

The table is a hash clustered table, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.

The table is list partitioned, causing “cell list of blocks physical reads” to be requested by the database instance, resulting in additional I/O.

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.

Page: 1 / 7

Total 90 questions Full Exam Access