What is the advantage of selecting the "Only Create Connection" option when importing data? a) Data is added to the data model so you can change the data as needed b) Data is added to the data model and cannot be changes in Excel c) Data is added to a table in a workbook d) It makes it much easier to clean the data by just changing it is Excel, allowing you to bypassw making changes in the source data.

How well do you understand the differences between data definition, data manipulation and data control commands, and when to use each of these commands?

Why is data validation important? Pick one of the data validation tips: How does this tip validate the input data? When and why would you use this tip?

What is metadata, exactly? For a result set, what is metadata? Result set information might be helpful in some situations.

using the design file in the image attached to the question : Normalize the database in the design file Be aware of the possibility of duplicate data. Name in Role and Employee and Emp_Contact_name all refer to the same data. Name and Email in Vendor refer to the Vendor. Assumptions made: An employee works with one or more vendors. An employee may have none or many dependents. An employee may have many roles over the employee's work history and a record should be retained for each role.

Which of the following features are not included in CASE tools?a. Assist in the creation of data models b. Assist in the generation of code c. Assist in the management of peopled. Establish a data repository

Structural and data independence: what's the difference?