Oracle Exadata Database Service Professional (1Z0-1193-26) - Practice Exam 1

1. A backup policy is configured, but no restore has been tested. What is missing from recovery assurance?
2. A company wants centralized external management of Exadata database TDE master keys. Which supported option should it evaluate?
3. A cost-saving plan scales enabled CPU to zero and assumes all Exadata infrastructure charges stop. What should be corrected?
4. A critical transactional database loses I/O service to a large reporting database during contention. What should be evaluated?
5. A database is migrated to external key management. What must the operations plan address?
6. A database patch attempt fails. Which response best preserves supportability?
7. A DBA needs Performance Hub information but Database Management has not been enabled. What should be checked?
8. A DBA proposes installing an unapproved diagnostic package directly on managed storage cells. What boundary should the reviewer enforce?
9. A DBA wants evidence that a large query benefits from storage offload. Which observation is relevant?
10. A developer requests manually creating and rebuilding Exadata storage indexes like ordinary application B-tree indexes. What is the correct response?
11. A licensing review compares license-included and BYOL deployment choices. What should guide the decision?
12. A local VM task specifically needs the supported database lifecycle utility. Which tool is relevant?
13. A major database upgrade is planned. What should occur before the upgrade action?
14. A new VM cluster fails provisioning after intra-cluster TCP traffic is blocked. What should be checked first?
15. A new VM cluster will use SSH for authorized administration. Which key material should be provided during the supported setup?
16. A primary and healthy standby must exchange roles during planned maintenance. Which operation is appropriate?
17. A private Exadata deployment needs access to OCI Object Storage without public internet routing. Which network component should be evaluated?
18. A query selects many unnecessary large columns during an eligible table scan. What change can improve the benefit from column filtering?
19. A reporting query scans a large table but returns only a few columns and rows. Which Exadata capability can reduce data sent to database servers?
20. A scan predicate excludes the value range present in many storage regions. Which automatic capability can avoid reading those regions?
21. A security reviewer assumes encrypted tablespaces always prevent Exadata scan offload. Which statement is correct?
22. A specialized backup operation requires the documented local backup interface. Which tool should be considered?
23. A storage cleanup proposes deleting encryption keys still used by retained database backups. What is the correct response?
24. A team opens SQL access to every internet address for convenience. What is the safer production design?
25. A team selects Exadata Database Service on Dedicated Infrastructure and expects Oracle to administer every application schema. Which responsibility statement is accurate?
26. A team sets very strict data-loss tolerance but ignores intersite commit latency. What should guide protection-mode selection?
27. A team wants to choose ASM or Exascale storage for a new supported VM cluster. Which planning point matters?
28. A VM cluster request exceeds available resources in its selected infrastructure. What is the appropriate response?
29. A workload needs more database CPU capacity without immediately adding physical servers. What supported action should be evaluated?
30. After migration, a warehouse workload keeps every legacy index and forces index plans for large scans. What should the tuning review do?
31. An accidental committed update has already been applied on the standby. Which protection remains important?
32. An alarm is configured at a finer interval than the database metrics are emitted. What should the operator change?
33. An application database needs a tested new release update while other databases must remain on their current software. Which approach should be evaluated?
34. An application has a short peak with proven CPU saturation and spare supported infrastructure capacity. Which action is worth testing?
35. An architect needs separate controls for physical server capacity and guest database resource allocation. Which resource hierarchy fits?
36. An Exadata infrastructure has spare capacity, and another isolated database workload needs a separate VM cluster. What should be checked?
37. An infrastructure resource exists, but the requested database has no guest cluster to run on. Which dependency must be satisfied?
38. An operator must perform a lifecycle action available in the OCI Console and API. What is the preferred general approach?
39. An operator says changing the COMPATIBLE setting is merely a cosmetic version-label change. What should the DBA explain?
40. Backup automation needs access to a designated Object Storage bucket. Which IAM approach is appropriate?
41. Capacity planners need trends across an extended workload history rather than one instantaneous CPU sample. Which capability is relevant?
42. Consolidated databases compete for shared Exadata I/O. Which control is designed for allocating their storage I/O priorities?
43. Database CPU utilization is modest, but transactions are slow and sessions are blocked. What is the most useful next step?
44. Forecast growth requires additional storage capacity without proportional database compute growth. What should the architect examine?
45. One PDB is slow while others remain healthy. Which investigation is most targeted?
46. Private database nodes need Object Storage, OS repository, IAM, and Vault access while avoiding general internet exposure. Which design is appropriate?
47. RAC protects against a database instance failure, but the business also requires recovery from a regional disaster. What should be added?
48. The application reaches the client listener, but automated backups cannot reach their OCI destination. What should be inspected?
49. Two databases have no custom IORM policy, and the team assumes one receives higher priority because it was created earlier. What should be clarified?
50. Two VM clusters have similar display names, and automation must identify the correct target. Which identifier should be used?

Comments — 0