Databricks-Certified-Data-Analyst-Associate 試験問題を無料オンラインアクセス

After running DESCRIBE EXTENDED accounts.customers;, the following was returned:

Now, a data analyst runs the following command:
DROP accounts.customers;
Which of the following describes the result of running this command?

• A.Running SELECT * FROM accounts.customers will return all rows in the table.
• B.Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.
• C.The accounts.customers table is removed from the metastore, but the underlying data files are untouched.
• D.The accounts.customers table is removed from the metastore, and the underlying data files are deleted.
• E.All files with the .customers extension are deleted.

Where in the Databricks SQL workspace can a data analyst configure a refresh schedule for a query when the query is not attached to a dashboard or alert?

• A.The Dashboard Editor
• B.The Query Editor
• C.Data bxplorer
• D.The Visualization editor

What describes Partner Connect in Databricks?

• A.it allows multi-directional connection between Databricks and Databricks partners easier.
• B.It exposes connection information to third-party tools via Databricks partners.
• C.It is a feature that runs Databricks partner tools on a Databricks SQL Warehouse (formerly known as a SQL endpoint).
• D.it allows for free use of Databricks partner tools through a common API.

Which of the following commands will return the location of database customer360?

• A.DROP DATABASE customer360;
• B.DESCRIBE DATABASE customer360;
• C.USE DATABASE customer360;
• D.ALTER DATABASE customer360 SET DBPROPERTIES ( ' location ' = ' /user ' );
• E.DESCRIBE LOCATION customer360;

Which example of data projects represents a common analytics application to be completed in Databricks SQL?

• A.Testing the latency of real-time streaming workloads
• B.Performing analysis-specific ETL on gold-layer tables
• C.Predicting customer churn by automatically developing time-series models
• D.Monitoring the performance of deployed machine learning solutions