Question-26. There are 5000 different color balls, out of which 1200 are pink color. What is the maximum likelihood estimate for the proportion of "pink" items in the test set of color balls?
Correct Answer: C
Explanation Given no additional information, the MLE for the probability of an item in the test set is exactly its frequency in the training set. The method of maximum likelihood corresponds to many well-known estimation methods in statistics. For example, one may be interested in the heights of adult female penguins, but be unable to measure the height of every single penguin in a population due to cost or time constraints. Assuming that the heights are normally (Gaussian) distributed with some unknown mean and variance, the mean and variance can be estimated with MLE while only knowing the heights of some sample of the overall population. MLE would accomplish this by taking the mean and variance as parameters and finding particular parametric values that make the observed results the most probable (given the model). In general, for a fixed set of data and underlying statistical model the method of maximum likelihood selects the set of values of the model parameters that maximizes the likelihood function. Intuitively, this maximizes the "agreement" of the selected model with the observed data, and for discrete random variables it indeed maximizes the probability of the observed data under the resulting distribution. Maximum-likelihood estimation gives a unified approach to estimation, which is well-defined in the case of the normal distribution and many other problems. However in some complicated problems, difficulties do occur: in such problems, maximum-likelihood estimators are unsuitable or do not exist.
How do you upgrade an existing workspace managed table to a unity catalog table?
Correct Answer: B
Explanation The answer is Create table catalog_name.schema_name.table_name as select * from hive_metastore.old_schema.old_table Basically, we are moving the data from an internal hive metastore to a metastore and catalog that is registered in the Unity catalog. note: if it is a managed table the data is copied to a different storage account, for a large tables this can take a lot of time. For an external table the process is different. Managed table: Upgrade a managed to Unity Catalog External table: Upgrade an external table to Unity Catalog
Question 59
Which of the statements is correct when choosing between lakehouse and Datawarehouse?
Correct Answer: E
Explanation The lakehouse replaces the current dependency on data lakes and data warehouses for modern data companies that desire: * Open, direct access to data stored in standard data formats. * Indexing protocols optimized for machine learning and data science. * Low query latency and high reliability for BI and advanced analytics.
Question 60
Which of the following is correct for the global temporary view?
Correct Answer: C
Explanation The answer is global temporary views can be still accessed even if the notebook is detached and attached There are two types of temporary views that can be created Local and Global * A local temporary view is only available with a spark session, so another notebook in the same cluster can not access it. if a notebook is detached and reattached local temporary view is lost. * A global temporary view is available to all the notebooks in the cluster, even if the notebook is detached and reattached it can still be accessible but if a cluster is restarted the global temporary view is lost.
