Oracle MySQL PreSales Specialist Assessment 2

MySQL - Overview of High Availability & Replication (Answer all questions in this section)

1.When 1.When newly implementing GTIDs on a MySQL 5.6 replication setup that is currently in use, which steps need to be done - sequence isn't part of the question. (select all that apply)

Mark for Review (2) (2) Poin Points ts

(Choose all correct answers)

On the slave(s) adjust replication to use auto-positioning (*) Before starting, test with the appropriate configuration that transactions are safe for GTID usage (*) Stop all the servers, then start them with GTIDs enabled, read_only engaged and slaves setup to not start automatically (*) Put all replication nodes into read_only mode (*)

Correct: All of these steps are involved in implementing GTIDs on an existing replication system that is still only using binary log coordinates. For a new setup that is configured to use GTIDs from the beginning, this extra effort isn't needed. Also, for MySQL 5 .7 the replication cluster can phase in the usage of GTIDs without a full outage occurring.

2.What 2.What is the most basic HA solution with failover support with the least data loss?

Replication using GTIDs (*) Fabric Restore from backups to alternate site MySQL Cluster CGE


Incorrect: Replication with GTIDs is the most basic solution and failover support is provided through our replication utilities as they use GTIDs. Both Fabric and MySQL Cluster have more sophisticated setups surrounding them which are not basic. Restoring from backups to an offsite location can incur hours of data loss if binary logs are not regularly copied off-site, plus the restore can be complex. Although restoring from backups could meet RTO/RPO objectives, it is not suited as an answer to this question as more data loss is likely to occ ur than a typical HA solution.

3.Name 3.Name the 2 log files required when using replication.


The binary log and relay log (*) The binary log and general log The slow query log and general log The audit log and binary log

Correct: The binary log is required o n the master as this is where all transactions land. The relay log is required on the slave and is automatically created upon a slave start process. The r elay log is the recipient of the master server's binary log entries and holds them until they are applied on the slave. The slow query log, general log and audit log have no relevant role for re plication, but provide other uses for the server when and if enabled.

MySQL Enterprise Monitor Demo (Answer all questions in this section)

4.Choose 4.Choose the answers that represent benefits of the MySQL Enterprise Monitor features (select all that apply),



The performance graphs enable quick visual understanding of how a system is performing (*) The Enterprise Backup tool is not exposed on t he monitor, and therefore doesn't apply Agent-based monitoring will allow the server's OS and filesystem to be monitored as well (*) The query analyzer can easily highlight the most ex pensive queries when its collecting query data (*)

Correct: The MySQL Enterprise Backup utility is definitely captured on this monitoring platform. All the other answers are t rue. Graphs, collection of OS metrics and the Query Analyzer provide beneficial uses of this monitor.

5.A 5.A company has 2 network zones. Zone-A co ntains a MySQL Instance that Mark for Review needs monitoring and that zone can send network traffic out to Zone-B. Zone(2) (2) Poin Points ts B contains a MEM Service Manager, but can't send network traffic out to Zone-A. This means the Service Manager itself c an't contact the MySQL instance. What is required to allow the monitoring of this MySQL instance by the Service Manager?

You can configure a "remotely monitored" setup from the Service Manager direct to the MySQL instance to configure this monitoring setup You can install an agent in Zone-B where the Service Manager is located, and use that agent to monitor the MySQL instance in Zone-A You can install an Agent in Zone-A wher e the MySQL instance is located and configure the agent to point to the Service Manager so monitoring m onitoring can be done. (*) You can configure a MySQL Fabric set up from the Service Manager direct to the MySQL instance to configure this monitoring setup

Correct: The correct answer is option 3. The scenario here shows that in the case of a network setup where traffic is restricted in this manner, an agent can be used pass the data to the monitor, thus abiding by the network rules, but enabling the monitor to work. DMZ setups or PCIrelated zones may have designs like this, o r other highly secured spaces. So agent installations can be very valuable in these cases. As noted a Service Manager or Agent installed in Zone-B is restricted from connecting to Zone-A, therefore neither of those options would work.

Intro to MySQL Cloud Service (Answer all questions in this section)

6. Which use cases make the most most sense to consider MySQL Cloud Cloud Service offering?



SaaS apps powered by MySQL (*) New "Born in the Cloud" MySQL Applications (*) Dev/Test (*) Lift & Shift: Migrate existing MySQL applications (*) Hybrid Cloud deployments (*)

Incorrect

7. MySQL Enterprise Edition combined with the power power of the Oracle Cloud deliver a cloud service that is:



Integrated (*) Enterprise Ready (*) Simple (*) Automated (*)

Correct

8. Which attributes of a modern infrastructure infrastructure does MySQL Cloud Service provide to end users?



Security (*) Networking Agility (*) Simplification (*)

Correct

MySQL - Competition (Answer all questions in this section)

9. The best way to win the TCO comparison between MySQL and Microsoft SQL is the compare which two products?

MySQL Standard Edition vs. MS SQL Standard Edition


MySQL Enterprise Edition vs. MS SQL Enterprise Edition (*) MySQL Enterprise Edition vs. MS SQL Standard Edition MySQL Standard Edition vs. MS SQL Standard Edition

Correct:The best way to win the TCO comparison between MySQL and Microsoft SQL is the compare MySQL Enterprise Edition vs. MS SQL Enterprise Edition.

10.What is the tool that end users can use to identify how much money MySQL Enterprise Edition can save them compared to the competition?


MySQL Savers Digest MySQL Investment Calculator MySQL TCO Calculator (*) MySQL Discount Double-Check

Correct:To identify how much money MySQL end customers can save the best tool to use is the MySQL TCO calculator available at http://www.mysql.com/tcosavings/.

MySQL - Competition (Answer all questions in this section)

11.The areas to emphasize when competing with MSFT SQL Server are: (Choose all the apply)


TCO Savings (*)


Open Source (*) Number of features Customer References (*)

Correct: areas to emphasize when competing with MSFT SQL Server are: Open Source, TCO savings, and customer refere nces

MySQL - Product Positioning & Opportunities (Answer all questions in this section)

12.Why should partners be interested in selling MySQL? (Choose all that apply)



Service opportunities are not associated with MySQL sales Popularity of MySQL makes prospecting easier (*) End users are always seeking new ways to recude IT expenses (*) VARs can renew MySQL subscription licenses and establish a co nstant revenue stream (*)

Correct: VARs are interested in selling MySQL because end users are always seeking new ways to reduce IT expenses, MySQL's popularity makes it easy to prospect, VARs can establish a constant revenue stream, and MySQL opens the door to se rvices opportunities

13.Name the easy steps you can take to grow your MySQL sale to six figures?



Encourage your customer to continue using MySQL Community Edition for business or mission critical apps Make sure all servers running the application are covered at the same level (Test/Dev, QA, Prod, Backup) (*) Sell multi-year pre-paid subscriptions (*) Lead with MySQL Enterprise Edition (*)

Correct. The best practices involved in growing the MySQL sale to six figures include: making sure all the servers running the application are covered at the same level; selling multi-year pre-paid subscriptions; and selling enterprise editions when appropriate.

14.Choose the criteria from the following options that would qualify IN a MySQL Enterprise Edition opportunity? (Please select all that apply)


MySQL Community in production and in pain (*) Large DBA staff Budget constrained (*) Use open source (*)

Correct: Best fits for qualifying a good MySQL EE opp include an end user who is using Community Edition and in pain, uses open source technology, budget constrained, and has a small DBA staff


15.Choose the common factors that allow MySQL to easily spread throughout an organizations



Ease of use (*) Simple procurement cycle (*) Performance (*) Reliability (*)

Correct: MySQL Community Edition easily spreads throughout organizations because there is a simple procurement c ycle, performance, reliability, and ease of use.

MySQL Enterprise Security Features (Answer all questions in this section)

16.If you manually change an entry in the mysql.user table, what options do you have to reload user privileges? (select all that apply)


Issue a FLUSH PRIVILEGES command via the mysql command line. (*) Restart the MySQL instance (*) Execute mysqladmin flush-privileges on command line (*) Execute mysqladmin reload on command line (*)


Correct: It is advisable to not manually edit the mysql.user table, but if you do, you should perform these functions to reload the authorization and privilege settings back into memory/cache.

17.MySQL Enterprise Firewall can be installed via which method? (select all that apply)



A dynamic plugin without restarting the server Hardware device between router and server A script located in the MySQL share directory (*) Windows MySQL Installer (*)

Incorrect:The MySQL Enterprise Firewall is built into the MySQL Enterprise Edition, however there are some database tables that must be created prior to using Enterprise Firewall.

MySQL - Target Markets & Market Trends Overview (Answer all questions in this section)

18.Which of the t he following applications are ideal targets for positioning MySQL? (Choose all that apply)


Social Networking (*)


e-Commerce (*) ERP Big Data (*)

Correct: e-Commerce, Social Networking, and Big Data are ideal apps to position MySQL with.

19."MySQL includes customers in which of these vertical markets? (Choose all that apply) "



Telecom (*) Government (*) Retail (*) Web (*)

Correct: MySQL customers can be found in Retail, Web, Government, and Telecom.

MySQL - The Product Overview (Answer all questions in this section)

20.Many of MySQL’s latest architectural improvements improvements have focused on o n which Mark for Review areas? (2) (2) Poin Points ts (Choose all that apply)


Web (*) Cloud (*) Storage ERP

Correct: Many of MySQL's latest architectural improvements have bee n focused on Web & Cloud.

MySQL - The Product Overview (Answer all questions in this section)

21.Please choose the main reason re ason why customers upgrade from MySQL Community to MySQL Enterprise Edition. (Choose all that apply)



Monitoring Tools (*) Advanced Features (*) Oracle Support (*) High Administration

Correct: Customers upgrade from Community Edition to Enterprise Edition for Advanced Features, Monitoring tools, and Oracle support.

22.Choose the attributes that are associated with MySQL Cluster Carrier Grade Edition.



Low TCO (*) SQL only Five 9's availability (*) In-Memory (*)

Correct: The attributes associated with MySQL Cluster Carrier Grade Edition are: five 9’s availability, in -memory, and low TCO.

MySQL - Background & Market Definition (Answer all questions in this section)

23.According to db-engines.com, MySQL is the t he 2nd most popular database in the marketplace behind what other database?


IBM DB2 Oracle Database (*) Percona Microsoft SQL Server

Correct: According to db-engines.com, MySQL is second only to Or acle DB in terms of popularity among databases.

24.Software whose source code is available for modification or enhancement by anyone is known as:


Propietary Software Open Source Software (*) Closed Source Software Unlocked Software

Correct: Software whose source code c ode is available for modification or enhancement by anyone is known as Open Source software

MySQL - Product Functions & Features (Technical) (Answer all questions in this section)

25.What storage engines are available under MySQL Community Edition?


MyISAM (*) NDB (Cluster) (*) InnoDB (*) Master-Master

Correct: All storage engines are available under the Community Edition, and supported under the Standard or Enterprise licenses. The NDB (Cluster) storage engine is only supported under the Cluster Carrier Grade license. Master-Master is replication topology and not a storage engine.


MySQL - Product Functions & Features (Technical) (Answer all questions in this section)

26.MySQL Enterprise F irewall provides protection against which of the following? (select all that apply)



Network intrusion Viruses Unauthorized database queries (*) SQL-injection attacks (*)

Incorrect: The MySQL Enterprise Firewall protec ts against unauthorized SQL statements and database queries

27.Your database crashed at 5:00 pm, and your last incremental backup was at Mark for Review 6:00 am. Restoring the database with MySQL Enterprise B ackup to 5:00 pm (2) (2) Poin Points ts requires which of the following? (select all that apply)


Full backup (*) Incremental backup (*) Binary logs (*) Configuration file (my.ini or my.cnf) (*)

Incorrect: You need all of these items to restore the backup. You would need to restore the items in this order: Configuration file, full backup, incremental backup and then apply the binary logs.

28.MySQL Enterprise Audit can be used for which of the following? (select all that apply)



Identify unauthorized searches (*) Satisfy compliance regulations (*) Disable passwords for unauthorized accounts Record logins to the database se rver (*)

Correct: MySQL Enterprise Audit keeps a record of logins, connections and SQL statements.

MySQL - Sales Growth through Upsell & Cross-sell (Answer all questions in this section)

29.Oracle Enterprise Manager for MySQL is included in which editions of MySQL?


MySQL Cluster Carrier Grade Edition (*) MySQL Enterprise Edition (*)


MySQL Standard Edition MySQL Community Edition

Correct: Oracle Enterprise Manager plug in for MySQL is included in MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition ONLY.

30.Which Oracle product can c an be used with w ith MySQL Enterprise Edition to collect Mark for Review local MySQL audit stream XML data based o n MySQL “collector” and auditing (1) (1) Poin Points ts data from MySQL packets on network?

Oracle Audit Vault (*) Oracle GoldenGate Oracle Clusterware Oracle Enterprise Manager

Correct: Audit Vault collects local MySQL audit stream X ML data based on MySQL “collector” and auditing data from MySQL packets o n network

Oracle MySQL PreSales Specialist Assessment 2

Recommend Documents