Oracle MySQL PreSales Specialist Assessment 1

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

1.MySQL 1.MySQL Enterprise Authentication allows a user to use which of t he following Mark for Review to login to MySQL without needing a MySQL user name and password? (2) (2) Poin Points ts (select all that apply)

(Choose all correct answers)

Pluggable authentication modules (*) Windows via Kerberos (*) LDAP directory information (*) Proxy (*)

Incorrect: MySQL Enterprise Authentication provides many ways for users to simplify password management by using OS-level user names and passwords for MySQL authentication.

2.Which 2.Which of the following are variables you can e nforce when a user creates a password? (select all that apply)


Password length (*) Password must contain a special character (*) Password must contain a number (*) Password mixed case count (*)

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

Correct: You can specify the password length, and mandate the requirement of a set number of use of mixed-case characters, numeric characters or special characters when whe n creating your password policy.

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

3.Please 3.Please choose the reasons why customers buy MySQL Enter prise Edition. (Choose all that apply)



24x7 support (*) Low TCO (*) Business Critical Applications (*) Risk Mitigation (*)

Correct: Customers choose MySQL EE for 24 x7 support, risk mitigation, low TCO, and for business critical applications

4.Why 4.Why is MySQL the best choice for Web & Cloud Applications? (Choose all the apply)


Leading open source databsae for web applications (*) Integrated with Hadoop in Big Data platforms (*)


World's most popular open source database (*) #1 open source database in the C loud (*)

Correct: MySQL is the best choice for Web & Cloud Applications because it is the world's most popular open source database, is the leading open source database for web apps, is the #1 open source database in the cloud, and can be integrated with Hadoop in Big Data platforms

5.MySQL 5.MySQL Enterprise support includes which features?



Hot fixes & maintenance releases (*) Consultative support (*) Limited incidents (*) 24x7x365 support

Incorrect: MySQL Enterprise support includes hot fixes and maintenance releases, 24x7x365 support, and Consultative support.

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

6. Which filtering items below below apply to the Query Analyzer Analyzer for zeroing in on queries to investigate? (select all that apply)



Filter by statement type (SELECT, INSERT, UPDATE….) (*)

Filter by a time range interval or between 2 points in time (*) Filter by statement text (using regular expressions or normal search) (*) Filter by database name (*)

Correct: All of these answers are correct. This represents the methods in which queries can be filtered to isolate problematic items, or alternatively to prove fast response times when the database performance is in question.

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


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

Incorrect: 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.

MySQL - Overview of High Availability & Replication


(Answer all questions in this section)

8. What is the configuration entry used to only allow allow GTID safe transactions and and Mark for Review is intended to be implemented prior to turning on G TID activity to as a (2) (2) Poin Points ts prepare task to ensure it'll work?

enforce-gtid-consistency (*) sync_binlog gtid_mode log-bin

Correct: The configuration "enforce-gtid-consistency" is this option that enables the safety check. The other configurations although are related to replication do not provide this functional test and safety mechanism.

9. An application stores a lot lot of images in blobs blobs in the database. It endures far Mark for Review more read-only access even on those blobs holding images, than it does (2) (2) Poin Points ts write access to the data. What HA options would suit this design? (select all that apply)


Active/Passive solution like DRBD, Solaris Cluster, etc MySQL Cluster CGE Fabric (*) Replication with GTIDs (*)

Incorrect: Replication with GTIDs is the c ore answer here, followed by Fabric. The scenario identifies a thorough need for replication slaves to work on scaling out read-only activity. In this sense, Fabric works as well. Also, if the application is sharding capable, then Fabric would be the ideal solution. The active/passive HA solution in itself doesn't

address read-scalability as the option doesn't explicitly state an underlying replication capacity, which only a few active/passive solutions support. Also MySQL Cluster CGE does not work well with blobs and solutions dependent on blob data should remain with the core MySQL Server and not Cluster CGE. In reality, this example reflects real-world use case for companies like Flickr where image uploading is a much more in-frequent task, but browsing those images is really where the substantial workload of the website is experienced.

10.Choose the options that describe the Fabric systems features. (select all that t hat apply)



Provides synchronous replication of data Provide updated application connector configurations when a failover occurs or other changes happen on the shard or replication topology (*) Manage data sharding across multiple master servers (*) Auto-failover and promotion of new master (*)

Incorrect: Features of Fabric include auto-failover and promotion of a new master, management of sharded data across master servers. It also provides the service of having available connector configurations available for the application servers to ensure that when the replication topology changes, they'll be able to pull the new configuration layout. Fabric does NOT provide synchronous replication through its design or otherwise. It re-uses the replication c apabilities of the underlying server, typically asynchronous.

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

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


IBM DB2 Percona Oracle Database (*) Microsoft SQL Server

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

12.Which of the t he following does NOT describe MySQL?


Ideal for high volume, low margin applications The “M” in the LAMP Stack World’s most popular open source relational database

Linux only platform (*)

Correct: MySQL is the "M" in the LAMP stack, the world's most popular open source database, runs on multiple platforms, and is ideal for high volume/low margin applications.

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

13.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 on MySQL “collector” and auditing (1) (1) Poin Points ts data from MySQL packets on network?

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

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

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


MySQL Cluster Carrier Grade Edition (*) MySQL Standard Edition MySQL Enterprise 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.

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


15.Which customer profiles should you t arget for positioning MySQL Cloud Service?



Existing MySQL Customers (*) Customers relying on MySQL in another cloud (*) Customers running Oracle Database Cloud Service (*) ISVs moving to SaaS (*)

Correct

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

21.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 (*) VARs can renew MySQL subscription licenses and establish a c onstant revenue stream (*) End users are always seeking new ways to recude IT expenses (*)

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

MySQL - Competition (Answer all questions in this section)

22.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 Standard Edition MySQL Enterprise Edition vs. MS SQL Enterprise 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.

23.Which of the t he following is not a MySQL competitor?

IBM DB2 Microsoft SQL Server MariaDB VMware (*)


Correct: MySQL competitors include MS SQL Server, IBM DB2, and MariaDB

24.What are some of the strategies str ategies employed against MySQL forks? (Please select all that apply)



Oracle's 24x7 Support SLA (*) Risk of Fork's software quality (*) Risk of lock-in with unstable versions of MySQL produced by Forks (*) Lack of Support resources at Fork organizations (*)

Correct: Strategies employed against MySQL forks include: Oracle's 24x7 support, risk of fork's software quality, risk of lock-in with unstable versions of MySQL produced by fork, and lack of support reso urcs at fork's organization

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

25.MySQL Technical Support provides which of the following services?


Knowledge base (*)


Break-fix support (*) Code review (*) Consultative support (*)

Incorrect: MySQL Technical Support provides a range o f technical assistance, including remote troubleshooting; review of replication, partitioning, schema, query; as well as performance tuning, installation support, code review and other features/functions.

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

26.What Community Edition features are only supported with an Enterprise Edition Subscription? (select all that apply)



MySQL Connectors (*) MySQL Utilities MySQL Partitioning (*) MySQL Fabric (*)

Incorrect: While these features are part of the Community license, if you want support for these features, you must purchase an Enterprise Edition license.

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



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

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

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


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

Incorrect: All storage engines are ar e 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 - Target Markets & Market Trends Overview


(Answer all questions in this section)

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



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

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

30.Which company relies on MySQL and Hadoop to display 1 billion advertisements to 60 million people across 430,000 web sites and social network profiles every month?

boo-box (*) Facebook Adzuna Dropbox

Correct: boo-box relies on MySQL and Hadoop to display 1 billion advertisements to 60 million people across 430,000 web sites and social network profiles every month


Oracle MySQL PreSales Specialist Assessment 1

Recommend Documents