Authentic 1z1-902 Dumps - Free PDF Questions to Pass [Q36-Q52]

Authentic 1z1-902 Dumps - Free PDF Questions to Pass

Guaranteed Accomplishment with Newest Sep-2023 FREE 1z1-902

Oracle Exadata Database Machine X8M is a high-performance database machine that is designed to deliver extreme performance for database workloads. The machine combines the performance of flash memory with the scalability of a shared storage architecture to deliver unmatched performance for Oracle Database workloads. The machine is designed to handle the most demanding workloads and is optimized for both OLTP and data warehousing workloads. With its unique architecture and advanced features, the Exadata Database Machine X8M is a game-changer in the world of database systems.

Oracle Exadata Database Machine X8M is an engineered system that integrates hardware and software components to provide a high-performance, highly available, and scalable database platform. The machine is designed to deliver extreme performance for online transaction processing (OLTP) and data warehousing workloads. The Exadata Database Machine X8M includes high-speed InfiniBand networking, flash storage, and Oracle Database software, which are integrated to provide a highly optimized and efficient system.

 

NEW QUESTION # 36
Which three steps are required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration?

• A. Add 16x 64GB DIMMs.
• B. Remove existing memory modules.
• C. Memory cannot be expanded on Exadata X9M-2 Database Servers.
• D. Add 12x 32GB DIMMs.
• E. Add 24x 32GB DIMMs.
• F. Add 16x 32GB DIMMs.
• G. Add 12x 64GB DIMMs.
• H. Add 32x 64GB DIMMs.
• I. Shutdown the Database Server if running.

Answer: A,B,I

Explanation:
1. Remove existing memory modules: Before adding new memory modules, the existing memory modules should be removed.
2. Add 16x 64GB DIMMs: The new DIMMs should be added, in this case is 16 DIMMs of 64GB each, which will expand the memory to the highest configuration available.
3. Shutdown the Database Server if running: The Database Server should be shutdown before adding new memory modules in order to prevent any possible data loss or corruption.
The steps required to expand an Exadata X9M-2 Database Server with the lowest memory configuration available to the highest memory configuration are as follows:
Shutdown the Database Server if running.
Remove existing memory modules.
Add 16x 64GB DIMMs.
For reference, the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book states that "the lowest memory configuration for the Exadata X9M-2 Database Servers is 384GB and the highest is 768GB [1]. The memory upgrade is done in increments of 64GB using 16x 64GB DIMMs".

NEW QUESTION # 37
What are two recommended configuration best practices for backup and recovery on Exadata?

• A. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
• B. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
• C. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
• D. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.

Answer: B,D

NEW QUESTION # 38
Which two Exadata security features would you configure to control which databases can access which griddisks, when multiple databases share space on your storage servers in an unpartitioned storage grid?

• A. File permissions on the griddisks in each storage server
• B. File permissions on the griddisks in each database server
• C. Using EXADCLI instead of CELLCLI to create the griddisks
• D. Exadata storage realms using database-scoped security mode
• E. Exadata storage realms using ASM-scoped security mode

Answer: A,E

Explanation:
When multiple databases share space on the storage servers in an unpartitioned storage grid, two Exadata security features can be configured to control which databases can access which griddisks.
Exadata storage realms using ASM-scoped security mode: This feature allows you to create storage realms and assign them to specific databases. This allows you to control which databases have access to which griddisks. The ASM-scoped security mode applies to all griddisks within an ASM disk group, which means that all griddisks in a disk group will be accessible only to the databases that belong to the assigned storage realm.
File permissions on the griddisks in each storage server: This feature allows you to configure file permissions on the griddisks at the storage server level. You can assign specific permissions to specific users or groups, allowing you to control which databases can access which griddisks.

NEW QUESTION # 39
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Install in Oracle Virtual Machine with required hardware.
• B. Install on Exadata Engineered System.
• C. Provide individual x86 64-Bit gateway hardware.
• D. Install on Oracle Database Appliance.
• E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer: C,D,E

Explanation:
According to Oracle's documentation1, the customer options for hosting the Platinum Services Advanced Support Gateway are:
Provide individual x86 64-Bit gateway hardware1
Purchase the recommended x86 64-Bit gateway hardware from Oracle1
Install on Oracle Database Appliance2

NEW QUESTION # 40
Which two statements are correct about adding an additional database server to a physical Exadata X9M Database Machine using Oracle Exadata Deployment Assistant (OEDA)?

• A. The applyElasticConfig.sh script performs network configuration for the new servers. The new servers are restarted at the end of the process.
• B. It is required to install OEDA on the first new database server.
• C. Do not proceed if the OEDA Validate Configuration File step displays an error message about missing files p6880880.zip.
• D. In order to configure the servers with Oracle Exadata Deployment Assistant (OEDA), the new server information must be entered in OEDA, and the configuration file must contain existing nodes.
• E. Executing /opt/oracle.supportTools/reclaimdisks.sh -free -reclaim on each Exadata X9M Database server is required to reclaim disk space and perform partition reconfiguration.

Answer: A,D

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/21/ladbi/db-on-exadata.html

NEW QUESTION # 41
You are adding a disk expansion kit to a running Exadata X8M Database Machine's Database Servers, and have a filesystem layout that includes:

After running the following commands, which command needs to be run to add 20G of space to the filesystem mounted on /u01?

• A. # xfs_growfs /uOl +20G
• B. # lvextend -L +20G -verbose /dev/mapper/VGExaDb-LVDbOral
• C. # resize2fs +20G /dev/VGExaDb/LVDbOral
• D. # lvextend -L +20G -verbose /dev/VGExaDb/LVDbOral

Answer: B

Explanation:
After running the commands above, the filesystem mounted on /u01 is on the logical volume /dev/mapper/VGExaDb-LVDbOral. So, to add 20G of space to the filesystem mounted on /u01, the command that needs to be run is:
lvextend -L +20G --verbose /dev/mapper/VGExaDb-LVDbOral
This command will extend the logical volume /dev/mapper/VGExaDb-LVDbOral by 20 GB of space. It is important to note that the option --verbose is used to display the progress of the operation.

NEW QUESTION # 42
You have been tasked with replacing a memory module of an Exadata Storage Server and need to power off the affected storage server. Which two commands must you execute to safely power off the storage server in an Exadata X9M Database Machine?

• A. 'crsct1 stop cluster -all' on one of the database servers
• B. CeLLCLI> list GRIDDISK where status != 'inactive' on the affected storage server
• C. CeLLCLI> alter cell shutdown SERVICES all on the affected storage server
• D. CellCLI alter GRIDDISK all inactive on the affected storage server
• E. shutdown -h now' on the affected storage server
• F. CellCLI LIST GRIDDISK ATTRIBUTES name WHERE asmdeactivationoutcome != 'Yes' on the affected Storage server

Answer: D,E

Explanation:
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmmn/maintaining-exadata-storage-servers.html#GUID-AE16A1DA-53C6-4E80-94E5-963AA65373AB The two commands that must be executed to safely power off the storage server in an Exadata X9M Database Machine are E and F.
Command E, CellCLI alter GRIDDISK all inactive, will deactivate all of the GRIDDISKS on the affected storage server. This will ensure that no data is lost during the power-off process.
Command F, shutdown -h now, will shut down the storage server. This will ensure that the storage server is completely powered off and no data is lost.
For more information on how to properly power off an Exadata Storage Server, refer to the Oracle Exadata Database Machine X9M Implementation Essentials official text book and resources [1][2].

NEW QUESTION # 43
Your system administrator reports an amber, non-blinking light on one of your Exadata storage disks. You immediately execute the 'list physicaldisk where diskType=HardDisk and status=failed DETAIL' command on the Exadata storage system and the specified disk is indeed reported as failed. Platinum Support has not been enabled for this system. Enterprise Manager Cloud Control is monitoring the system.
What is the next step that you should perform before you do anything else?

• A. Ask the system administrator to replace the broken disk with a spare.
• B. Wait for a blue light to appear on the disk if the rebalance operation is running.
• C. Wait for the email of the failure that Exadata or Enterprise Manager will send.
  E Download and run the latest exadiag tool.
• D. Check the database to see if any rebalance operations are active.
• E. Call Oracle Support and make an appointment so that the drive can be replaced.

Answer: A

NEW QUESTION # 44
You have been asked to investigate why an Exadata Database Server stopped communicating on the client network for 10 minutes over the past weekend.
Which command would help investigate this?

• A. # /opt/oracle.SupportTools/ibdiagtools/netcheck/runDiagnostics.pm -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• B. $ ${ORACLE_HOME}/suptools/tfa/release/tfa_home/bin/tfact1 -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• C. # /opt/oracle.SupportTools/exachk/exachk -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00
• D. # /opt/oracle.ExaWatcher/GetExaWatcherResults.sh -from <Fridays_Date>_17:00:00 -to <Sundays_Date>_23:59:00

Answer: A

NEW QUESTION # 45
Which statement is true about the patching features provided in Platinum Services?

• A. The rolling and complete down time approaches are two options to patching.
• B. Oracle Platinum Service covers Exadata storage software and firmware patching, but customers must perform the database patching.
• C. Patching is done automatically during business hours.
• D. Patching services are available for the full software stack up to twice per year.

Answer: D

Explanation:
Oracle Platinum Services provides patching features for the full software stack, which includes operating systems, virtualization, storage software and firmware, and databases. This service is typically performed up to twice per year, allowing customers to schedule the patching at their convenience. The patching is usually done to keep the software and firmware up-to-date and to fix any known security vulnerabilities. It's important to note that patching services are not done automatically during business hours, customer's involvement and schedule is needed, and the rolling and complete downtime approaches are options to minimize the impact on the system during patching.

NEW QUESTION # 46
Examine these commands:
1. Execute "crscti stop cluster -all" as the grid user from one database server.
2. Execute "crscti stop cluster -all" as root from one database server.
3. Power off all network switches.
4. Execute "crscti stop cluster" as root from one database server.
5. Execute "crscti stop cluster" as the grid user from one database server.
6. Power off the rack using the power switches on the PDUs.
7. Execute "shutdown -h now" on all database servers.
8. Execute "shutdown -h now" on all Exadata storage servers.
Which is the correct order or the required commands to completely power off an Exadata Database Machine in an orderly fashion?

• A. 2, 7, 8, and 6
• B. 1, 8, 7, 3 and 6
• C. 5, 8, 7, and 6
• D. 2, 8, 7, 3, and 6
• E. 4, 7, 8, 3, and 6

Answer: C

Explanation:
Option 5 stops the clusterware on all database servers as the grid user3.
Option 8 shuts down all Exadata storage servers using their ILOM interfaces1.
Option 7 shuts down all database servers using their ILOM interfaces1.
Option 6 powers off the rack using the power switches on the PDUs2.

NEW QUESTION # 47
How do ASM failure groups provide redundancy?

• A. Failure groups are created for each grid disk to ensure mirror copies are written to the same storage server for faster recovery after a physical disk failure.
• B. Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.
• C. They ensure that the ASM Flex instances are enabled on a maximum of two database servers or VMs per cluster.
• D. Extended Redundancy mirrors data across data centers providing the highest levels of data protection.

Answer: B

Explanation:
According to Oracle's documentation12, ASM failure groups provide redundancy by storing mirror copies of data on different disks or storage servers. When ASM allocates an extent for a normal redundancy file, ASM allocates a primary copy and a secondary copy. ASM chooses the disk on which to store the secondary copy so that it is in a different failure group than the primary copy1. This way, if one disk or storage server fails, ASM can still access the data from another failure group2.
Therefore, the statement that is true about how ASM failure groups provide redundancy is:
Failure groups contain all ASM disks in a single storage server preventing mirror copies being written to the same storage server.

NEW QUESTION # 48
Which two statements are true about Auto Service Request (ASR) with an Exadata Database Machine?

• A. ASR Manager must be installed and configured on one of the database servers.
• B. ASR communicates with Oracle support services using HTTPS.
• C. Configuring ASR is mandatory for all Database Machine assets.
• D. ASR can upload configuration metadata to support problem resolution.
• E. ASR Manager opens a service request (SR) automatically after sensors detect hardware faults.
• F. ASR Manager must be installed and configured on a dedicated server external to the Database Machine.

Answer: B,F

Explanation:
A and F are true statements about Auto Service Request (ASR) with an Exadata Database Machine [1][2]. In order to use the ASR feature, ASR Manager must be installed and configured on a dedicated server which is external to the Database Machine, and it communicates with Oracle support services using HTTPS. Additionally, ASR can upload configuration metadata to support problem resolution, and it can open a service request (SR) automatically after sensors detect hardware faults.
Reference for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources [1][2].

NEW QUESTION # 49
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?

• A. OS I/O metrics using Enterprise Manager host pages for the storage servers
• B. OS I/O metrics using OS tools such as iostat on the storage servers
• C. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
• D. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us
• E. OS I/O metrics using OS tools such as iostat on the database servers

Answer: A,C

Explanation:
1. OS I/O metrics using Enterprise Manager host pages for the storage servers: Enterprise Manager provides a detailed view of the storage server's performance including I/O metrics and statistics. You can use these metrics to analyze I/O performance and identify any bottlenecks.
2. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk: These commands are used to gather information about storage server performance, including I/O statistics, disk usage, and resource allocation.

NEW QUESTION # 50
Which are three customer options for hosting the Platinum Services Advanced Support Gateway?

• A. Provide individual x86 64-Bit gateway hardware.
• B. Install on Oracle Database Appliance.
• C. Install in Oracle Virtual Machine with required hardware.
• D. Install on Exadata Engineered System.
• E. Purchase the recommended x86 64-Bit gateway hardware from Oracle.

Answer: B,C,D

Explanation:
The Platinum Services Advanced Support Gateway is a component of Oracle's Platinum Services offering that enables customers to access advanced support features and tools, such as automated problem diagnosis and resolution. Customers have the option to host the Advanced Support Gateway on an Oracle Database Appliance, Oracle Virtual Machine with required hardware, or an Exadata Engineered System. These options allow customers to leverage existing infrastructure and resources to host the gateway, rather than needing to purchase and install new hardware. Providing individual x86 64-Bit gateway hardware or purchase the recommended x86 64-Bit gateway hardware from Oracle are also options but it depends on the customer's infrastructure and resources.

NEW QUESTION # 51
You have a script with several CELLCLI commands that must be executed on each cell in your Exadata full rack. The script must run on each cell simultaneously. How must you achieve this?

• A. Copy and execute the script on all storage servers using the dcli command.
• B. Copy the script to all storage servers using the CELLCLI command and execute it on all storage servers in parallel using the CELLCLI command.
• C. Copy and execute the script on all storage servers using the EXACLI command.
• D. Copy the script to all storage servers using the dcli command and manually execute it on all storage servers using the EXACLI command.
• E. Copy the script to all storage servers using the dcli command and manually execute it on each storage server using the DCLI command.

Answer: A

NEW QUESTION # 52
......

1z1-902 Braindumps PDF, Oracle 1z1-902 Exam Cram: https://actualtests.vceengine.com/1z1-902-vce-test-engine.html