wk 7 quiz

Which of these is a pane of the Data Source page displaying the data sources? A) Connections B) Sheets C) Pages D) Show Me

A) Connections The Connections pane of the Data Source page displays the data sources. Users can add additional data sources by clicking Add. Answer B is incorrect. The Sheets pane displays all the sheets in the Excel file, corresponding to the names of individual worksheet tabs. Answer C is incorrect. The Pages shelf allows users to break a view into a series of pages to better analyze how a specific field affects the rest of the data. Answer D is incorrect. The Show Me card is a collapsible card that shows application visualization types for a selected measure and dimension.

Which of the following is used to replace the data source with any other connected data source at either the worksheet or workbook level? A) From the top menu bar, select Data Source > Change Data Source. B) From the top menu bar, select Data Source > Replace Data Source. C) From the top menu bar, select Data > Change Data Source. D) From the top menu bar, select Data > Replace Data Source.

D) From the top menu bar, select Data > Replace Data Source. From the top menu bar, select Data > Replace Data Source to replace the data source with any other connected data source at either the worksheet or workbook level.

Joshua is working as a data analyst for a telecommunications company offering different services. The company recently acquired another telecommunications company and needs to merge its customer data with the existing customer data. He wants to combine the acquired customer table with the existing customer table to create a single table that includes all customers from the acquired company along with any matching customers from the existing table. Which of the following types of join should he use to accomplish the task? A) Right B) Full outer C) Inner D) Left

A) Right Joshua should use a right join to create a single table that includes all customers from the acquired company along with any matching customers from the existing table. A right join combines tables to produce a table that contains all values from the right table and corresponding matches from the left. Answer B is incorrect. A full outer join combines tables to produce a table that contains all values from both tables. Answer C is incorrect. An inner join combines tables to produce a new virtual table that contains values that have matches in both tables. Answer D is incorrect. A left join combines tables to produce a new virtual table that contains all values from the left table and corresponding matches from the right table.

Which of the following displays all the sheets in the Excel file, corresponding to the names of individual worksheet tabs? A) Sheets B) Show Sheets C) Pages D) Show Me

A) Sheets The Sheets pane displays all the sheets in the Excel file, corresponding to the names of individual worksheet tabs. To connect to a sheet, drag and drop it into the data connection canvas to the right or double-click the desired sheet. Answer C is incorrect. The Pages shelf allows users to break a view into a series of pages to better analyze how a specific field affects the rest of the data. Answer D is incorrect. The Show Me card is a collapsible card that shows application visualization types for a selected measure and dimension.

Which of these are the cons of the Live connection? Each correct answer represents a complete solution. Choose all that apply. A) Can result in a slower experience B) Some cloud-based data sources must be extracted C) Most OLAP data sources cannot be extracted D) Must be refreshed periodically

Answers A and B are correct. The following are the cons of the Live connection: - Can result in a slower experience - Some cloud-based data sources must be extracted Answers C and D are incorrect. The following are the cons of the Extract connection: - Most Online Analytical Processing (OLAP) data sources cannot be extracted - Must be refreshed periodically

Which of these are the pros of the Extract connection? Each correct answer represents a complete solution. Choose all that apply. A) Can deter latency in a slow database B) Could reduce the query load on critical systems C) Leverage a high-performance database's capabilities D) See real-time changes in data

Answers A and B are correct. The following are the pros of the Extract connection: - Can deter latency in a slow database - Could reduce the query load on critical systems Answers C and D are incorrect. The following are the pros of the Live connection: - Leverage a high-performance database's capabilities - See real-time changes in data - Offers the best security in most organizations

Which of the following are the minimum requirements of the Mac operating system for Tableau Desktop?Each correct answer represents a complete solution. Choose all that apply. A) macOS Mojave 10.14, macOS Catalina 10.15, and Big Sur 11.4+ B) Intel processors C) M1 processors under Rosetta 2 emulation mode D) CPUs must support SSE4.2 and POPCNT instruction sets E) 4 GB free disk space

Answers A, B, C, and D are correct. The following are the minimum requirements of the Mac operating system for Tableau Desktop: - macOS Mojave 10.14, macOS Catalina 10.15, and Big Sur 11.4+ - Intel processors - M1 processors under Rosetta 2 emulation mode - CPUs must support SSE4.2 and POPCNT instruction sets - 1.5 GB free disk space

Which of the following are the elements of a Tableau workbook? Each correct answer represents a complete solution. Choose all that apply. A) Sheet B) Dashboard C) Story D) Workspace

Answers A, B, and C are correct. The following are the elements of a Tableau workbook: Sheet: It is used for creating individual visualizations. Dashboard: It is used for combining multiple sheets, as well as other objects such as images, text, and web pages, and adding interactions between them, such as filtering and highlighting. Story: It is based on different views and explorations of a single visualization, seen at different stages, with different marks filtered and annotations added. Answer D is incorrect. The Tableau workspace consists of menus, a toolbar, a Data pane, cards and shelves, and one or more sheets.

What happens when the Tableau logo button is clicked? A) It opens a new blank workbook. B) It returns to the start page. C) It saves and exports the current project. D) It displays Tableau Help and Documentation.

B) It returns to the start page. When the Tableau logo button is clicked, it returns to the start page. The start page in Tableau Desktop is a central location consisting of three panes, namely, Connect, Open, and Discover.

You are working as a data analyst for an automobile rental company. You are working on the Customers and Rentals tables storing the customer data. These tables contain the following fields: Customers: CustomerID, Name, Email, Reg_Date Rentals: RentalID, CustomerID, Rental_Date, Type, Model, Duration You want to create a table displaying all the records for the customers who have registered on the website and have rented a vehicle. Which of the following types of joins should you use to accomplish the task? A) Right B) Left C) Full outer D) Inner

B) Left You should use a left join to create a table displaying all the records for the customers who have registered on the website and have rented a vehicle. A left join combines tables to produce a new virtual table that contains all values from the left table and corresponding matches from the right table. Answer A is incorrect. A right join combines tables to produce a table that contains all values from the right table and corresponding matches from the left. Answer C is incorrect. A full outer join combines tables to produce a table that contains all values from both tables. Answer D is incorrect. An inner join combines tables to produce a new virtual table that contains values that have matches in both tables.

XYZ Solutions Inc., a service-based company, handles multiple data analytics projects using Tableau products. The company wants to use a Tableau product for handling one of its major clients. This product should extend the client data across the entire firm for enterprise-wide deployments providing centralized governance, visibility, and control to the employees working on the project. Which of the following Tableau products should be used in the given scenario? A) Tableau Public B) Tableau Desktop C) Tableau Server D) Tableau Prep

C) Tableau Server Tableau Server should be used in the given scenario as it extends the value of data across the entire organization for enterprise-wide deployments and is intended for the organization-wide provision of visual analytics outputs through a central repository for Tableau work. It provides organizations with centralized governance, visibility, and control while allowing users to curate, publish, and share data sources as well as collaborate, engage, and explore data. Answer A is incorrect. Tableau Public is a free service that allows users to publish interactive data visualizations online. Answer B is incorrect. Tableau Desktop is an application that allows connection to data on-premises or in the cloud and facilitates the entire visual discovery and analytics process, from connecting to data to sharing visualizations, dashboards, and interactive stories using Tableau Server and Tableau Cloud. Answer D is incorrect. Tableau Prep is used to connect to data on-premises or in the cloud and provides robust data preparation capabilities using Tableau's familiar visual interface.