Cpuqa

I have no idea what these are.

cPanel & WHM Administrator - Core Curriculum

Databases Administration in WHM

Introduction quiz:

Which of the following statements are true about MyISAM? (Select all that apply)

It implements indexes and locking.
It is the default storage engine on older versions of MySQL.

The second question was to match terms, on the screen.

True/False: By default, you can connect to a MySQL/MariaDB database from anywhere with the correct username and password and see all your databases.

False

Managing Users and Databases Quiz:

The first question is to arrange the mysql terms.

True/False: If you have prefixing turned on in Tweak Settings, the database management tools in WHM will enforce it.

False

True/False: The customer should always be aware of their MySQL root password, and will make use of it frequently.

False

Networking Quiz

The Additional Access Hosts feature in WHM creates grants (select all that apply)

when you create new cPanel accounts (after setting up an additional access host)
when you click on the link at the bottom of the page

Remote MySQL server environment connections can be set up via a cPanel & WHM environment by using what WHM feature?

Manage MySQL Profiles

Remote MySQL Profiles can be used to set up what kind of relationships?

1-to-1 (1:1) only

Repairs, Restores, Backups and Upgrades Quiz

True/False: WHM contains a feature to allow you to import a SQL dump from MySQL into Postgresql. False

True/False: EasyApache needs to be run after upgrading MySQL/MariaDB. True

What types of tables can you repair through WHM? MyISAM

End of Course Test

These may be out of order, or different questions might be present"

When using the database mapping tool, you select the user from the drop down list, but must type the name of the database into a text field.

(Unknown if correct) Which of the following do you need to know to set up a Remote MySQL Server? (Select all that apply.)

-remote SSH port
-authentication details necessary to obtain root SSH on the server
-remote server address

Match each advanced database term with its definition.

storage engine - the software used by a database to manage the underlying data
myisam   -   the basic storage engine for mysql.
SQL   -   how users get data into and out of a database.
innodb -   the advanced storage engine for mysql.
index   -   a special data structure that makes lookups on large tables faster.

The Additional Access Hosts feature in WHM creates grants (select all that apply)

-when you create new cPanel accounts (after setting up an additional access host)
-when you click on the link at the bottom of the page

True/False: If you have databases included in quotas (via Tweak Settings), cPanel & WHM will prevent data from being entered into a database whose associated user is over quota.

False

True/False: You can export all your MySQL databases in one go with phpMyAdmin.

-True

True/False: The “Manage Databases” page in WHM allows you to rename your databases, but still keep the existing users and their grants/permissions.

-True

Match each database related term with its definition.

table   -   the relation in relational databases; it represents a group of similar objects
database -   a structured set of data
entries   -   a "row" in the table; it represents an instance of the object defined by the table.
locking   -   marking a table or row so that only one process accesses it at a time
querying   -   asking the database to find some information for you.
grants   -   how permissions are handled
field   -   a “column” in the table; it represents a trait of the object defined by the table.

Select the true statement about Remote MySQL Servers.

Remote MySQL Servers can reduce load on the WHM Server.

Which of the following statements are true about MyISAM? (Select all that apply)

-It is the default storage engine on older versions of MySQL.
-It implements indexes and locking.

What types of tables can you repair through WHM?

MyISAM

Match each database with its description.

information schema   -   a database that contains information about all the other databases, but exists only in memory.
whmxfer   -   a database that stores information on transfers done with the Transfer Tool in WHM
leechprotect   -   a database that stores hit counters for a feature that limits excessive activity on password protected directories
cphulkd   -   a database that contains information for brute force attack detection
modsec   -   a database that stores the hits list for the WHM Mod Security Tools interface
eximstats   -   a database that contains data for the Mail Statistics Summary page in WHM
roundcube   -   a database that stores contacts for round cube email accounts

Match each database basics term with its definition.

query   -   When you ask a Database Management System to find some information for you.
entry   -   Represents a single instance of an object in a database. A "row".
field   -   Represents a trait of the object defined by the table. A "column".
database   -   A structured set of data.
grants   -   How permissions are handled inside a database.
locking   -   Marking a table or row so that only one process can access it at a time.
table   -   Represents a group of similar objects in a database. The relation in "relational databases".

What is an InnoDB data dictionary?

-a part of the InnoDB storage engine that maps data to it the file it’s located in

cPanel Simplifies the default MySQL grants by applying grants per Database Grants for the same user from different hosts are Applied uniformly

The Additional Access Hosts feature in WHM creates grants that are similar to the grants in which cPanel Interface?

-Remote MySQL >> Add Access Hosts

DNS Administration in WHM

Quiz: Intro

What happens when your zone has two NS records?

both records are returned

What happens when your zone has no MX records?

-the A record is used to determine where mail should be sent

Match each term with its definition

resolve   -    acquire the IP address for a domain
authoritative   -   considered accurate
propagation   -   movement of a change throughout a distributed system
nameserver   -   software that answers queries to the internet protocol’s directory service

Quiz: Basic Setup

Where in the WHM interface do you enter the default nameservers for accounts created by root?

-WHM Home >> Server Configuration >> Basic cPanel & WHM Setup

What is a resolver?

-a nameserver that can resolve non-local domains

When are nameservers used? (select all that apply)

to determine where to send mail for a domain
to visit websites on shared IP addresses
in spam prevention algorithms

Quiz: Mail and DNS

Match each term with an example of it.

SPF   -   animals.test. IN TXT "v=spf1 +a +mx +ip4:10.6.52.192 ~all"
DKIM   -   default._domainkey IN TXT "v=DKIM1; k=rsa; p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4WzzkkipFSDTptsax/bECLNsdQ5KqE6Rb8/jyrqGn475PjrnPMpH1wGrNLs3eA4F0TupgsenxcpqPklk9OPVLo7AtEMqAtbaB3czL/lMzbyuwWu+qOhOsOJppRajprNR/Zs5jtY6pbSPyJJv00Nx3vt
PTR   -   7 14400 IN PTR example.test.

Where can you add SPF and DKIM records to an account? (Select all that apply)

in the user’s cPanel interface
during account creation
in WHM Home >> Account Functions >> Modify Account

You can create reverse DNS zones in WHM with what functionality?

DNS Functions >> Add a DNS Zone, then DNS Functions >> Edit DNS Zone

Quiz: Customizations and Troubleshooting

If you have just added a custom record to your zone template, how can you apply it to already existing zones? (Select all that apply) '- I think the ones with the hyphens are correct.'

The next time you load the zone file in the editor, the records from the zone template will appear and you only need to save.
you do not need to take action - this is done automatically.
-You can reset existing zones (and lose any specific customizations)
-You can edit existing zones with customizations to add the new custom record.

If you cannot edit a zone in the WHM editor because it has been incorrectly customized, what function do you use to reapply the zone template and remove any customizations?

-WHM »DNS Functions »Reset a DNS Zone                                                                                               

Which of the following tasks can be done through WHM? (Select all that apply)

-changing an MX record                                                                                                              
-resetting a zone back to the template

Quiz: DNS Clustering

Redundancy is: (select all that apply)

-having more than one of something, so that a backup is always ready
-generally a good idea

cPanel & WHM servers that are in a clustering arrangement have a “root trust” with each other. This means that:

-all these statements are correct

DNS clustering with DNS Only can provide which benefits? Select all that apply.

-DNS redundancy
-lower load on the cPanel server

Final Test: DNS Administration in WHM

A cluster is:

-two or more servers that all do the same job

True/False: By default, cPanel creates SPF records in a testing mode.

-True

What happens when your zone has two NS records?

-both records are returned

Pair each nameserver with its strengths.

MyDNS      the fastest nameserver; handles large numbers of domains well.
BIND      the most versatile nameserver software.
NSD      the most lightweight nameserver.

If you have just added a custom record to your zone template, how can you apply it to already existing zones? (Select all that apply)

-you can edit existing zones with customizations to add the new custom record
-you can reset existing zones (and lose any specific customizations)

When you are using a 1:1 NAT setup, the List Accounts WHM interface will show

-the public IP address

What happens when your zone has no MX records?

-the A record is used to determine where mail should be sent

DNS Clustering uses what type of authentication?

-access keys

DNS templates are used (Select all that apply):

-when a reseller needs to set up a customization across all their accounts
-when you need to set up the same customization across all your accounts

Put these queries in order from queried first to queried last:

   root nameservers
   TLD (.com, .net, etc) nameservers
   Domain’s authoritative nameservers