Exam4Training

SAP C_HCADM_02 SAP Certified Technology Associate – SAP HANA Cloud Provisioning and Administration Online Training

Question #1

Which object types are stored in an SAP HANA catalog? Note: There are 3 correct answers to this question.

  • A . Agents
  • B . Cockpit roles
  • C . HDI containers
  • D . JSON collections
  • E . Cubes

Reveal Solution Hide Solution

Correct Answer: A,D,E
Question #2

Where does the SAP HANA Cloud, SAP HANA database run in SAP BTP? Note: There are 2 correct answers to this question.

  • A . Kubernetes container
  • B . Kyma runtime
  • C . SAP HANA Cloud Central
  • D . Cloud Foundry runtime

Reveal Solution Hide Solution

Correct Answer: B,D
Question #3

Which tool can you use to upgrade an SAP HANA Cloud, SAP HANA database?

  • A . SQL Console
  • B . SAP HANA database lifecycle manager
  • C . SAP BTP command line interface
  • D . SAP HANA Cloud central

Reveal Solution Hide Solution

Correct Answer: D
Question #4

From which sources can you import catalog objects when using the SAP HANA database explorer? Note: There are 3 correct answers to this question.

  • A . Alibaba Cloud OSS
  • B . Exoscale Object Storage
  • C . Azure Storage
  • D . IBM public cloud
  • E . Local Computer

Reveal Solution Hide Solution

Correct Answer: A,C,D
Question #5

Where can you start/stop an SAP HANA Cloud database?

  • A . SAP BTP cockpit
  • B . SAP BTP command line interface
  • C . SAP HANA cockpit
  • D . SAP HANA Cloud central

Reveal Solution Hide Solution

Correct Answer: D
Question #6

What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.

  • A . Higher performance for query operations
  • B . Improved write performance on frequent updates
  • C . Parallel access is improved
  • D . Higher data compression rates

Reveal Solution Hide Solution

Correct Answer: A,B,D
Question #7

Which components are part of SAP HANA Cloud? Note: There are 2 correct answers to this question.

  • A . SAP Enterprise Architecture Designer
  • B . SAP Analytics Cloud
  • C . SAP HANA database
  • D . Data lake

Reveal Solution Hide Solution

Correct Answer: C,D
Question #8

Which mechanisms can you use to authenticate users created in SAP HANA Cloud? Note: There are 3 correct answers to this question.

  • A . JSON Web Token (JWT)
  • B . OATH token
  • C . X.509 certificate
  • D . Security Assertion Markup Language (SAML)
  • E . Kerberos external ID

Reveal Solution Hide Solution

Correct Answer: A,C,D
Question #9

How long after registration will your SAP BTP trial account be automatically deleted?

  • A . 12 months
  • B . 9 months
  • C . 3 months
  • D . 6 months

Reveal Solution Hide Solution

Correct Answer: A
Question #10

Which options for audited action status are available in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

  • A . All
  • B . Procedure executed
  • C . Unsuccessful
  • D . Table accessed

Reveal Solution Hide Solution

Correct Answer: B,D

Question #11

What attributes can you control when creating an SAP HANA Cloud, data lake instance? Note: There are 2 correct answers to this question.

  • A . Compatibility with SAP IQ
  • B . Compatibility with Apache Hadoop
  • C . The availability zone
  • D . The number of coordinators

Reveal Solution Hide Solution

Correct Answer: A,D
Question #12

What options do you have when deploying an SAP HANA Cloud, SAP HANA database with an integrated data lake? Note: There are 2 correct answers to this question.

  • A . Create an SAP HANA Cloud database and later add a data lake.
  • B . Create an SAP HANA Cloud database and include a data lake in one step.
  • C . Create an SAP HANA Cloud database with a separate data lake.
  • D . Create an SAP HANA Cloud database with the data lake on premise.

Reveal Solution Hide Solution

Correct Answer: A,D
Question #13

Which trace can you activate in the SAP HANA cockpit?

  • A . Performance
  • B . Plan
  • C . Expensive Statement
  • D . SQL

Reveal Solution Hide Solution

Correct Answer: C
Question #14

Which files can you access from the SAP HANA database explorer? Note: There are 2 correct answers to this question.

  • A . Compileserver trace
  • B . Available log
  • C . Diserver trace
  • D . Backint log

Reveal Solution Hide Solution

Correct Answer: A,C
Question #15

When creating an SAP BTP trial instance, how does the SAP ID service verify your identity?

  • A . By SAP Authenticator
  • B . By telephone number
  • C . By e-mail address
  • D . By Microsoft Authenticator

Reveal Solution Hide Solution

Correct Answer: C
Question #16

What are some of the typical roles in an SAP HANA Cloud implementation? Note: There are 2 correct answers to this question.

  • A . ABAP developer
  • B . Modeler
  • C . Data architect
  • D . Kubernetes expert

Reveal Solution Hide Solution

Correct Answer: B,C
Question #17

Which tools are available in SAP HANA Cloud Central? Note: There are 2 correct answers to this question.

  • A . SAP Business Application Studio
  • B . SAP HANA Cloud Capacity Unit Estimator
  • C . SAP HANA database explorer
  • D . SAP HANA cockpit

Reveal Solution Hide Solution

Correct Answer: C,D
Question #18

When is the first column store compression executed?

  • A . When the table is created
  • B . When a delta merge is triggered
  • C . When partitions are regenerated
  • D . When a backup is started

Reveal Solution Hide Solution

Correct Answer: B
Question #19

What is the purpose of the SAP HANA Cloud, SAP HANA database explorer HDI container folder?

  • A . It is used by developers to store and execute their development work.
  • B . It holds log and trace files and other diagnosis, error, and information files.
  • C . It represents the data dictionary, including all adapters, indexes, libraries, and data structures.
  • D . It shows used memory and CPU, the most recently started service, and the version information.

Reveal Solution Hide Solution

Correct Answer: A
Question #20

Which database storage technology does native storage extension utilize in SAP HANA Cloud?

  • A . Dynamic tiering
  • B . Extension node
  • C . Disk-based
  • D . In-memory

Reveal Solution Hide Solution

Correct Answer: C

Question #21

What are some of the characteristics of runtime roles in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

  • A . They are granted directly using the SQL GRANT statement.
  • B . They are owned by the user who creates them.
  • C . They are contained in an underlying versioning system.
  • D . They can be transported between systems.

Reveal Solution Hide Solution

Correct Answer: A,B
Question #22

Which services are shared in the Manage Services app in the SAP HANA Cloud database?Note: There are 2 correct answers to this question.

  • A . Compile server
  • B . DP server
  • C . Name server
  • D . DI server

Reveal Solution Hide Solution

Correct Answer: B,D
Question #23

A new version of SAP HANA Cloud, SAP HANA database is available from today.

If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?

  • A . 1 year
  • B . 3 months
  • C . 2 weeks
  • D . 7 months

Reveal Solution Hide Solution

Correct Answer: D
Question #24

Who owns all database objects deployed using the SAP HANA Deployment Infrastructure (HDI)?

  • A . The DBADMIN user of the tenant database
  • B . The container-specific technical user
  • C . The user who created the role
  • D . The _SYS_REPO technical user

Reveal Solution Hide Solution

Correct Answer: B
Question #25

Which feature do you use to dynamically control SAP HANA database workloads per client session?

  • A . Workload analysis
  • B . Non-uniform memory access (NUMA)
  • C . Admission control
  • D . Workload classes

Reveal Solution Hide Solution

Correct Answer: D
Exit mobile version